From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
---|---|
To: | Jie Liang <jliang(at)ipinc(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-hacker(at)postgresql(dot)org |
Subject: | Re: plpgsql |
Date: | 2001-04-21 01:58:12 |
Message-ID: | 20010420195812.A24166@cc.usu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Fri, Apr 20, 2001 at 04:58:02PM -0700, Jie Liang wrote:
>
> I 've a question about begin...end in plpgsql
> does
> sql stmts in
> begin
> ....
> end;
> will go one transaction?
Read the documentation (programmer's guide). It's all there. It's to
answer your questions that we take the time to write docs in the first
place :)
Short answer: everything in your function is executed in one
transaction. BEGIN and END in PL/pgSQL are NOT the same as in the
transaction semantics.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
If at first you don't succeed, destroy all evidence that you tried.
From | Date | Subject | |
---|---|---|---|
Next Message | Mateusz Mazur | 2001-04-21 19:56:32 | PSQL 7.1 DEBS |
Previous Message | Jie Liang | 2001-04-20 23:58:02 | plpgsql |