Tom Lane writes:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> >> What's standard about it?
> > ISO/IEC 9075-2:1999 clause 19.1 general rule 1 c) to be exact. ;-)
> Hmm. Looks like we need a wholesale revision of command tags, indeed.
> At least if we want to consider command tags to be the data that
> satisfies this spec requirement.
We would need to do:
ALTER -> ALTER <type of object>
DROP -> DROP <type of object>
CREATE -> CREATE <type of object>
Those look reasonable, and we already do that in some cases.
CLOSE -> CLOSE CURSOR
DECLARE -> DECLARE CURSOR
No opinion here.
COMMIT -> COMMIT WORK
ROLLBACK -> ROLLBACK WORK
Doesn't matter to me.
DELETE -> DELETE WHERE
UPDATE -> UPDATE WHERE
I'd prefer not to do those.
SET CONSTRAINTS -> SET CONSTRAINT [sic]
SET VARIABLE -> SET TIME ZONE
SET VARIABLE -> SET TRANSACTION
SET VARIABLE -> SET SESSION AUTHORIZATION
The first one looks like a mistake. The other ones we could work on.
It also seems to me that CREATE TABLE AS should not print "SELECT". I
thought Fernando Nasser had fixed that. Maybe I'm not completely up to
date in my sources.
Peter Eisentraut peter_e(at)gmx(dot)net
In response to
pgsql-hackers by date
|Next:||From: Bear Giles||Date: 2002-03-20 17:40:49|
|Subject: Re: XML|
|Previous:||From: Neil Conway||Date: 2002-03-20 17:09:16|
|Subject: Re: Notify argument?|
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2002-03-20 17:45:11|
|Subject: Re: [HACKERS] Fixes gram.y |
|Previous:||From: Jan Wieck||Date: 2002-03-20 16:20:20|
|Subject: Re: Eurodates by default|