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-28 13:33:54
Message-ID: d5f60f0c0611280533p53df9f16s282038529b85bda1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> Looks like I've missed your mail, so a late reply.

2006/11/11, Lars Heidieker <lars(at)merlin(dot)de>:

> > > 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.
>
> This would mean something like an index spreading over more then one
> table in the end, or did I miss something ?

Yes. But that is hardly implementable.

------------------------------
Olexandr Melnyk,
http://omelnyk.net/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Serodio 2006-11-28 13:34:39 Re: IS it a good practice to use SERIAL as Primary Key?
Previous Message Andrus 2006-11-28 13:29:44 Re: How to increace nightly backup speed