Re: Unreproducible bug in snapshot import code - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Unreproducible bug in snapshot import code
Date
Msg-id 3497.1319475955@sss.pgh.pa.us
Whole thread Raw
In response to Unreproducible bug in snapshot import code  (Gurjeet Singh <singh.gurjeet@gmail.com>)
List pgsql-hackers
Gurjeet Singh <singh.gurjeet@gmail.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


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [9.1] unusable for large views
Next
From: Shigeru Hanada
Date:
Subject: Re: WIP: Join push-down for foreign tables