On Tue, Oct 25, 2011 at 2:41 AM, Gurjeet Singh <singh.gurj...@gmail.com> wrote: > On Mon, Oct 24, 2011 at 1:08 PM, Alvaro Herrera <alvhe...@commandprompt.com> > wrote: >> >> Excerpts from Gurjeet Singh's message of lun oct 24 13:55:44 -0300 2011: >> >> > 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 you can see the SET TRANSACTION SNAPSHOT was the first statement >> > in >> > that transaction, and yet the ERROR message says that it is not. >> >> Maybe the tab-completion feature issued a query before the set >> transaction command. > > I have tried reproducing the bug starting from 1 and 2 transactions before > the one shown in snippet, and I used tab-completion to get the same > screen-output as termonal1.txt and yet it's not reproducible.
I could reproduce it when I typed TAB just after typing "set" in "set transaction snapshot". As Tom and Alvaro pointed out, the tab-completion issues a query and which prevents the "set transaction snapshot" command. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
