Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 848CC14E23D7 for ; Wed, 21 Dec 2011 20:31:35 -0400 (AST) Received: from mail-iy0-f174.google.com ([209.85.210.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RdWZG-0000av-MZ for pgsql-admin@postgresql.org; Thu, 22 Dec 2011 00:31:34 +0000 Received: by iaeh11 with SMTP id h11so12628878iae.19 for ; Wed, 21 Dec 2011 16:31:18 -0800 (PST) Received: by 10.42.29.137 with SMTP id r9mr9041600icc.20.1324513877737; Wed, 21 Dec 2011 16:31:17 -0800 (PST) Received: from Craig-Jamess-MacBook-Pro.local (wsip-70-167-122-86.sd.sd.cox.net. [70.167.122.86]) by mx.google.com with ESMTPS id cv10sm27532912igc.0.2011.12.21.16.31.15 (version=SSLv3 cipher=OTHER); Wed, 21 Dec 2011 16:31:16 -0800 (PST) Message-ID: <4EF27AE1.3050803@emolecules.com> Date: Wed, 21 Dec 2011 16:33:37 -0800 From: Craig James User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Can't Insert from Staging Table to Production Table References: <0FB9449006048B4AA23E50C90C1B9209059A1221@CH1PRD0202MB157.namprd02.prod.outlook.com> In-Reply-To: <0FB9449006048B4AA23E50C90C1B9209059A1221@CH1PRD0202MB157.namprd02.prod.outlook.com> Content-Type: multipart/alternative; boundary="------------050502010205080109050006" X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201112/120 X-Sequence-Number: 38878 This is a multi-part message in MIME format. --------------050502010205080109050006 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 12/21/11 12:34 PM, Elliot Voris wrote: > > 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. > Google is your friend. Look for "ParserDetails.ini" and you find the exact problem you're describing: http://perl-xml.sourceforge.net/faq/#parserdetails.ini Craig > > Thank you! > > Elliot J Voris > > IT Director > > *Saint Louis Christian College* > > evoris@slcconline.edu > > 314.837.6777 x 1250 > --------------050502010205080109050006 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 12/21/11 12:34 PM, Elliot Voris wrote:

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.

Google is your friend. Look for "ParserDetails.ini" and you find the exact problem you're describing:

http://perl-xml.sourceforge.net/faq/#parserdetails.ini

Craig

Thank you!

Elliot J Voris

IT Director

Saint Louis Christian College

evoris@slcconline.edu

314.837.6777 x 1250

--------------050502010205080109050006--