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