Looks pretty sweet, Neil. Maybe you could look at column triggers while you're at it, per comment on Compiere page ;)
Triggers Compiere uses triggers to ensure data consistency. It seems that in general, Oracle triggers are relatively easy to convert. In addition to the Function issues, a procedure needs to be crated per trigger. Oracle and PostgreSQL have slightly different notation of the "new" and "old" references and INSERTING, etc. PostgreSQL Triggers do not support Column restrictions (AFTER UPDATE OF column, column ON table). > - if the statement effects zero rows, a per-statement trigger > is still executed "affects" - sorry couldn't help myself :) Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
