Horton

Re: Unreproducible bug in snapshot import code

Alvaro Herrera <alvherre@commandprompt.com>

View thread
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Gurjeet Singh <singh.gurjeet@gmail.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2011-10-24T17:08:30Z
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.

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