 | |
PL/Perl and transactions
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: PL/Perl and transactions -
03-14-2008
, 03:09 AM
|
begin Vesa-Matti Kari schrieb: Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how? Any pointers would be appreciated. Thanks! Sure. A function, also a pl/perl - function, runs within a transaction. But you can't do a 'begin' ... 'commit;' within the function. Simply write your function and call it, it's an atomic transaction. |
Regards,
vmk
--
************************************************** **************************
"Hacks are stupid things" - someone
************************************************** **************************
#12
| |||
| |||
|
|
begin Vesa-Matti Kari schrieb: Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how? Any pointers would be appreciated. Thanks! Sure. A function, also a pl/perl - function, runs within a transaction. But you can't do a 'begin' ... 'commit;' within the function. Simply write your function and call it, it's an atomic transaction. |
Regards,
vmk
--
************************************************** **************************
"Hacks are stupid things" - someone
************************************************** **************************
#13
| |||
| |||
|
|
begin Vesa-Matti Kari schrieb: Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how? Any pointers would be appreciated. Thanks! Sure. A function, also a pl/perl - function, runs within a transaction. But you can't do a 'begin' ... 'commit;' within the function. Simply write your function and call it, it's an atomic transaction. |
Regards,
vmk
--
************************************************** **************************
"Hacks are stupid things" - someone
************************************************** **************************
#14
| |||
| |||
|
|
begin Vesa-Matti Kari schrieb: Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how? Any pointers would be appreciated. Thanks! Sure. A function, also a pl/perl - function, runs within a transaction. But you can't do a 'begin' ... 'commit;' within the function. Simply write your function and call it, it's an atomic transaction. |
Regards,
vmk
--
************************************************** **************************
"Hacks are stupid things" - someone
************************************************** **************************
#15
| |||
| |||
|
|
begin Vesa-Matti Kari schrieb: Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how? Any pointers would be appreciated. Thanks! Sure. A function, also a pl/perl - function, runs within a transaction. But you can't do a 'begin' ... 'commit;' within the function. Simply write your function and call it, it's an atomic transaction. |
Regards,
vmk
--
************************************************** **************************
"Hacks are stupid things" - someone
************************************************** **************************
#16
| |||
| |||
|
|
begin Vesa-Matti Kari schrieb: Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how? Any pointers would be appreciated. Thanks! Sure. A function, also a pl/perl - function, runs within a transaction. But you can't do a 'begin' ... 'commit;' within the function. Simply write your function and call it, it's an atomic transaction. |
Regards,
vmk
--
************************************************** **************************
"Hacks are stupid things" - someone
************************************************** **************************
#17
| |||
| |||
|
|
begin Vesa-Matti Kari schrieb: Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how? Any pointers would be appreciated. Thanks! Sure. A function, also a pl/perl - function, runs within a transaction. But you can't do a 'begin' ... 'commit;' within the function. Simply write your function and call it, it's an atomic transaction. |
Regards,
vmk
--
************************************************** **************************
"Hacks are stupid things" - someone
************************************************** **************************
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.