Exported 25,000 SIRSI records.
Seems to have gone through marc2bre, direct_ingest.pl and pg_loader OK.
Files created that look normal.
But # \i newrecords.sql results in:
...psql:books.sql:768112: invalid command \N
psql:books.sql:768113: invalid command \N
psql:books.sql:768136: invalid
On 24/01/2008, Grant Johnson [EMAIL PROTECTED] wrote:
Exported 25,000 SIRSI records.
Seems to have gone through marc2bre, direct_ingest.pl and pg_loader OK.
Files created that look normal.
But # \i newrecords.sql results in:
...psql:books.sql:768112: invalid command \N
Captured the top of the error block...seems that you are correct
psql:Jan24books.sql:5: ERROR: duplicate key violates unique constraint
record_entry_pkey
CONTEXT: COPY record_entry, line 1: t now 1 f now 1
annualreportsinmedicinalchemistryacademic 10002