Gaetano Mendola <mendola(at)gmail(dot)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:
This is a bug in your function: it will not work if the search path
doesn't contain the public schema. You'd be best advised to make it
qualify the reference to t_public explicitly.
In 8.3 another possibility would be to attach an explicit search_path
setting to the function.
(Of course you realize that referencing any table at all in an
"immutable" function is probably a mortal sin...)
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2008-06-20 14:49:49|
|Subject: Re: Backend Stats Enhancement Request |
|Previous:||From: Michael Meskes||Date: 2008-06-20 10:37:01|
|Subject: Re: ecpg generated files ignorable?|