Scott Ribe <scott_ribe@xxxxxxxxxxxxxxx> writes:
> Should I really have to re-specify the default in this case???
Works for me:
regression=# create sequence s1;
CREATE SEQUENCE
regression=# create table t1 (f1 bigint default nextval('s1'::text::regclass));
CREATE TABLE
regression=# create table t2 (f1 bigint default nextval('s1'::text::regclass));
CREATE TABLE
regression=# create table t3 (f2 int) inherits(t1,t2);
NOTICE: merging multiple inherited definitions of column "f1"
CREATE TABLE
regression=# \d t3
Table "public.t3"
Column | Type | Modifiers
--------+---------+-----------------------------------------
f1 | bigint | default nextval(('s1'::text)::regclass)
f2 | integer |
Inherits: t1,
t2
Can you show an actual test case?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
