Automatically Creating INSERT/UPDATE/DELETE Rules on Views

From: "Matt Miller" <pgsql(at)mattmillersf(dot)fastmail(dot)fm>
To: pgsql-general(at)postgresql(dot)org
Subject: Automatically Creating INSERT/UPDATE/DELETE Rules on Views
Date: 2006-11-10 23:39:32
Message-ID: 1163201972.5744.275540214@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lars Heidieker 2006-11-11 00:00:29 Re: FK pointing to a VIEW
Previous Message George Pavlov 2006-11-10 23:21:21 apparent wraparound