[OPEN-ILS-DEV] Getting closer... psql load errors

[Don Hamilton]

Hi again...
 
Here's the output from the psql. I *think* the main problem is that the
creator column is supposed to be integer, but the data in the insert is
character 'admin'. That may or may not kick off the rest of the errors.
 
Have I missed some earlier configuration (to, say, add 'admin' to the
users table so that pg-loader could figure out the actual id number and
use it)? or have a mismatched version of db-schema and loader code? or
???
 
 
don
 
 
 
evergreen=# \i gutenberg.sql;
SET
psql:gutenberg.sql:14489: ERROR:  invalid input syntax for integer:
"admin"
CONTEXT:  COPY record_entry, line 1, column creator: "admin"
psql:gutenberg.sql:14491: ERROR:  setval: value -1 is out of bounds for
sequence "record_entry_id_seq" (1..9223372036854775807)
psql:gutenberg.sql:28979: ERROR:  insert or update on table
"rec_descriptor" violates foreign key constraint
"metabib_rec_descriptor_record_fkey"
DETAIL:  Key (record)=(1) is not present in table "record_entry".
psql:gutenberg.sql:388994: ERROR:  could not find tsearch config by
locale
CONTEXT:  COPY full_rec, line 1: "\N    \N      1       \N      LDR    
00531cam a22001813a 4500"
psql:gutenberg.sql:403482: ERROR:  could not find tsearch config by
locale
CONTEXT:  COPY title_field_entry, line 1: "5    1       five years of
theosophy  [electronic resource"
psql:gutenberg.sql:416900: ERROR:  could not find tsearch config by
locale
CONTEXT:  COPY author_field_entry, line 1: "7   2       wolley,
hannah"
psql:gutenberg.sql:420892: ERROR:  could not find tsearch config by
locale
CONTEXT:  COPY subject_field_entry, line 1: "13 8       antarctica --
discovery and exploration"
psql:gutenberg.sql:435380: ERROR:  could not find tsearch config by
locale
CONTEXT:  COPY keyword_field_entry, line 1: "14 1       five years of
theosophy  [electronic resource] / text eng by various project gutenberg
freely a..."
psql:gutenberg.sql:449866: ERROR:  could not find tsearch config by
locale
CONTEXT:  COPY series_field_entry, line 1: "1   1       project
gutenberg 14378"
evergreen=# SELECT COUNT(*) FROM biblio.record_entry
;
 count 
-------
     1
(1 row)
 
evergreen=# \?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20070530/583ab53a/attachment-0001.html