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

From Alvaro Herrera
Subject Re: Unreproducible bug in snapshot import code
Date
Msg-id 1319476054-sup-6358@alvh.no-ip.org
Whole thread Raw
In response to Unreproducible bug in snapshot import code  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Responses Re: Unreproducible bug in snapshot import code  (Gurjeet Singh <singh.gurjeet@gmail.com>)
List pgsql-hackers
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.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Range Types - typo + NULL string constructor
Next
From: desmodemone
Date:
Subject: Re: [9.1] unusable for large views