Re: pg_atoi

On Thu, 16 Oct 2003, Kathy Zhu wrote:

> Hi,
>
> I got this message. Is that because the string id too long ??

Are you sure testid is defined as a string type and not an integer?
That'd be the most likely reason for pg_atoi to be called.

> insert into test (testid)
> values('FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16
> 21:13:24 MDT 2003');
>
> ERROR:  pg_atoi: error in
> "FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16
> 21:13:24 MDT 2003": can't parse
> "FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16
> 21:13:24 MDT 2003"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>