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

From Olexandr Melnyk
Subject Re: FK pointing to a VIEW
Date
Msg-id d5f60f0c0611280533p53df9f16s282038529b85bda1@mail.gmail.com
Whole thread Raw
In response to Re: FK pointing to a VIEW  (Lars Heidieker <lars@merlin.de>)
Responses Re: FK pointing to a VIEW  (Lars Heidieker <lars@merlin.de>)
Re: FK pointing to a VIEW  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general

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

2006/11/11, Lars Heidieker <lars@merlin.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/

pgsql-general by date:

Previous
From: "Olexandr Melnyk"
Date:
Subject: Re: Development of cross-platform GUI for Open Source DBs
Next
From: Jakub Ouhrabka
Date:
Subject: Re: vacuum: out of memory error