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@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
