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

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: column "id" inherits conflicting default values
Date: 2009-10-05 02:06:42
Message-ID: C6EEB0D2.C5C2B%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2009-10-05 02:09:15 Re: How useful is the money datatype?
Previous Message Tom Lane 2009-10-05 01:43:01 Re: ERROR: column "id" inherits conflicting default values