Thread

CREATE VIEW does not work from within plpgsql

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-08-27T22:44:45Z

NAGY Andras (nagya@inf.elte.hu) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
CREATE VIEW does not work from within plpgsql

Long Description
subject says it all.  postgresql 7.0.2, glibc2.1, debian 2.2.

Sample Code

nagya=> CREATE FUNCTION foo() returns int as 'begin create view foov as select 1; return 2; end;' language 'plpgsql';
CREATE
nagya=> SELECT foo();
ERROR:  copyObject: don't know how to copy 631



details:
000827.07:27:22.408 [11383] StartTransactionCommand
000827.07:27:22.408 [11383] query: SELECT foo();
000827.07:27:22.409 [11383] ProcessQuery
000827.07:27:22.411 [11383] query: create view foov as select 1
000827.07:27:22.411 [11383] ERROR:  copyObject: don't know how to copy 631
000827.07:27:22.412 [11383] DEBUG:  Last error occured while executing PL/pgSQL
function foo
000827.07:27:22.412 [11383] DEBUG:  line 1 at SQL statement
000827.07:27:22.412 [11383] AbortCurrentTransaction

No file was uploaded with this report