PostgreSQL Newbies - PQresultStatus for a transaction

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

PQresultStatus for a transaction

Martin Atukunda

2005-07-13, 7:23 am

in my c code I have a call like the following:

rs = PQexec(conn, "BEGIN; UPDATE userinfo set batchno=0; UPDATE
adschedule_items set batchno=0;COMMIT;");

the question is this: when checking for failure of the above transaction, how
do I check if the above transaction failed? do i use PGRES_COMMAND_OK?

- Martin -

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links