ERROR: column "id" inherits conflicting default values

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

Responses

Browse pgsql-general by date

  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?