On Sunday, June 13, 2010, Tom Lane wrote:
> "Jan Merka" writes:
> > After installing postgresql 8.4.4 from sources, I am getting an error
> > ERROR: cache lookup failed for function 2071
> >
> > Test case:
> >
> > SELECT date '2010-01-01' + interval '1 month';
> > ERROR: cache lookup failed f
I see... but anyway this bug does not allow use return record value
from a trigger in table contained at least one dropped column, and
even worse trigger will work on fresh loaded copy of production
database and would pass all possible tests, but on production database
it is stop working. Moreover,
"Jan Merka" writes:
> After installing postgresql 8.4.4 from sources, I am getting an error
> ERROR: cache lookup failed for function 2071
> Test case:
> SELECT date '2010-01-01' + interval '1 month';
> ERROR: cache lookup failed for function 2071
Works for me:
psql (8.4.4)
Type "help" for
The following bug has been logged online:
Bug reference: 5504
Logged by: Jan Merka
Email address: me...@highsphere.net
PostgreSQL version: 8.4.4 and 8.4.3
Operating system: Linux
Description:cache lookup failed for function
Details:
After installing postgresql 8.4.4
Am 11.06.2010 21:19, schrieb Robert Haas:
> On Fri, Jun 11, 2010 at 2:46 PM, Dimitri Fontaine
>> But of course you don't ever do that. What you do once the restore failed on
>> you is fix the schema and the application before to upgrade.
>
> Presumably, you mean that YOU don't ever do that. What
"Maksym Boguk" writes:
> This bug hard to describe. But in general if a table contained dropped
> columns you cannot use return record variable in trigger function.
This is fixed for 9.0 ... or at least the specific test case you provide
doesn't fail. We have not risked back-porting the change t
The following bug has been logged online:
Bug reference: 5503
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 8.4.3
Operating system: Linux 2.6.18-164
Description:error in trigger function with dropped columns
Details:
This bug hard
The following bug has been logged online:
Bug reference: 5502
Logged by: xMoMx
Email address: warit...@gmail.com
PostgreSQL version: 8.3
Operating system: Window
Description:Preparing an array return Bug
Details:
Spending the whole day trying to figure this out myse
