[BUGS] BUG #1900: pgdumpall: false function description for type 'opaque' -
09-20-2005
, 08:21 AM
The following bug has been logged online:
Bug reference: 1900
Logged by: Alexander Kirpa
Email address: postgres (AT) bilteks (DOT) com
PostgreSQL version: 8.1beta2
Operating system: FreeBSD 5.2
Description: pgdumpall: false function description for type 'opaque'
Details:
During move from beta1 to beta2.
pgdumpall>x
psql template1 < x
ERROR: plpgsql functions cannot return type opaque
2005-09-20 08:38:04 EEST 93531 STATEMENT: CREATE FUNCTION uvcount(integer)
RETURNS opaque
AS $_$
BEGIN UPDATE classifier
SET vcount=get_vcount($1)
WHERE classifier.id= $1;
END
$_$
LANGUAGE plpgsql;
Best regards,
Alexander Kirpa
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org |