Keyword

Started by Michael Meskesalmost 28 years ago3 messages
#1Michael Meskes
meskes@topsystem.de

I'm currently trying to get ecpg more in line with the backends parser.
Doing so I found ecpg accepts a syntax the backend doesn't. It's 'commit
work release' which is accepted for compatibility with Oracle. How about
allowing this in the backend, too?

Michael
--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10

#2Thomas G. Lockhart
lockhart@alumni.caltech.edu
In reply to: Michael Meskes (#1)
Re: [HACKERS] Keyword

I'm currently trying to get ecpg more in line with the backends
parser. Doing so I found ecpg accepts a syntax the backend doesn't.
It's 'commit work release' which is accepted for compatibility with
Oracle. How about allowing this in the backend, too?

I don't want to sound too fussy here, but does this statement provide
any functionality missing from the SQL92 syntax 'commit [work]'? If not,
then perhaps Oracle users could start writing portable code if they
cared to?

- Tom

#3Meskes, Michael
meskes@topsystem.de
In reply to: Thomas G. Lockhart (#2)
RE: [HACKERS] Keyword

I wholeheartly agree. AFAIK it does nothing else, but ORACLE likes it.
And most users have experience in ORACLE.

Michael
--
Dr. Michael Meskes, Projekt-Manager | topystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux! | Tel: (+49) 2405/4670-44

Show quoted text

----------
From: Thomas G. Lockhart[SMTP:lockhart@alumni.caltech.edu]
Sent: Freitag, 13. März 1998 16:04
To: Michael Meskes
Cc: PostgreSQL Hacker
Subject: Re: [HACKERS] Keyword

I'm currently trying to get ecpg more in line with the backends
parser. Doing so I found ecpg accepts a syntax the backend doesn't.
It's 'commit work release' which is accepted for compatibility with
Oracle. How about allowing this in the backend, too?

I don't want to sound too fussy here, but does this statement provide
any functionality missing from the SQL92 syntax 'commit [work]'? If
not,
then perhaps Oracle users could start writing portable code if they
cared to?

- Tom