Message-ID: <4256C5D3.3050102@gvtc.com>
Date: Fri, 08 Apr 2005 17:56:35 +0000
From: Jim Johannsen <jjsa@gvtc.com>
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317)
MIME-Version: 1.0
Cc: pgsql-sql@postgresql.org
Subject: Re: Numeric and CSV under 8.0.1 ?
References: <20050408165147.GV30669@survivor.hades>
In-Reply-To: <20050408165147.GV30669@survivor.hades>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Stef:
    Why is iuserid numeric?  Are you going to do any math on the field?  
If not, change it to varchar.  In the long run you'll be happier.


Stef wrote:

>Hello Everyone,
>	Currently, here at work, I am doing the whole
>'advocacy' part of postgreSQL. It's not really hard to
>do, as the other database's are MySQL and Sybase ;)
>
>	There is obviously a whole spat of data munging
>going on in the background, and I noticed that psql in
>8.0.1 now accepts CSV ! Great. 
>
>	Except, it doesn't really appear to be 100% there.
>Numeric's wrapped in '...' don't want to appear to go in.
>Is this a 'known problem' ?
>
>                    Table "public.visitor_main"
>      Column      |         Type         |          Modifiers           
>------------------+----------------------+------------------------------
> iuserid          | numeric(12,0)        | not null
> firstname        | character(25)        | not null
> lastname         | character(25)        | not null
>
>
>Sample Data line
>'3236','Alonzo','Peter'
>
>ERROR:  invalid input syntax for type numeric: "'3236'"
>CONTEXT:  COPY visitor_main, line 1, column iuserid: "'3236'"
>
>
>	Thoughts ?
>	Regards
>	Steph
>  
>