Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_atoi

pg_atoi

From
Kathy Zhu
Date:
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"

Re: pg_atoi

From
Kathy Zhu
Date:
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

Re: pg_atoi

From
Stephan Szabo
Date:
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
>