Re: How to union tables and have a field with UNIQUE constraint?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to union tables and have a field with UNIQUE constraint?
Дата
Msg-id 1002.1010100401@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to union tables and have a field with UNIQUE constraint?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
>> Since triggers on a view won't do anything either, I don't see how one
>> could expect REFERENCES to a view to work.  The system ought to reject
>> all this stuff as unimplemented.

> I think that the insert/update on the fk table will work, but yeah, the
> parts on the pk table won't, so that's no good.  I wouldn't want to
> bother for 7.2, but putting in something to make it so you can't reference
> a view is probably a good idea, at least until we can work out a way
> to make constraints on views work.

Investigation showed that there were a couple of other utility
statements that were also missing adequate checks on permissions and
table type.  I've applied patches.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Rowell
Дата:
Сообщение: top?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: top?