Thread: Error message with vacuumed databases
Hi, I have an error when I get the public schema of a database where has been a vacuum process already executed. The message error is: "ERROR: variable not found in subplan target lists" After to accept that message I can work without problems with the database. This error happens only once, the first time when I open the database. This error doesn't appear with databases without a vacuum process seted up. This is the information about my configuration: Software: PgAdminIII 1.0.2 Platform: Windows XP SP1 Language: English Distribution: Binary PostgreSQL: 7.4.1 Regards, Deusdit Correa Cornejo Technical Manager, Voxiva Phone: (511) 2225444 / (511) 2220968 Extension: 140 Email: dcorrea@voxiva.net URL : http://www.voxiva.net The information in this Internet email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Internet email are subject to the terms and conditions expressed in any applicable governing Voxiva's terms of business or client engagement letter.
Deusdit Correa Cornejo wrote: > Hi, > > I have an error when I get the public schema of a database where has been a > vacuum process already executed. The message error is: > > "ERROR: variable not found in subplan target lists" This error has been reported after a column type of a table was changed that is used in a view. If this doesn't apply to you, please send detailed stuff to pgsql-bugs. Regards, Andreas
Hi, I think that is not my case, because I just make a Vacuum to the databases and then I get the error in all the databases where I made the vacuum. I don't change any column type and I guess the vaccum process neither change anything. Anyway, please, tell me what kind of information do you need to recreate this error in your development enviroment? Regards, Deusdit Correa Cornejo Technical Manager, Voxiva Phone: (511) 2225444 / (511) 2220968 Extension: 140 Email: dcorrea@voxiva.net URL : http://www.voxiva.net The information in this Internet email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Internet email are subject to the terms and conditions expressed in any applicable governing Voxiva's terms of business or client engagement letter. -----Original Message----- From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] Sent: Tuesday, July 20, 2004 5:37 PM To: dcorrea@voxiva.net Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Error message with vacuumed databases Deusdit Correa Cornejo wrote: > Hi, > > I have an error when I get the public schema of a database where has been a > vacuum process already executed. The message error is: > > "ERROR: variable not found in subplan target lists" This error has been reported after a column type of a table was changed that is used in a view. If this doesn't apply to you, please send detailed stuff to pgsql-bugs. Regards, Andreas
> "ERROR: variable not found in subplan target lists" > > After to accept that message I can work without problems with the database. > > This error happens only once, the first time when I open the database. This > error doesn't appear with databases without a vacuum process seted up. > > This is the information about my configuration: > > Software: PgAdminIII 1.0.2 > Platform: Windows XP SP1 > Language: English > Distribution: Binary > PostgreSQL: 7.4.1 The first thing to do is to upgrade to 7.4.3 - I believe there are some subquery fixes in that. Chris