Re: [HACKERS] SAVEPOINT syntax again - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] SAVEPOINT syntax again
Date
Msg-id 5543.1092332999@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] SAVEPOINT syntax again  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-patches
Oliver Jowett <oliver@opencloud.com> writes:
> Here's an updated patch that supports the syntax you suggest. I kept the
> error messages, doc examples and regression tests using RELEASE
> SAVEPOINT in full to follow the standard.

As long as we're tweaking syntax to agree with the spec ...

I notice that both SQL99 and SQL2003 require commas between the options
for START TRANSACTION and SET TRANSACTION, whereas our current grammar
has no commas.  I propose that we fix the grammar to allow optional
commas there, to support the standard syntax without breaking existing
apps.

Unless someone objects, I'll add this to Oliver's patch and commit.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: dbsize modification to support tablespaces
Next
From: Bruce Momjian
Date:
Subject: Re: psql - missing tab-completion support for tablespaces