Bruce Momjian br...@momjian.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
Takahiro Itagaki wrote:
Bruce Momjian br...@momjian.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
Bruce Momjian wrote:
For primary key, there is no enforcement of the primary key, e.g.:
test= CREATE TABLE parent (name TEXT);
CREATE TABLE
test= CREATE TABLE child (age INT) inherits (parent) ;
CREATE TABLE
test= ALTER TABLE parent ADD primary KEY (name);