Re: [NOVICE] DB insert Error - Mailing list pgsql-general

From Michael Fuhr
Subject Re: [NOVICE] DB insert Error
Date
Msg-id 20060816055419.GA51092@winnie.fuhr.org
Whole thread Raw
In response to Re: DB insert Error  ("Jasbinder Bali" <jsbali@gmail.com>)
Responses Re: [NOVICE] DB insert Error  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
Re: [NOVICE] DB insert Error  ("Jasbinder Bali" <jsbali@gmail.com>)
List pgsql-general
On Wed, Aug 16, 2006 at 01:46:30AM -0400, Jasbinder Bali wrote:
> I changed the datatype from varchar[] to varchar
> ECPGdebug(1,stderr) says
> [2998]: ECPGexecute line 97 Ok: INSERT 0 1
>
> Its not inserting any record even though sqlcode is 0.

Are you committing the transaction?  See the bottom of the
following page:

http://www.postgresql.org/docs/8.1/interactive/ecpg-commands.html

"In the default mode, statements are committed only when EXEC SQL
COMMIT is issued."

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Trigger (Calling a Procedure)
Next
From: "Harpreet Dhaliwal"
Date:
Subject: Re: Trigger (Calling a Procedure)