Hi
Does anyone have any recommendations on how to migrate Oracle's
'INSTEAD OF' triggers to PostgreSQL's 'INSTEAD OF' rules?
What I would like to do are:
- When there's an insert to the view, the rule would insert the data
into many tables.
- When there's an update, the rule would insert and update data across tables.
- When there's a delete, update fields in some tables.
I have been trying to use INSTEAD OF rules on these tables and SELECT
the functions to do all the work. The problem is the INSTEAD OF rule
doesn't return the command status when it selects the function. As a
result of this, Hibernate (ORM framework) returns exception because it
expects the command to return the status.
Could someone points me to the right direction, or it's not possible
to do this in PostgreSQL?
Regards,
Ben