Hi!
I am seeing such errors in logs:
ERROR: trigger "myapp_assignments" for relation "assignments" already exists
STATEMENT:
BEGIN TRANSACTION;
DROP TRIGGER IF EXISTS "myapp_assignments" ON "assignments";
CREATE TRIGGER "myapp_assignments"
AFTER INSERT OR UPDATE OR DELETE ON "assignments"
FOR EACH ROW EXECUTE PROCEDURE "tblobs_myapp"();
COMMIT;
How is this possible? If I am inside a transaction, this should work, no?
Mitar
--
http://mitar.tnode.com/
https://twitter.com/mitar_m