Re: FK pointing to a VIEW

From: "Olexandr Melnyk" <omelnyk(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: FK pointing to a VIEW
Date: 2006-11-10 20:47:01
Message-ID: d5f60f0c0611101247s3ca31cfei48c5674ed646c775@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

> <http://archives.postgresql.org/>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2006-11-10 20:50:52 Re: Request for replication advice
Previous Message Chris Browne 2006-11-10 20:41:23 Re: Request for replication advice