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 valid dump:

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, noone update,

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 that

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 path