ecpg help with 7.3

From: "Sid" <sbhatt(at)installs(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ecpg help with 7.3
Date: 2003-01-27 17:48:23
Message-ID: b13rd4$2cgj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

To start with we have recently migrated from v7.2.3 to v7.3, and I have
an embedded SQL code (ecpg) that used to work fine with 7.2.3. With the new
7.3 it gives me an error when inserting into a table,
Cannot Insert in table xyz(-400):50 'ERROR: pg_atoi: zero-length string'
my first guess was that there was a zero length string (NULL) being inserted
in the table... but the attributes of the columns in the table are such that
they can accept NULL's too.
Having done this i tested the same data over 7.2.3 and it worked good. Can
somebody help me with this please .....

Thanks and regards
=Sid

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-01-27 18:03:37 Re: I was spoiled by the MySQL timestamp field
Previous Message Tom Lane 2003-01-27 17:27:16 Re: required rights for PGDATA