Inheritance question - Mailing list pgsql-general

From Richard Harvey Chapman
Subject Inheritance question
Date
Msg-id Pine.LNX.4.10.10006221949330.23838-100000@smile.3gfp.com
Whole thread Raw
Responses Re: How to select a row and an adjacent row?  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List 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.



pgsql-general by date:

Previous
From: Ryan Kirkpatrick
Date:
Subject: Re: Sequences do not obey transactions...
Next
From: Lincoln Yeoh
Date:
Subject: Re: How to select a row and an adjacent row?