Search Postgresql Archives

Re: FK pointing to a VIEW

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

2006/11/11, Lars Heidieker <lars@xxxxxxxxx>:

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux