bug: the schema oid can't be located, please refresh all schemas

From: "Thomas H(dot)" <me(at)alternize(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: bug: the schema oid can't be located, please refresh all schemas
Date: 2008-01-09 03:43:28
Message-ID: 478442E0.3010507@alternize.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

pgadmin version: 1.8.1
pgsql version: 8.3.rc1
os: windows 2003

when viewing a particular table with a (fts) trigger, pgAdmin gives the
following error popup:

"missing information:
the schema oid can't be located, please refresh all schemas!"

refreshing the schemas as suggested by the error message doesn't help.

the offending trigger seems to be:

CREATE TRIGGER posts_fts_update
BEFORE INSERT OR UPDATE
ON forum.posts
FOR EACH ROW
EXECUTE PROCEDURE forum.tsvector_update_trigger('p_fts',
'pg_catalog.german', 'p_msg_clean');

with the corresponding procedure:

CREATE OR REPLACE FUNCTION forum.tsvector_update_trigger()
RETURNS trigger AS
'tsvector_update_trigger_byid'
LANGUAGE 'internal' VOLATILE
COST 1;
ALTER FUNCTION forum.tsvector_update_trigger() OWNER TO postgres;
COMMENT ON FUNCTION forum.tsvector_update_trigger() IS 'trigger for
automatic update of tsvector column';

not sure if its 8.3 or pgAdmin/FTS related. the pgsql log shows no
additional error/warning...

regards,
thomas

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Hiroshi Saito 2008-01-09 04:45:20 Re: [pgadmin-support] pgAdmin III Query Tool bug
Previous Message Laurent ROCHE 2008-01-08 13:44:20 Re : [pgadmin-support] Información pgAdmin