Pessoal,
Preciso dentro de uma PROCEDURE em PL/Tcl:
spi_exec "SELECT currval('log.log_id_seq'::regclass)"
Porém se a curval falhar, chamar outra PROCEDURE ao invés de abortar a
PROCEDURE.
Algo COMO:
try {
spi_exec "SELECT currval('log.log_id_seq'::regclass)"
} finally {
spi_exec "SELECT nextval('log.log_id_seq'::regclass)"
}
Rogério Bassete
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4286 (20090728) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
