Noah,
Can you please post in plain text?
I'd suggest looking at the postgresql logs to see what is really going
on.
There are no "special" contexts.
Dave
On Mon, 2004-08-30 at 13:01, Noah Davis wrote:
> 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
>
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com