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

Re: [NOVICE] DB insert Error

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jasbinder Bali <jsbali(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] DB insert Error
Date: 2006-08-16 05:54:19
Message-ID: 20060816055419.GA51092@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Roger RasmussenDate: 2006-08-16 06:26:21
Subject: Optimal Postgres Development Process, Software
Previous:From: Jasbinder BaliDate: 2006-08-16 05:49:25
Subject: Re: DB insert Error

pgsql-general by date

Next:From: Harpreet DhaliwalDate: 2006-08-16 06:25:13
Subject: Re: Trigger (Calling a Procedure)
Previous:From: Michael FuhrDate: 2006-08-16 05:50:55
Subject: Re: Trigger (Calling a Procedure)

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