Re: Unreproducible bug in snapshot import code

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Unreproducible bug in snapshot import code
Date: 2011-10-24 17:05:55
Message-ID: 3497.1319475955@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> writes:
> Starting from line 89 of terminal1.txt we see this snippet:

> postgres=# rollback;
> ROLLBACK
> postgres=# begin TRANSACTION ;
> BEGIN
> postgres=# set transaction snapshot '000002C8-1';
> ERROR: SET TRANSACTION SNAPSHOT must be called before any query
> postgres=# rollback;
> ROLLBACK

> As is evident from the rest of the lines in terminal1.txt, I have not
> been able to reproduce this error again; I tried even with a clean build of
> the sources.

Given the weird capitalization of the BEGIN command, I'm guessing that
you used tab-completion to enter it. I wonder if this could have been
affected by the execution of some query in support of tab completion?
I couldn't reproduce it either on the basis of that guess, though.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-10-24 17:08:30 Re: Unreproducible bug in snapshot import code
Previous Message Pavel Stehule 2011-10-24 17:02:44 Re: [9.1] unusable for large views (SOLVED)