Re: BUG #14434: Drop a table with a serial in an extension

From: phb07 <phb07(at)apra(dot)asso(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14434: Drop a table with a serial in an extension
Date: 2016-11-27 18:06:07
Message-ID: 9996ade9-838c-d289-92cc-56d3a1db2847@apra.asso.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Le 26/11/2016 à 19:36, Tom Lane a écrit :
> phb07 <phb07(at)apra(dot)asso(dot)fr> writes:
>> Le 26/11/2016 à 01:59, Tom Lane a écrit :
>>> Don't see why that's a "workaround". You added the extension membership
>>> for the sequence explicitly, why wouldn't you expect to need to drop it
>>> explicitly? Seems to me the system is behaving properly.
>> Because depending on the way a table has been included in the extension
>> (either directly created inside the extension or first created outside
>> and then linked to the extension) the procedure to drop it some versions
>> later would be different.
> Well, no it wouldn't be, but nonetheless on closer study I think you're
> right that this is a bug. There is code in there that intends to make it
> unnecessary to issue "ALTER EXTENSION DROP member" when an extension
> update script drops a member object; it should be sufficient to just
> drop the object. It was failing to fire in this case because the drop
> was indirect, but it should work anyway.
>
> I've applied a patch for that. Thanks for the report!
Thank You very much, Tom.
>
> regards, tom lane
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2016-11-27 19:15:50 Re: BUG #14435: PGAdmin 4 will not see the server
Previous Message Tom Lane 2016-11-27 16:43:48 Re: BUG #14435: PGAdmin 4 will not see the server