Re: [SQL] View unique rowid

2005-06-01 Thread Rafa Couto
. 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)---

Re: [SQL] Transaction in plpgslq

2005-05-24 Thread Rafa Couto
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]

[SQL] Transaction in plpgslq

2005-05-20 Thread Rafa Couto
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