Re: [BUGS] Commenting a FK crashes ALTER TABLE statements - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: [BUGS] Commenting a FK crashes ALTER TABLE statements
Date
Msg-id CAB7nPqQW_V0mgMa7khcn6Sj8gEPjef-ruwFVGHVR9J=KTax_KA@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] Commenting a FK crashes ALTER TABLE statements  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Mon, May 15, 2017 at 11:37 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Michael Paquier <michael.paquier@gmail.com> writes:
>> On Mon, May 15, 2017 at 1:05 PM, David Rowley
>> <david.rowley@2ndquadrant.com> wrote:
>>> It seems there's just some missing pstrdup() calls in
>>> RebuildConstraintComment().
>>>
>>> The attached should fix it.
>
>> I was just finishing to debug it :)
>> It is surprising that we have not caught this earlier as comment
>> re-creation handling in ALTER TABLE has been reworked some time ago
>> already. This means that we did not stress this code enough. Attached
>> is the previous fix, completed with a set of regression tests.
>
> Yeah, there should at least be a test case to cover the known crash.
>
> I'll take this one, unless some other committer is already on it.

Thanks. (committed as 12590c5d)
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: postgresql@walla.com
Date:
Subject: [BUGS] BUG #14656: Request to add feature to Position function
Next
From: Michael Paquier
Date:
Subject: Re: [BUGS] BUG #14635: Query is executed slower on hot standby slavedatabase then on master database