Re: Inheritance - Mailing list pgsql-general

From Ian Turner
Subject Re: Inheritance
Date
Msg-id Pine.LNX.4.21.0007292343440.830-100000@crafter.house
Whole thread Raw
In response to Re: Inheritance  ("Oliver Elphick" <olly@lfix.co.uk>)
Responses Re: Inheritance
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> `SELECT * FROM Entities*;'
>
> up to and including 7.0.x.
>
> In 7.1, I believe a select on the parent will automatically show the
> children and you will need to do something like `SELECT * FROM ONLY Entities'
> to exclude descendant tables.

Yes, but what about referential integrity? Can I have a table column
reference a column from Entities*? In my experimentation, this is not the
case.

Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE5g87bfn9ub9ZE1xoRAmKzAJwLgpj/eutM7WyWBfiaukLOeA3SmQCeIYbY
pa8M8FA18fnimk5DDF4UlEg=
=W2iE
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Inheritance
Next
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: Inheritance