savepoint name vs prepared transaction name

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: savepoint name vs prepared transaction name
Date: 2009-10-16 10:55:45
Message-ID: 2f4958ff0910160355s5d157887x6393b77b815cb8d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any reason, why I can't put quotes around name of savepoint, but I
have/can do this for prepare transaction ?

Ie:
SAVEPOINT 'foo'; --- doesn't work
SAVEPOINT foo; --- all grand

PREPARE TRANSACTION 'foo'; --- grand
PREPARE TRANSACTION foo; refuses to work.

It is quite confusing, I feel like some consistency would be nice here.

--
GJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2009-10-16 12:59:13 Re: Wrong estimation of rows for hash join
Previous Message Arnaud Lesauvage 2009-10-16 10:34:02 Re: pgsql2shp : Encoding headache