Re: "Bad date external representation"

From: Lynna Landstreet <lynna(at)gallery44(dot)org>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: "Bad date external representation"
Date: 2003-06-19 19:16:16
Message-ID: BB178440.406%lynna@gallery44.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Some additional information with regard to this issue, in case it helps any.

/* --------------------------------------------------------
Table structure for table "exhibitions"
-------------------------------------------------------- */
CREATE TABLE "exhibitions" (
"exhibition_id" int4 DEFAULT
nextval('"exhibitions_exhibition_id_seq"'::text) NOT NULL,
"exhibition_name" varchar(128) NOT NULL,
"start_date" date NOT NULL,
"end_date" date NOT NULL,
"curator" varchar(128),
"description" varchar(1024) NOT NULL,
"created_date" date NOT NULL,
"created_by" varchar(32) NOT NULL,
"modified_date" date NOT NULL,
"modified_by" varchar(32) NOT NULL,
CONSTRAINT "exhibitions_pk" PRIMARY KEY ("exhibition_id")
);

And the first line from the data file I was trying to import:

100|Wild Writing|9/19/2002|10/26/2002|Leslie Thompson|Kroeger enters the
landscape armed with a notebook and pencil for these nature-based images.
Using graph paper, the artist makes graphite rubbings from tree bark, which
has seen the passage of various beetle type insects. The paths, which are
left in their wake, appear like so many strange prehistoric symbols, once
Kroeger has done his magic in the darkroom. Printed as colour photograms of
relatively large scale, these works simultaneously reference moonscapes,
cave paintings, and microcosms.|2/4/2003|Lynna Landstreet|2/14/2003|Lynna
Landstreet

Don't know if that helps any...

Lynna
--
Resource Centre Database Coordinator
Gallery 44
www.gallery44.org

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Chris Pizzo 2003-06-19 19:56:25 [local] idle in transaction
Previous Message Lynna Landstreet 2003-06-19 19:03:41 Re: "Bad date external representation"