From: | Lars Heidieker <lars(at)merlin(dot)de> |
---|---|
To: | Olexandr Melnyk <omelnyk(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: FK pointing to a VIEW |
Date: | 2006-11-11 00:00:29 |
Message-ID: | 908997EE-AED2-40D6-B081-6B783333CCAC@merlin.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)heidieker(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-11-11 00:06:14 | Re: apparent wraparound |
Previous Message | Matt Miller | 2006-11-10 23:39:32 | Automatically Creating INSERT/UPDATE/DELETE Rules on Views |