"Sid" <sbhatt@installs.com> writes:
> 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...
A zero-length string is not a NULL (even if Oracle can't tell the
difference).
Before 7.3, pg_atoi (the integer datatype's input converter) would
sloppily accept a zero-length string as meaning 0 (not NULL). We
fixed that ...
regards, tom lane