From: | Frank Kurzawa <fkurzawa(at)topazsoftware(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | mike(at)thegodshalls(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Committed updates don't seem to be committed. |
Date: | 2004-06-23 12:21:15 |
Message-ID: | D273959D-C50F-11D8-8567-00039366F1F4@topazsoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Let's assume that there is a bug in hibernate that is causing it to
start a transaction behind my back. I'm trying to understand what
footprints it would leave and I see three possibilities:
a) It later commits the transaction behind my back
b) It later rolls back the transaction behind my back
c) It just leaves the transaction uncommitted/unrolledback/just
dangling out there.
for a): I don't think this could be happening or my data would actually
be in the database
for b): I don't think this could be happening or I would see evidence
of the rollback in the pgsql log
That leaves (c): What would this look like?
If I do a 'ps -efl' should I find a postgres process in a particular
state? ('idle waiting on transaction', 'idle in transaction', or
something else)?
Should there be some other footprints lying around that I can look at?
Some record of the pending transaction in some postgres system tables?
...so call me clueless if you like, because I AM clueless. LOL
Regards,
Frank
On Jun 23, 2004, at 12:20 AM, Tom Lane wrote:
> You should definitely not ignore the possibility that Hibernate is
> broken (or to put it more politely, hasn't fully debugged its
> PostgreSQL
> interface module). I do not recall hearing from any satisfied users of
> Hibernate-on-Postgres before ... in fact I never heard of Hibernate
> before ... so call me clueless if you like, but a few rough edges in
> the
> interface don't seem too implausible from here.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | M. Bastin | 2004-06-23 13:07:16 | Re: where and how can I get a software for postgres - |
Previous Message | cristi | 2004-06-23 10:26:42 | sql |