Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table tablename add column - breaks pl/pgsql function returns tablename - Mailing list pgsql-hackers

From Palle Girgensohn
Subject Re: alter table tablename add column - breaks pl/pgsql function returns tablename
Date
Msg-id CE55716E-8C52-4DB1-8536-1F59F4882C0A@pingpong.net
Whole thread Raw
In response to Re: alter table tablename add column - breaks pl/pgsql function returns tablename  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: alter table tablename add column - breaks pl/pgsql function returns tablename  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 

5 nov 2012 kl. 19:36 skrev Robert Haas <robertmhaas@gmail.com>:

> On Thu, Nov 1, 2012 at 12:14 AM, Amit kapila <amit.kapila@huawei.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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Doc patch, distinguish sections with an empty row in error code table
Next
From: Robert Haas
Date:
Subject: Re: Synchronous commit not... synchronous?