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