Re: [SQL] ERROR: plan should not reference subplan's variable

2006-05-03 Thread Andrew Sullivan
On Wed, May 03, 2006 at 08:08:22AM +0300, Catalin Pitis wrote: Hi Tom Could you tell me when will 8.1.4 be released with the problem solved? In general, you can't rely on hard release dates in a free software project. Given that's in the STABLE branch, however, you could get it directly from

[SQL] ERROR: plan should not reference subplan's variable

2006-05-02 Thread Catalin Pitis
Hi * I'm trying to run the following SQL statement on a PostgreSQL 8.1, installed on a Windows machine: INSERT INTO PROJECT(PROJECT_ID,PROJECT_DESC) (SELECT MAX(PROJECT_ID),'MYPROJECT'FROM PROJECT WHERE NOT EXISTS (SELECT PROJECT_DESC FROM PROJECT WHERE PROJECT_DESC = 'MYPROJECT')) and I get

Re: [SQL] ERROR: plan should not reference subplan's variable

2006-05-02 Thread Tom Lane
Catalin Pitis [EMAIL PROTECTED] writes: ERROR: plan should not reference subplan's variable Do you have any clue why does this happen? It's a bug :-(. Thanks for the test case --- I'll look into it tonight or tomorrow, if no one beats me to it. regards, tom lane

Re: [SQL] ERROR: plan should not reference subplan's variable

2006-05-02 Thread Tom Lane
Catalin Pitis [EMAIL PROTECTED] writes: ERROR: plan should not reference subplan's variable I've applied a patch for this; will be in 8.1.4. http://archives.postgresql.org/pgsql-committers/2006-05/msg00016.php regards, tom lane ---(end of

Re: [SQL] ERROR: plan should not reference subplan's variable

2006-05-02 Thread Catalin Pitis
Hi Tom Could you tell me when will 8.1.4 be released with the problem solved? Thanks, Catalin On 5/3/06, Tom Lane [EMAIL PROTECTED] wrote: Catalin Pitis [EMAIL PROTECTED] writes: ERROR:plan should not reference subplan's variableI've applied a patch for this; will be in