Re: [GENERAL] information_schema._pg_keypositions() in 8.1???

Jason Long Thu, 01 Dec 2005 11:12:51 -0800

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.