Executing the following from “information_schema.sql” from the 8.0 distribution against the restored database in 8.1 solved the problem.  Is this a bug?

 

*****************************************************************

SET search_path TO information_schema, public;

 

/*

 * A few supporting functions first ...

 */

 

/* This returns the integers from 1 to INDEX_MAX_KEYS/FUNC_MAX_ARGS */

CREATE FUNCTION _pg_keypositions() RETURNS SETOF integer

    LANGUAGE sql

    IMMUTABLE

    AS 'select g.s

        from generate_series(1,current_setting(''max_index_keys'')::int,1)

        as g(s)';

 

Thank you for your time,

 

Jason Long

CEO and Chief Software Engineer

BS Physics, MS Chemical Engineering

http://www.supernovasoftware.com


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Long
Sent: Thursday, December 01, 2005 11:43 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] information_schema._pg_keypositions() in 8.1???

 

I cannot get automatic schema update to work in 8.1 with hibernate 3.0.5.  I get the following error every time.

 

java.sql.SQLException: ERROR: function information_schema._pg_keypositions() does not exist

 

Is this something I should be looking to fix with Hibernate or PostgreSQL?

 

Any assistance would be greatly appreciated.

 

 

Thank you for your time,

 

Jason Long

CEO and Chief Software Engineer

BS Physics, MS Chemical Engineering

http://www.supernovasoftware.com

 

Reply via email to