| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Kathy Zhu <Kathy(dot)Zhu(at)Sun(dot)COM> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_atoi |
| Date: | 2003-10-17 03:36:00 |
| Message-ID: | 20031016203445.L70369@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)postgresql(dot)org
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sharon Cowling | 2003-10-17 04:08:00 | Disabling referential integrity |
| Previous Message | Kathy Zhu | 2003-10-17 03:29:27 | Re: pg_atoi |