Hello, all,
I'm new to the list, though I trust (fear?) that I'm not new to everyone (Hi, Dan!). I am experimenting with one of the Evergreen VMWare images (v1.2.1.4). It seems to run well so far, but I'm stuck at the step of actually loading data into Evergreen. I am running the SQL script which uses the COPY command, copying a flat file from disk into the corresponding PostgreSQK table Evergreen uses. I am getting a duplicate primary key error: [EMAIL PROTECTED]:~/clic$ sudo psql -U evergreen -f pg_loader-output.sql evergreen [sudo] password for evergreen-admin: Password for user evergreen: SET BEGIN psql:pg_loader-output.sql:3: ERROR: duplicate key violates unique constraint "record_entry_pkey" CONTEXT: COPY record_entry, line 23740: "t now 1 f now 1 hugogrotiuslee 23743 IMPORT-1221663443.06135 <record xmlns:xsi="http://www.w3.org..."; psql:pg_loader-output.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:pg_loader-output.sql:5: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:pg_loader-output.sql:6: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:pg_loader-output.sql:7: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:pg_loader-output.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:pg_loader-output.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:pg_loader-output.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK [EMAIL PROTECTED]:~/clic$ Now I am not a grep god. I am pretty handy with flat files where each line is a record, and each record is terminated by a CR-LF pair. But these JSONed records are a different kind of beast. So, if I wanted to rip this thing out of the input file (a potentially useful skill), I'd have to move back to the beginning-of-record-mark, and forward to the end-of-record-mark, in the midst of a 2.8 GB input file. If it were just a small text file, I'd back it up, and use a text editor to modify the backup file, and just delete the offending record. If course doing this will probably screw up some other relation, but at the moment I'm just trying to push data in this thing. Thanks in advance for your time and help, Mark Mark Andrews, MLS, Systems Librarian Academic & e-Learning Technologies, Division of Information Technology Creighton University, Omaha, NE 68178 402-280-3065 - [EMAIL PROTECTED]
