Hi all:
I'd like to share this information.
We received the following error, when a user tryied to map an item:
-- URL Was: <http://repositorio.bcn.cl/jspui/tools/itemmap>
http://repositorio.bcn.cl/jspui/tools/itemmap
-- Method: POST
-- Parameters were:
-- item_ids: "2144"
-- action: "Add"
-- cid: "9"
Exception:
org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR:
relation with OID 34153 does not exist
After googling a bit, I found that "In PostgreSQL versions < 8.3, PL/PgSQL
caches function scripts", and the side effect is "that if a PL/PgSQL
function accesses a temporary table, and that table is later dropped and
recreated, and the function called again, the function will fail because the
cached function contents still point to the old temporary table. The
solution is to use EXECUTE for temporary table access in PL/PgSQL.": but we
don't have control the way Dspace is executing the function scripts.
The good thing is "This problem does not occur in PostgreSQL 8.3 and later."
The bad thing is we are using postgresql 8.1... and I'm considering upgrade
it.
Source: <http://www.postgresql.org/docs/faqs.FAQ.html#item4.19>
http://www.postgresql.org/docs/faqs.FAQ.html#item4.19
Regards,
Álvaro Sandoval
BCN, Biblioteca del Congreso Nacional
Servicios Digitales. Ingeniería y Desarrollo
Fono: (56-32) 226 3981. Fax: (56-32) 226 3973
www.bcn.cl <http://www.bcn.cl>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
