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

Re: [NOVICE] DB insert Error

From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] DB insert Error
Date: 2006-08-16 15:40:40
Message-ID: a47902760608160840l2effd646s96f5c0676feca0a1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
I did commit the transaction by writing
EXEC SQL COMMIT; right after the insert statement.
Then also its not inserting the record and says:
[2998]: ECPGexecute line 97 Ok: INSERT 0 1
and SQLCODE is still 0

~Jas

On 8/16/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> 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: Jasbinder BaliDate: 2006-08-16 16:00:55
Subject: Re: [NOVICE] DB insert Error
Previous:From: Tom LaneDate: 2006-08-16 15:37:26
Subject: Re: libpq Describe Extension [WAS: Bytea and perl]

pgsql-general by date

Next:From: Harpreet DhaliwalDate: 2006-08-16 15:55:39
Subject: Triggers invoking a stored procedure or a C function
Previous:From: Matteo BertiniDate: 2006-08-16 15:23:16
Subject: hint unique result fro union

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