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

[Don Hamilton]

Next step...
 
The newer marc2bre fixed the problem I have 14,486 records in
record_entry. Woo hoo!
 
BUT (of course)... I also have the following:
 
psql:/home/don/gutenberg.sql:388994: ERROR:  could not find tsearch
config by locale
CONTEXT:  COPY full_rec, line 1: "\N    \N      2       \N      LDR    
00531cam a22001813a 4500"
psql:/home/don/gutenberg.sql:403482: ERROR:  could not find tsearch
config by locale
CONTEXT:  COPY title_field_entry, line 1: "5    2       five years of
theosophy  [electronic resource"
psql:/home/don/gutenberg.sql:416900: ERROR:  could not find tsearch
config by locale
CONTEXT:  COPY author_field_entry, line 1: "7   3       wolley,
hannah"
psql:/home/don/gutenberg.sql:420892: ERROR:  could not find tsearch
config by locale
CONTEXT:  COPY subject_field_entry, line 1: "13 9       antarctica --
discovery and exploration"
psql:/home/don/gutenberg.sql:435380: ERROR:  could not find tsearch
config by locale
CONTEXT:  COPY keyword_field_entry, line 1: "14 2       five years of
theosophy  [electronic resource] / text eng by various project gutenberg
freely a..."
psql:/home/don/gutenberg.sql:449866: ERROR:  could not find tsearch
config by locale
CONTEXT:  COPY series_field_entry, line 1: "1   2       project
gutenberg 14378"

 
so what is "tsearch config by locale", and how do I find it?
 
don (where am I going, and what am I doing in this handcart?) hamilton

>>> mrylander at gmail.com 5/30/2007 11:07 AM >>>

On 5/30/07, Don Hamilton <dhamilton at wlu.ca> wrote:
>
>
> 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 ???
>

Arg ... yeah, that's a bug in the marc2bre that lives in the 1.0
branch.  I'd like you to grab the verion that lives in the HEAD of
cvs, if you can.  It's available here directly:

http://open-ils.org/cgi-bin/viewcvs.cgi/ILS/Open-ILS/src/extras/import/marc2bre.pl?rev=1.9&view=log


Thanks in advance, Don.

--miker

>
> 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=# \?
>


-- 
Mike Rylander

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