expected trigger behavior in transactions

Поиск

Список

Период

Сортировка

От	Noah Davis
Тема	expected trigger behavior in transactions
Дата	30 августа 2004 г. 14:01:27
Msg-id	200408301301560.SM01224@Pedro обсуждение
Ответы	Re: expected trigger behavior in transactions
Список	pgsql-jdbc

Дерево обсуждения

Hi,

Forgive me if this isn't directly a JDBC issue.

I have some triggers setup in postgres that are triggered before inserts. They are pretty basic triggers. They update some columns and then continue on with the insert.

We have some java code which starts a transaction (sets auto commit to false) and then performs some inserts. If successful, it commits the transaction. Sometimes, it appears like the trigger is fired but does not commit. Is there a separate connection context for triggers? Do I have to worry about how triggers work within a transaction? If I commit/rollback an insert, does it commit/rollback the triggers which were fired?

It seems like when I do the steps directly in postgres, the triggers are fired appropriately if in a transaction. However, within Java, in some cases the triggers either aren't fired, or are fired, but do not commit when jdbc commits. Any ideas what's going on here?

Thanks for any help,

Noah

______________________________________________

Noah Davis

636 Broadway, Suite 516

New York, New York 10012

p: 212.505.5885

f: 212.505.5655

noah@acadaca.com

www.acadaca.com