Re: ERROR: column "id" inherits conflicting default values

[Scott Ribe <scott_ribe@xxxxxxxxxxxxxxx>]

> Can you show an actual test case?

create sequence "DbRowIds";

create table "PatientRelated" (id int8 not null default
nextval('"DbRowIds"'));

create table "Document"  (id int8 not null default nextval('"DbRowIds"'));

create table "PatientDocument" () inherits ("PatientRelated", "Document");

-- 
Scott Ribe
scott_ribe@xxxxxxxxxxxxxxx
http://www.killerbytes.com/
(303) 722-0567 voice



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general