On Fri, Dec 3, 2010 at 12:31 AM, Jonathan Vanasco postg...@2xlp.com wrote:
begin w/o commit or rollback?
and thanks. you've been very helpful!
On Nov 30, 2010, at 2:21 PM, Merlin Moncure wrote:
Begin w/o commit is a grave application error and you should
consider reworking your code base
begin w/o commit or rollback?
and thanks. you've been very helpful!
On Nov 30, 2010, at 2:21 PM, Merlin Moncure wrote:
Begin w/o commit is a grave application error and you should
consider reworking your code base so that it doesn't happen (ever).
--
Sent via pgsql-general mailing list
On Nov 30, 2010, at 7:21 AM, Jonathan Vanasco wrote:
i couldn't find anything in the docs, and the project has decent traffic, so
its going to be an issue to log all statements so I can sift through the data
by PID
With machine-readable logs, it shouldn't be *that* serious an issue.
1.
on a project, i find myself continually finding the database locked up with
idle in transaction connections
are there any commands that will allow me to check exactly what was going on in
that transaction ?
i couldn't find anything in the docs, and the project has decent traffic, so
its going
On Nov 30, 2010, at 7:21 AM, Jonathan Vanasco wrote:
on a project, i find myself continually finding the database locked up with
idle in transaction connections
are there any commands that will allow me to check exactly what was going on
in that transaction ?
i couldn't find anything
On Tue, Nov 30, 2010 at 10:21 AM, Jonathan Vanasco postg...@2xlp.com wrote:
on a project, i find myself continually finding the database locked up with
idle in transaction connections
are there any commands that will allow me to check exactly what was going on
in that transaction ?
i