pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Can't Insert from Staging Table to Production Table 2+ messages / 2 participants [nested] [flat]
* Can't Insert from Staging Table to Production Table @ 2011-12-21 20:34 Elliot Voris <evoris@slcconline.edu> 2011-12-22 00:33 ` Re: Can't Insert from Staging Table to Production Table Craig James <craig_james@emolecules.com> 0 siblings, 1 reply; 2+ messages in thread From: Elliot Voris @ 2011-12-21 20:34 UTC (permalink / raw) To: 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@slcconline.edu<mailto:evoris@slcconline.edu> 314.837.6777 x 1250 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Can't Insert from Staging Table to Production Table 2011-12-21 20:34 Can't Insert from Staging Table to Production Table Elliot Voris <evoris@slcconline.edu> @ 2011-12-22 00:33 ` Craig James <craig_james@emolecules.com> 0 siblings, 0 replies; 2+ messages in thread From: Craig James @ 2011-12-22 00:33 UTC (permalink / raw) To: pgsql-admin 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 <mailto:evoris@slcconline.edu> > > 314.837.6777 x 1250 > ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-12-22 00:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-12-21 20:34 Can't Insert from Staging Table to Production Table Elliot Voris <evoris@slcconline.edu> 2011-12-22 00:33 ` Craig James <craig_james@emolecules.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox