Re: BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored
Date: 2010-07-15 08:58:51
Message-ID: 2F9B408D3BA1FDCB0664C3EC@[172.26.14.62]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

--On 12. Juli 2010 14:39:19 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Yeah. Past discussions of this have leaned to the viewpoint that we
> should disallow the above, ie it should not be possible to have NOT NULL
> on the parent unless all the children have it too. Nobody's got round
> to implementing it though. There's a TODO item for it: see
> "Move NOT NULL constraint information to pg_constraint"

FYI, i'm currently working on it, see

<https://commitfest.postgresql.org/action/patch_view?id=312>

Bernd

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2010-07-15 12:59:11 Re: BUG #5559: Full SSL verification fails when hostaddr provided
Previous Message Tom Lane 2010-07-14 22:35:55 Re: BUG #5559: Full SSL verification fails when hostaddr provided