Michael Fuhr wrote:
On Thu, Aug 17, 2006 at 03:27:26PM -0400, Walter Vaughan wrote:
ERROR: missing data for column "processed_timestamp"
The table you posted has 42 columns; at least one line in the file
doesn't have that many fields.
Yes, we didn't have the right number of columns...
We
On Thu, Aug 17, 2006 at 03:27:26PM -0400, Walter Vaughan wrote:
> Admin_=# COPY DATA_IMPORT_CUSTOMER FROM '/tmp/sold.pg' delimiter '|' null
> '';
> ERROR: missing data for column "processed_timestamp"
> CONTEXT: COPY data_import_customer, line 1: "(xxx) xxx-||Mary|Smith|76
> Crest Street||J
On Thursday 17 August 2006 03:27 pm, Walter Vaughan
<[EMAIL PROTECTED]> thus communicated:
> The problem is I need to load a field that is allowed to be null with
> nothing and it work
The above statement is not the problem you are having. We dumped and loaded a
4 gig Progress database with
