From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Ausrack Webmaster <webmaster(at)ausrack(dot)com(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: DBD::Pg problem |
Date: | 2003-12-03 06:51:54 |
Message-ID: | 20031203065154.GA2597@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
pg_atoi is the string to int converter. You're trying to insert it into an
integer field.
On Wed, Dec 03, 2003 at 03:45:53PM +0900, Ausrack Webmaster wrote:
> Hi
>
> I am trying to insert a simple email address into a text field,
> and I get the below error:
>
> DBD::Pg::st execute failed: ERROR: pg_atoi: error in
> "<support(at)somedomain(dot)com>": can't parse "<support(at)somedomain(dot)com>"
>
> I figure it is because of the < and @ in the value, but why does it take
> these as operators even
> when the value has single quotes around it?
> I have even tried binding the values and PG_TEXT beforehand and still
> not luck.
>
> Any help would be greatly appreciated.
>
> Jason Frisch
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato
From | Date | Subject | |
---|---|---|---|
Next Message | David Garamond | 2003-12-03 07:02:37 | Money data type in PostgreSQL? |
Previous Message | Ausrack Webmaster | 2003-12-03 06:45:53 | DBD::Pg problem |