Postgres Pro
Downloads
Home   >   mailing lists

Automatically Creating INSERT/UPDATE/DELETE Rules on Views - Mailing list pgsql-general

From Matt Miller
Subject Automatically Creating INSERT/UPDATE/DELETE Rules on Views
Date
Msg-id 1163201972.5744.275540214@webmail.messagingengine.com
Whole thread Raw
Responses Re: Automatically Creating INSERT/UPDATE/DELETE Rules on Views  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "George Pavlov"
Date:
Subject: apparent wraparound
Next
From: Tom Lane
Date:
Subject: Re: apparent wraparound