On Tue, Oct 25, 2011 at 2:33 AM, Fujii Masao <masao.fu...@gmail.com> wrote:
> 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. > Great! That settles it then. Reproducible, but not a bug. Thanks, -- Gurjeet Singh EnterpriseDB Corporation The Enterprise PostgreSQL Company
