 | |
PL/Perl and transactions
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
PL/Perl and transactions -
03-13-2008
, 03:24 PM
#2
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#3
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#4
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#5
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#6
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#7
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#8
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#9
| |||
| |||
|
|
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! |
But you can't do a 'begin' ... 'commit;' within the function. Simply
write your function and call it, it's an atomic transaction.
end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
#10
| |||
| |||
|
|
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.