On 09/18/2012 01:23 AM, Freddie Burgess wrote:
Thanks Craig,

We were able to make the necessary adjustments to the way Hibernate manages
the data types differently in version 4.1.6, so we got pass this error. Now
we have to tackle the a problem with the hibernate 4.1.6 batcher process no
longer allowing us to ingest data into the database. We are getting the
"nested transactions not supported error", even though the java developers
are telling me that they have only a single commit at the end of  their
logical transaction.

Look at the PostgreSQL logs and see. It's easier to trace if you set log_line_prefix to something like:

log_line_prefix = '<a=%a,u=%u,db=%d,pid=%p,vtx=%v,tx=%x,cmd=%i>'

which produces significantly more verbose logs but makes it easier to, using the pid and txix/vtxid info, work out how different logged statements fit into transactions.

--
Craig Ringer


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to