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
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) |