Automatically Creating INSERT/UPDATE/DELETE Rules on Views

Поиск
Список
Период
Сортировка
От Matt Miller
Тема Automatically Creating INSERT/UPDATE/DELETE Rules on Views
Дата
Msg-id 1163201972.5744.275540214@webmail.messagingengine.com
обсуждение исходный текст
Ответы Re: Automatically Creating INSERT/UPDATE/DELETE Rules on Views  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-general
I'm converting a large Oracle DB that uses hundreds of updatable views.
ora2pg is quite useful, but it looks like it doesn't do anything to
create the rules that are needed to make the views updatable.  Under
Oracle simple views like "select * from the_table" are automatically
updatable, so the Oracle schema doesn't have any triggers or the like
that I could import as PG rules.

Any suggestions?

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

Предыдущее
От: "George Pavlov"
Дата:
Сообщение: apparent wraparound
Следующее
От: Tom Lane
Дата:
Сообщение: Re: apparent wraparound