|
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:
pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Jason Long 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 |
