Re: FK pointing to a VIEW

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-----

In response to

Responses

Browse pgsql-general by date

  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