5 nov 2012 kl. 19:36 skrev Robert Haas <robertmhaas(at)gmail(dot)com>:
> On Thu, Nov 1, 2012 at 12:14 AM, Amit kapila <amit(dot)kapila(at)huawei(dot)com> wrote:
>>> Is this very hard to fix?
>> Currently the compiled body is not discarded on DDL's, so I believe it is not a bug as per current implementation.
>> However it can be thought of as a new feature.
> Seems like a bug to me.
Please note that this problem does not go away by disconnecting and reconnecting, and other sessions get the error immediately, so the claim that it is bound to a session is false.
The work-around I use now is to "create or replace function ..." with a verbatim copy of what is already the defined function. Seems stupid to me, I agree it seems like a bug.
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2012-11-05 21:19:36|
|Subject: Re: Synchronous commit not... synchronous?|
|Previous:||From: Robert Haas||Date: 2012-11-05 21:15:11|
|Subject: Re: Doc patch, distinguish sections with an empty row in
error code table|