Обсуждение: BUG #1900: pgdumpall: false function description for type 'opaque'

Поиск
Список
Период
Сортировка

BUG #1900: pgdumpall: false function description for type 'opaque'

От
"Alexander Kirpa"
Дата:
The following bug has been logged online:

Bug reference:      1900
Logged by:          Alexander Kirpa
Email address:      postgres@bilteks.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