pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Andre Schubert <andre.schubert@km3.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: REFERENCES
Date: Wed, 13 Mar 2002 07:57:04 -0800 (PST)
Message-ID: <20020313075206.L81426-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3C8F2FA9.EF9C2710@km3.de>


On Wed, 13 Mar 2002, Andre Schubert wrote:

> Hi to all,
>
> i have a simple problem and wont request assistance fro m this list.
> i have to tables
>
> foo:
>         id int8 UNIQUE
>
> bar:
>         id int8 UNIQUE
>         foo_id int8
>
> Now i wont foo_id to be a id which exists in the foo, this could be done
> with foo_id REFERENCES foo (id).
> But what should i do if i want foo_id to be a id existing in foo or to
> be zero(0).
> I have created a view as "select id from foo UNION select 0" and tried
> to REFERENCE against this view, but that
> doesnt work.

Correct, because you cannot currently reference a view.  Currently you
can't do that via just a references constraint, you'd need to make
triggers that do the work of the checks.

Why can't you reference a view? Well, the reason for that is that we'd
need to be able to figure out how to do the referential action checks
against the real tables referenced by the view.  Even if we put triggers
on all data changing operations on each of the tables it's not necessarily
easy to work out what row(s) of the view are being changed by the
operation.  I don't think this is likely to be changed anytime soon.




view thread (6+ messages)  latest in thread

Message-ID: <20020313075206.L81426-100000@megazone23.bigpanda.com>
Permalink:  ../20020313075206.L81426-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20020313075206.L81426-100000@megazone23.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sszabo@megazone23.bigpanda.com, andre.schubert@km3.de
  Subject: Re: REFERENCES
  In-Reply-To: <20020313075206.L81426-100000@megazone23.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox