From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | CREATE VIEW does not work from within plpgsql |
Date: | 2000-08-27 22:44:45 |
Message-ID: | 200008272244.e7RMijI10615@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
NAGY Andras (nagya(at)inf(dot)elte(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2000-08-28 07:15:49 | Re: [PATCHES] to_char() function's bug and it's patch |
Previous Message | pgsql-bugs | 2000-08-27 03:31:16 | views containing aggregates |