I am partitioning a number of tables in our system and am using a view on the real master table with 'instead of’ triggers to insert and update rows. I have used a view because my application uses Hibernate which does not work well with triggers that return a null to indicate no further processing (Hibernate will interpret this as 0 inserts/updates). This all works well but when using the ‘instead of’ trigger, when a column value is changed, I must write a big clause with multiple 'set columnName = NEW.columnName’. I am also generating the scripts for all tables with a generic generator and since the tables have different columns this part of the script must be table specific. Is there any way to do something like update tableName * = New. Or would there be a cost to deleting the row then inserting again - I have read that postgres does this anyway, but I assume it may do this in some efficient way which may not require index updates etc.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
