| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Sid <sbhatt(at)installs(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: *****SPAM***** ecpg help with 7.3 |
| Date: | 2003-01-29 07:15:46 |
| Message-ID: | 20030129071546.GA17353@feivel.fam-meskes.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jan 27, 2003 at 12:48:23PM -0500, Sid wrote:
> 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.
Zero length strings are something different than NULLs. The pg_atoi
message shows that there indeed is a zero length string.
You could enable logging and see exactly what data is sent to the
backend. Please just look into the test cases in ecpg/test and search
for ECPGdebug resp. file descriptor dbgs.
Michael
--
Michael Meskes
Email: Michael(at)Fam-Meskes(dot)De
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Kutschker | 2003-01-29 07:28:54 | Re: How do I unsubscribe? |
| Previous Message | Tom Lane | 2003-01-29 07:14:16 | Re: need much better query perfomance |