. May be it
results to resolve your problem...
You can also try "create temp sequence" (review
http://archives.postgresql.org/pgsql-sql/2005-05/msg00126.php)
select 'saludos';
--
Rafa Couto (caligari)
mailto:[EMAIL PROTECTED]
---(end of broadcast)---
s works.
I understand "FOR UPDATE" clause is locking while is selecting rows
only. It does not secure atomic execution from 'SELECT' to 'UPDATE' in
next statement. Is not it?
--
Rafa Couto (caligari)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
right, but I need atomic execution from --BEGIN and
--COMMIT, and manual says it is not possible to have transactions in
PL/pgSQL procedures :-(
May be with LOCK TABLE?
--
Rafa Couto (caligari)
mailto:[EMAIL PROTECTED]
urgentes (sólo texto): [EMAIL PROTECTED]
PGP 0x30EC5C31 [E6BF 11EF FE55