Re: [GENERAL] possible bug with inheritance?

From: Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] possible bug with inheritance?
Date: 2010-02-17 08:18:24
Message-ID: 20100217171824.A5BA.52131E4D@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> Summary: ALTER TABLE SET NOT NULL on a parent table is passed to the
> child, while ALTER TABLE ADD PRIMARY KEY is not, particularly the NOT
> NULL part of the PRIMARY KEY specification.
>
> That does seem like something that should be fixed.

Yeah, the issue is in our TODO list:
http://wiki.postgresql.org/wiki/Todo
| Move NOT NULL constraint information to pg_constraint
| Currently NOT NULL constraints are stored in pg_attribute without
| any designation of their origins, e.g. primary keys. One manifest
| problem is that dropping a PRIMARY KEY constraint does not remove
| the NOT NULL constraint designation. Another issue is that we should
| probably force NOT NULL to be propagated from parent tables to children,
| just as CHECK constraints are. (But then does dropping PRIMARY KEY
| affect children?)

And the same bug report has been here:
http://archives.postgresql.org/message-id/200909181005.n8IA5Ris061239@wwwmaster.postgresql.org
| BUG #5064: not-null constraints is not inherited

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Satish Burnwal (sburnwal) 2010-02-17 09:48:59 Converting bytea to LargeObject
Previous Message Devrim GÜNDÜZ 2010-02-17 06:45:52 Re: Source RPMs for PostgreSQL 7.4.27 on RHEL4

Browse pgsql-hackers by date

  From Date Subject
Next Message Joachim Wieland 2010-02-17 08:39:18 Listen/Notify payload and interfaces
Previous Message Michael Meskes 2010-02-17 07:50:48 Re: NaN/Inf fix for ECPG