Postgres Pro
Downloads
Home   >   mailing lists

Re: block transactions in stored procedures - Mailing list pgsql-novice

From Jaime Casanova
Subject Re: block transactions in stored procedures
Date
Msg-id c2d9e70e0601251402o53407abdp161088a92764d34b@mail.gmail.com
Whole thread Raw
In response to block transactions in stored procedures  (Ghiz x <mrghiz@yahoo.it>)
List pgsql-novice
Tree view 
> 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 ;)

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
Next
From:
Date:
Subject: Update & Lack of Error Message