Hi everyone! I need your help with this problem.
I'm using PostgreSQL *9.2 Server* & the latest jdbc
driver: postgresql-9.2-1002.jdbc4.jar
I have a many to one relation. I have this piece of code:
con.setAutoCommit(false); //transaction block start
// Make an insert to one table (Vector)
// After that I insert the childs of the first table with their parent_id
like the FK.
con.commit(); //transaction block end
I have this Trigger:
CREATE *TRIGGER *trigger_update_index *AFTER INSERT*
ON "Vector" FOR EACH ROW
EXECUTE PROCEDURE update_index();
CREATE OR REPLACE FUNCTION *update_index*() RETURNS *TRIGGER *AS
$update_index$
DECLARE
BEGIN
-- Make something
END;
$update_index$ LANGUAGE plpgsql;
What's the problem? that when the trigger fire only the Parent (Vector) was
inserted an not the childs :S so I need that records to be inserted to work
in my function.
I'm trying to make a Trigger, only to *execute after ALL the transaction*.
So, after all the INSERTs INTO (like 5 or 10) I want to launch my function.
I found some information in google about this: "*Constraint Trigger*", that
perhaps I can tell some rules before triggering but I don't know if it is
what I need to and also don't know how to code that.
I appreciate your help a lot.
Thanks ;)
JP Cook
