Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group