Re: ALTER TABLE...ALTER COLUMN vs inheritance - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: ALTER TABLE...ALTER COLUMN vs inheritance
Date
Msg-id CA2E4C4762EAE28D68404E75@amenophis
Whole thread Raw
In response to Re: ALTER TABLE...ALTER COLUMN vs inheritance  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers

--On 23. Juli 2010 09:23:56 +0200 Bernd Helmle <mailings@oopsware.de> wrote:

> I'm going to delay this patch until the next commitfest. I'm able to work
> on it only sporadically during the next two weeks, and some remaining
> issues need my attention on this patch:
>
> - ALTER TABLE SET NOT NULL works not properly
> - ALTER TABLE child NO INHERIT parent leaves inconistent state in
> pg_constraint
> - Special case in pg_get_constraintdef_worker() needs more thinking

Attached is my current progress on this work. It handles ALTER TABLE ...
[NO] INHERIT and NOT NULL constraints the same way we do with CHECK
constraints now. ALTER TABLE SET NOT NULL still lags support for this (ran
out of time to this commitfest deadline), but if nobody complains i would
like to add this to the current commitfest as WIP to hear other opinions
about the current approach again.

--
Thanks

    Bernd
Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: top-level DML under CTEs
Next
From: Tom Lane
Date:
Subject: Re: top-level DML under CTEs