On Fri, Dec 3, 2010 at 12:31 AM, Jonathan Vanasco <postgres(at)2xlp(dot)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 so that it doesn't happen (ever).
meaning, you opened a transaction (with 'begin') and didn't close it
with 'commit' (or 'start/end' etc). You opened a transaction but
didn't close it. Don't ever do this, and don't ever leave a
transaction open waiting on indeterminate events, like user input.
merlin