Inheritance question

From: Richard Harvey Chapman <hchapman(at)3gfp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Inheritance question
Date: 2000-06-23 02:52:41
Message-ID: Pine.LNX.4.10.10006221949330.23838-100000@smile.3gfp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I have the following:

CREATE TABLE grand_parent (
num INTEGER
);

CREATE TABLE parent (
count INTEGER
) INHERITS (grand_parent);

Can I define the following table? It doesn't work as written.

CREATE TABLE child (
UNIQUE (num, count)
) INHERITS (parent);

Thanks,

R.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2000-06-23 06:21:17 Re: How to select a row and an adjacent row?
Previous Message Ryan Kirkpatrick 2000-06-23 00:36:34 Re: Sequences do not obey transactions...