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

From Tom Lane
Subject Re: [BUGS] Commenting a FK crashes ALTER TABLE statements
Date
Msg-id 10243.1494859032@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Commenting a FK crashes ALTER TABLE statements  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [BUGS] Commenting a FK crashes ALTER TABLE statements  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
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.
        regards, tom lane


-- 
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: Peter Eisentraut
Date:
Subject: Re: [BUGS] Concurrent ALTER SEQUENCE RESTART Regression
Next
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14648: counts for queries using array unnesting is incorrect