blob: 6e2cca754e3fd5734d45fef67d168479aa497070 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE parent (
a int
);
CREATE TABLE child () INHERITS (parent);
CREATE TABLE grandchild () INHERITS (child);
ALTER TABLE parent ADD COLUMN b serial;
ALTER TABLE parent RENAME COLUMN b TO c;
ALTER TABLE parent ADD CONSTRAINT a_pos CHECK (a > 0);
|
