never mind, it was the wrong type.
sorry,
> X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
> Date: Thu, 16 Oct 2003 21:21:41 -0600 (MDT)
> From: Kathy Zhu <Kathy.Zhu@sun.com>
> Subject: [GENERAL] pg_atoi
> To: pgsql-general@postgresql.org
> X-Virus-Scanned: by amavisd-new at postgresql.org
> X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=BAYES_30,
UPPERCASE_25_50
> X-Spam-Level:
> X-Mailing-List: pgsql-general
>
> Hi,
>
> I got this message. Is that because the string id too long ??
> Where is the String length defined ??
> thanks,
> Kathy
>
> 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