Re: FK pointing to a VIEW

Поиск
Список
Период
Сортировка
От Olexandr Melnyk
Тема Re: FK pointing to a VIEW
Дата
Msg-id d5f60f0c0611280533p53df9f16s282038529b85bda1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FK pointing to a VIEW  (Lars Heidieker <lars@merlin.de>)
Ответы Re: FK pointing to a VIEW
Re: FK pointing to a VIEW
Список 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 по дате отправления:

Предыдущее
От: "Olexandr Melnyk"
Дата:
Сообщение: Re: Development of cross-platform GUI for Open Source DBs
Следующее
От: Jakub Ouhrabka
Дата:
Сообщение: Re: vacuum: out of memory error