On Fri, Jun 20, 2008 at 4:37 PM, Tom Lane <
tgl@sss.pgh.pa.us> wrote:
Gaetano Mendola <
mendola@gmail.com> 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:
doesn't contain the public schema. You'd be best advised to make it
qualify the reference to t_public explicitly.
Yes, that's the way we are fixing it. Still I have a bitter taste being able to
create a working database instance that doesn't generate a valid dump.
(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,
delete, insert data in it, so from my point of view it is like I have declared a
static array inside the function declaration.
--
cpp-today.blogspot.com