Can't Insert from Staging Table to Production Table

From: Elliot Voris <evoris(at)slcconline(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Can't Insert from Staging Table to Production Table
Date: 2011-12-21 20:34:27
Message-ID: 0FB9449006048B4AA23E50C90C1B9209059A1221@CH1PRD0202MB157.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, everyone

I've got 32,404 rows of data in a staging table (marcxml_import) that I'm trying to get into my production table (biblio.record_entry) in my database (evergreen). When trying to do so, I'm getting the following error:

evergreen=# INSERT INTO biblio.record_entry (marc, last_xact_id) SELECT marc, 'IMPORT' FROM marcxml_import;
WARNING: could not find ParserDetails.ini in /usr/local/share/perl/5.10.1/XML/SAX
CONTEXT: compilation of PL/Perl function "maintain_control_numbers"
ERROR: Unable to provide required features
CONTEXT: PL/Perl function "maintain_control_numbers"
evergreen=#

Any ideas what this means? Any idea how to get around it? I was asked in IRC what language I was working with, and it's plperlu.

Thank you!

Elliot J Voris
IT Director
Saint Louis Christian College

evoris(at)slcconline(dot)edu<mailto:evoris(at)slcconline(dot)edu>
314.837.6777 x 1250

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Maurício Cruz 2011-12-21 21:08:15 win1252 to UTF8
Previous Message Bèrto ëd Sèra 2011-12-21 18:18:34 Re: stats and unix sockets