Skip site navigation (1) Skip section navigation (2)

PQresultStatus for a transaction

From: Martin Atukunda <matlads(at)myrealbox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PQresultStatus for a transaction
Date: 2005-07-13 12:05:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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 -

pgsql-novice by date

Next:From: Gnanavel SDate: 2005-07-13 13:42:54
Subject: Re: INSERT INTO from a SELECT query
Previous:From: JoeDate: 2005-07-12 23:26:53
Subject: Re: feedback form save to database example code to learn?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group