Re: [HACKERS] new field content lost

2008-04-18 Thread Gaetano Mendola
Tom Lane wrote: > Gaetano Mendola <[EMAIL PROTECTED]> writes: >> since long time I have implemented a materialized view, today I had to add a >> new field and I faced the following (I believe) bug. >> The bug can be replicated on a 8.2.7 > > Cached plan for the function's UPDATE. Should work okay

Re: [HACKERS] new field content lost

2008-04-17 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > since long time I have implemented a materialized view, today I had to add a > new field and I faced the following (I believe) bug. > The bug can be replicated on a 8.2.7 Cached plan for the function's UPDATE. Should work okay in 8.3 ...

[HACKERS] new field content lost

2008-04-17 Thread Gaetano Mendola
Hi all, since long time I have implemented a materialized view, today I had to add a new field and I faced the following (I believe) bug. The bug can be replicated on a 8.2.7 -- SETUP create table test (a integer, b integer); create table test_trigger (a integer); CREATE OR REPLACE FUNCTION tri