On Saturday 10 April 2004 02:32 pm, Kemin Zhou wrote:
begin; Note the semi-colon
Then the update query;
commit; or rollback;
> I was trying to speed up a simple update query
>
> fri=# begin
> fri-# update tabA set nobegin=tmp.nobegin, noend=tmp.noend
> fri-# from tmp
> fri-# where tabA.acc=tmp.acc;
try a semicolon after the begin ?
begin;
commit;
Greg Williamson
DBA
GlobeXplorer LLC
-Original Message-
From: Kemin Zhou [mailto:[EMAIL PROTECTED]
Sent: Sat 4/10/2004 2:32 PM
To: [EMAIL PROTECTED]
Cc:
Subject:[SQL] begin update ... syntax error
I was trying to
I was trying to speed up a simple update query
fri=# begin
fri-# update tabA set nobegin=tmp.nobegin, noend=tmp.noend
fri-# from tmp
fri-# where tabA.acc=tmp.acc;
ERROR: syntax error at or near "update" at character 7
The same query can be run with no problem if not starting with BEGIN.
Does mea
