Re: block transactions in stored procedures

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Ghiz x <mrghiz(at)yahoo(dot)it>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: block transactions in stored procedures
Date: 2006-01-25 22:02:56
Message-ID: c2d9e70e0601251402o53407abdp161088a92764d34b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Apart from my specific problem, my questioning is on how does one enforce a
> BEGIN WORK;
> ......
>
> COMMIT WORK;
>
> block transaction within a plperl stored procedure
>
>

just execute the function... in postgres all functions run inside a
transaction...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Web2cad 2006-01-26 02:23:51 put text list into table form
Previous Message Michael Fuhr 2006-01-24 21:50:06 Re: default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP