Re: Error message with vacuumed databases

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(at)voxiva(dot)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(at)pse-consulting(dot)de]
Sent: Tuesday, July 20, 2004 5:37 PM
To: dcorrea(at)voxiva(dot)net
Cc: pgadmin-support(at)postgresql(dot)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