Re: FK pointing to a VIEW - Mailing list pgsql-general

From Lars Heidieker
Subject Re: FK pointing to a VIEW
Date
Msg-id 908997EE-AED2-40D6-B081-6B783333CCAC@merlin.de
Whole thread Raw
In response to Re: FK pointing to a VIEW  ("Olexandr Melnyk" <omelnyk@gmail.com>)
Responses Re: FK pointing to a VIEW
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On 10 Nov 2006, at 20:47, Olexandr Melnyk wrote:

> > While I agree in principle that such a thing should be
> > able to be done, it simply isn't possible. (in PostgreSQL, you can't
> > even add an index to a view, which a unique constraint would depend
> > on).
>
> Agreed on that.
>
> But such an extension would require a view to be more than just
> SELECT.
>
> ------------------------------
> Olexandr Melnyk,
> http://omelnyk.net/
>

This would mean something like an index spreading over more then one
table in the end, or did I miss something ?

- --

Viele Grüße,
Lars Heidieker

lars@heidieker.de
http://paradoxon.info

- ------------------------------------

Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind.
      -- Friedrich Nietzsche



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFFVRKiDAkIK9aNPuIRAgh9AJ97OrIyiaSCAn5lwxLtPFG6B7CtdQCfYyRf
Aypj7GBygMNAxVEmYonkL3o=
=hg/j
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "George Pavlov"
Date:
Subject: Re: apparent wraparound
Next
From: Tom Lane
Date:
Subject: Re: apparent wraparound