RE: [HACKERS] Begin statement again
От | Meskes, Michael |
---|---|
Тема | RE: [HACKERS] Begin statement again |
Дата | |
Msg-id | 11720CEF3853D011AC0C00A024B7A9E11125C0@einstein.topsystem.de обсуждение исходный текст |
Список | pgsql-hackers |
How do you set autocommit off in ORACLE embedded SQL? I only know this from ODBC. 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 > -----Original Message----- > From: jwieck@debis.com [SMTP:jwieck@debis.com] > Sent: Friday, March 13, 1998 1:38 PM > To: meskes@topsystem.de > Cc: andreas.zeugswetter@telecom.at; meskes@topsystem.de; > pgsql-hackers@hub.org > Subject: Re: [HACKERS] Begin statement again > > > > > I agree with BEGIN/END being used for PL/pgSQL. But that means I > have to > > add it to ecpg to start a block of PL/pgSQL, e.g. to call a stored > > procedure in ORACLE I need PL/SQL in C. > > > > AFAIK there is no transaction start command in SQL standard anymore. > > Just issue commit and your transaction is flushed. So either I have > to > > remove that feature and go back to explicit transaction start > commands > > or BEGIN WORK resp. BEGIN TRANSACTION are useless. > > But there is AUTOCOMMIT ON/OFF > > > Jan > > -- > > #===================================================================== > =# > # It's easier to get forgiveness for being wrong than for being right. > # > # Let's break this rule - forgive me. > # > #======================================== jwieck@debis.com (Jan Wieck) > #
В списке pgsql-hackers по дате отправления: