Port Bug Report: Can't import nullable date field with COPY in psql

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: Can't import nullable date field with COPY in psql
Date: 1999-02-01 00:53:07
Message-ID: 199902010053.TAA15863@hub.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-ports


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Jay MacDonald
Your email address : jaym(at)aztech-cs(dot)com

Category : runtime: back-end
Severity : non-critical

Summary: Can't import nullable date field with COPY in psql

System Configuration
--------------------
Operating System : Linux 2.0.35 ELF

PostgreSQL version : 6.4

Compiler used : gcc 2.7.2.1

Hardware:
---------
AMD K6 266, 128 MB RAM
S.u.S.E 5.2
Linux minotaur 2.0.35 #1 Tue Aug 11 14:25:16 PDT 1998 i586 unknown

Versions of other tools:
------------------------
GNU Make version 3.76.1

--------------------------------------------------------------------------

Problem Description:
--------------------
I have defined a date type field that can be null. When I
try to use COPY to import a text file it pukes if there
is no value in that field.

--------------------------------------------------------------------------

Test Case:
----------
1. Create a table test:
CREATE TABLE test (
stock char(6) NOT NULL,
date_in date NOT NULL,
date_out date,
sort_date date NOT NULL,
PRIMARY KEY (stock)
);

2. Create file test.dat with the following lines:

M10004|19981219||19981219
M10008|19981219||19981219
M10011|19981219||19981219

3. Attempt to use COPY to import the data:
ram=> COPY test FROM '/disk2/data/ram/test.dat' USING DELIMITERS '|';
ERROR: Bad date external representation
ram=>

If I enter a date value into that null field in the data
file it imports okay. I tried filling it with the string
NULL, but no success.

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------

Responses

Browse pgsql-ports by date

  From Date Subject
Next Message Bruce Momjian 1999-02-01 01:09:28 Re: [PORTS] Port Bug Report: Can't import nullable date field with COPY in psql
Previous Message Unprivileged user 1999-01-31 19:11:44 Port Bug Report: initdb failure