Bill,
Perfect, that did the trick! At long last I have 1000 of our own marc
records and their copies in a sample evergreen system.
Nella
Bill Ott wrote:
psql:insert_holdings.sql:1: ERROR: date/time field value out of
range: "12/13/1993"
HINT: Perhaps you need a different "datestyle" setting.
psql:insert_holdings.sql:2: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:insert_holdings.sql:3: ERROR: current transaction is aborted,
commands ignored until end of transaction block
......
So, can you help me figure out how to fix this problem it is having
with my create date of 12/13/1993.
The short answer is, it's expecting an ISO 8601 date. i.e. yyyy-mm-dd
If you feel adventuresome, the following *should* reformat all dates
in the file. Just in case, it will also create a backup of your
original. perl -i.orig -p -e
's/(\d+)(\/)(\d+)(\/)(\d{4})/$5-$1-$3/g' <filename>
