Re: [SQL] Views Readonly Still?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] Views Readonly Still?
Дата
Msg-id 11299.932859482@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Views Readonly Still?  ("Zot O'Connor" <zot@ZotConsulting.com>)
Список pgsql-sql
"Zot O'Connor" <zot@ZotConsulting.com> writes:
> Are views readonly in 6.51 still?

A view as such is just a SELECT rule; if you want to make it
writable then you need to add some ON INSERT and ON UPDATE and
ON DELETE rules to cause the right things to happen wherever the
data is coming from.  There's no way that the system can intuit
what you might think is the correct behavior...
        regards, tom lane


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

Предыдущее
От: Hector M Banda
Дата:
Сообщение: Questions about Postgresql and other databases
Следующее
От: Philip Warner
Дата:
Сообщение: Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing !