Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PQputCopyData and Rollback/Commit
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Sandeep Khandelwal <sandeep_khandelwal27(at)yahoo(dot)com>
- Cc: pgsql-interfaces(at)postgresql(dot)org
- Subject: Re: PQputCopyData and Rollback/Commit
- Date: Fri, 2 Feb 2007 08:09:04 -0700
On Thu, Feb 01, 2007 at 10:32:21PM -0800, Sandeep Khandelwal wrote: > I am using PQputCopyData function to send data to server one row at > a time. When I am done with the data then I call PQputCopyEnd. > > I want to do rollback when any error occurs. Please help me how > to achieve rollback using these functions. As the documentation for PQputCopyEnd() says, you can pass a non-NULL second argument to force the copy to fail. You could also use PQexec() to execute a BEGIN before the copy and a COMMIT or ROLLBACK after the copy. -- Michael Fuhr
- References:
- PQputCopyData and Rollback/Commit
- From: Sandeep Khandelwal
- PQputCopyData and Rollback/Commit
- Prev by Date: libpq - PGexecPrepared - INT4OID binary parameter mode not working
- Next by Date: Re: libpq - PGexecPrepared - INT4OID binary parameter mode not working
- Previous by thread: PQputCopyData and Rollback/Commit
- Next by thread: libpq - PGexecPrepared - INT4OID binary parameter mode not working
- Indexes: