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 [EMAIL PROTECTED]
>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
