Re: [SQL] VIEWs and FOREIGN keys

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] VIEWs and FOREIGN keys
Date: 2002-06-10 16:10:42
Message-ID: 20020610091008.T68016-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


On Mon, 10 Jun 2002, Achilleus Mantzios wrote:

>
> can someone have a foreign key constraint that references
> a view??

Not currently in PostgreSQL. Doing so for a general case
gets rather involved.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-06-10 16:12:08 Re: Non-linear Performance
Previous Message Stephan Szabo 2002-06-10 16:09:22 Re: Problem (bug?) with deferred foreign key checks?

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-06-10 16:48:16 Re: Efficient DELETE Strategies
Previous Message Stephan Szabo 2002-06-10 15:58:00 Re: multiple primary keys and reference