Skip site navigation (1) Skip section navigation (2)

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

From: "Alexander Kirpa" <postgres(at)bilteks(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1900: pgdumpall: false function description for type 'opaque'
Date: 2005-09-20 07:18:45
Message-ID: 20050920071845.E0DCCF0BE0@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

pgsql-bugs by date

Next:From: Ing. Jhon Carrillo - Caracas, VenezuelaDate: 2005-09-20 13:11:42
Subject: problem start database
Previous:From: Herley GomezDate: 2005-09-19 19:23:39
Subject: BUG #1898: Problema En Tipo de dato Real.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group