From: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: column "id" inherits conflicting default values |
Date: | 2009-10-05 01:27:45 |
Message-ID: | C6EEA7B1.C5C24%scott_ribe@killerbytes.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In 8.4.1, trying to load a dump from 8.3.5, I get that error from this
statement:
CREATE TABLE "PatientDocument" (
)
INHERITS ("PatientRelated", "Document");
But I do not see any conflict:
# \d "PatientRelated"
Table "v2.PatientRelated"
Column | Type | Modifiers
-------+--------+---------------------------------------------------------
id | bigint | not null default nextval(('"DbRowIds"'::text)::regclass)
...
# \d "Document"
Table "v2.Document"
Column | Type | Modifiers
-------+--------+---------------------------------------------------------
id | bigint | not null default nextval(('"DbRowIds"'::text)::regclass)
...
Should I really have to re-specify the default in this case???
--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-10-05 01:43:01 | Re: ERROR: column "id" inherits conflicting default values |
Previous Message | Tim Landscheidt | 2009-10-05 00:03:38 | Re: Procedure for feature requests? |