pg_atoi

Started by Kathy Zhuover 22 years ago3 messagesgeneral

Kathy.Zhu@Sun.COM

over 22 years ago

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"

Kathy Zhu

Kathy.Zhu@Sun.COM

over 22 years ago

In reply to: Kathy Zhu (#1)

Re: pg_atoi

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

Show quoted text

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

Import Notes

Resolved by subject fallback

Stephan Szabo

sszabo@megazone23.bigpanda.com

over 22 years ago

In reply to: Kathy Zhu (#1)

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.

Show quoted text

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