Re: plpgsql

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.

In response to

  • plpgsql at 2001-04-20 23:58:02 from Jie Liang

Responses

Browse pgsql-sql by date

  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