Postgres Pro
Downloads
Home   >   mailing lists

savepoint name vs prepared transaction name - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject savepoint name vs prepared transaction name
Date
Msg-id 2f4958ff0910160355s5d157887x6393b77b815cb8d4@mail.gmail.com
Whole thread Raw
Responses Re: savepoint name vs prepared transaction name
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: pgsql2shp : Encoding headache
Next
From: Alban Hertroys
Date:
Subject: Re: Wrong estimation of rows for hash join