Re: Table inheritance foreign key problem

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: achambers(at)mcna(dot)net
Cc: "Postgresql (General)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Table inheritance foreign key problem
Date: 2010-12-22 06:20:07
Message-ID: AANLkTi=TkYu0Ja9N84X_PVv1BfAFtdfByuvw30M_ks=a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 21, 2010 at 9:32 PM, Andy Chambers <achambers(at)mcna(dot)net> wrote:
\
> create table guidebooks (
>  city check (city in (select name
>                         from cities)),
>  isbn text,
>  author text,
>  publisher text);

This is a nice idea. They only problem is that PostggreSQL doesn't
support sub-selects in a tables check constraints:
http://www.postgresql.org/docs/9.0/interactive/sql-createtable.html

--
Regards,
Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil D'Souza 2010-12-22 10:45:33 Re: What Programs Do You Use For PG?
Previous Message Andy Chambers 2010-12-22 05:32:44 Table inheritance foreign key problem