Re: [HACKERS] Not valid dump [8.2.9, 8.3.1]

2008-06-21 Thread Andrew Dunstan
Tom Lane wrote: "Gaetano Mendola" <[EMAIL PROTECTED]> writes: On Fri, Jun 20, 2008 at 4:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote: (Of course you realize that referencing any table at all in an "immutable" function is probably a mortal sin...) Yes Tom I know, in our case

Re: [HACKERS] Not valid dump [8.2.9, 8.3.1]

2008-06-21 Thread Tom Lane
"Gaetano Mendola" <[EMAIL PROTECTED]> writes: > On Fri, Jun 20, 2008 at 4:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > (Of course you realize that referencing any table at all in an >> "immutable" function is probably a mortal sin...) > Yes Tom I know, in our case that table is a lookup table, noo

Re: [HACKERS] Not valid dump [8.2.9, 8.3.1]

2008-06-21 Thread Gaetano Mendola
On Fri, Jun 20, 2008 at 4:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Gaetano Mendola <[EMAIL PROTECTED]> writes: > > we have faced lately dumps not valid, the bug can be replicated using a > 8.2.9 or > > a 8.3.1 server. > > > These are the steps to create the database that will generate a not va

Re: [HACKERS] Not valid dump [8.2.9, 8.3.1]

2008-06-20 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > we have faced lately dumps not valid, the bug can be replicated using a 8.2.9 > or > a 8.3.1 server. > These are the steps to create the database that will generate a not valid > dump: This is a bug in your function: it will not work if the search p

[HACKERS] Not valid dump [8.2.9, 8.3.1]

2008-06-20 Thread Gaetano Mendola
Hi all, we have faced lately dumps not valid, the bug can be replicated using a 8.2.9 or a 8.3.1 server. These are the steps to create the database that will generate a not valid dump: --- CREATE TABLE t_public ( a integer ); CREATE OR REPL