Skip site navigation (1) Skip section navigation (2)

Re: Problem with COPY in 8.0.3

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problem with COPY in 8.0.3
Date: 2005-10-12 20:40:27
Message-ID: 20051012204027.GA50897@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Oct 12, 2005 at 08:17:23PM +0100, Oliver Elphick wrote:
> On Wed, Oct 12, 2005 at 12:19:41PM -0600, Michael Fuhr wrote:
> > Could you post the table definitions?
> 
> Here it is: 

I created the tables you posted (sans foreign key constraints because
you didn't include the referenced tables) and loaded the data from
your previous post into an 8.0.4 server on FreeBSD 4.11-STABLE.
Here's what I got; it looks correct around the columns you report
having trouble with:

\x
SELECT * FROM export_invoice;
-[ RECORD 1 ]-+--------------------------------
invno         | 67829
customer      | 22058
account       | X378
invdate       | 2004-02-10
taxpoint      | 2004-02-10
discount      | 0.000
ordno         | 5411
custref       | 15498-00
currency      | GBP
carriage      | 0.00
printed       | t
assigned      | t
customer_ean  | 
location_ean  | 
exchange_rate | 
grpid         | 
postcode      | 
grn           | 
orderdate     | 2004-02-10
packages      | 60
packing       | 0.00
other         | 0.00
other_desc    | 0
insurance     | 0.00
pack_desc     | Carton
kilos         | 570.000
nett          | 0.000
dimensions    | 
terms         | CIF-MONTREAL/ACT 30-DAYS
bank          | 
goods         | Chemist's sundries
marks         | AMG MEDICAL;5411;MONTREAL;1-60;
port          | THAMESPORT
transport     | SEA/ALLIANCE
destination   | CA
origin        | GB
auth          | MAIREAD BOYCE, DIRECTOR
copies        | 1

-- 
Michael Fuhr

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-10-12 21:45:17
Subject: Re: Problem with COPY in 8.0.3
Previous:From: Michael FuhrDate: 2005-10-12 20:26:32
Subject: Re: Problem with COPY in 8.0.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group