Re: Problem with COPY in 8.0.3 - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: Problem with COPY in 8.0.3
Date
Msg-id 20051012204027.GA50897@winnie.fuhr.org
Whole thread Raw
In response to Re: Problem with COPY in 8.0.3  (Oliver Elphick <olly@lfix.co.uk>)
List 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

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Problem with COPY in 8.0.3
Next
From: Tom Lane
Date:
Subject: Re: Problem with COPY in 8.0.3