CREATE VIEW does not work from within plpgsql

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

Browse pgsql-bugs by date

  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