plpgsql

From: Jie Liang <jliang(at)ipinc(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-hacker(at)postgresql(dot)org
Subject: plpgsql
Date: 2001-04-20 23:58:02
Message-ID: Pine.BSF.4.10.10104201646290.99410-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I 've a question about begin...end in plpgsql
does
sql stmts in
begin
....
end;
will go one transaction?

i.e.
begin...end have same meaning as sql stmts BEGIN...COMMIT??
if failed, transaction abort?
if select..for update is used then
another update stmt will wait on the same rows??

if begin...end in plpgsql connot have same functionality as
sql, how can I ensure my sql stmts go one transaction??

thanks.

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

Responses

  • Re: plpgsql at 2001-04-21 01:58:12 from Roberto Mello

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2001-04-21 01:58:12 Re: plpgsql
Previous Message nusa 2001-04-20 23:54:23 HELP : Can't load JDBC driver !