Horton

Re: Unreproducible bug in snapshot import code

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gurjeet Singh <singh.gurjeet@gmail.com>
Cc: PGSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2011-10-24T17:05:55Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Don't trust deferred-unique indexes for join removal.

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