Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Pgadmin Support > bug: the schema...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 1926 of 2081
Post > Topic >>

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

by me@[EMAIL PROTECTED] ("Thomas H.") Jan 9, 2008 at 04:43 AM

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!"

refre****ng 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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
 




 7 Posts in Topic:
bug: the schema oid can't be located, please refresh all schemas
me@[EMAIL PROTECTED] (&q  2008-01-09 04:43:28 
Re: bug: the schema oid can't be located, please refresh all sch
dpage@[EMAIL PROTECTED]   2008-01-09 10:32:40 
Re: bug: the schema oid can't be located, please
me@[EMAIL PROTECTED] (&q  2008-01-09 15:17:06 
Re: bug: the schema oid can't be located, please
me@[EMAIL PROTECTED] (&q  2008-01-31 13:43:58 
Re: bug: the schema oid can't be located, please refresh all sch
dpage@[EMAIL PROTECTED]   2008-01-10 10:21:54 
Re: bug: the schema oid can't be located, please refresh all sch
dpage@[EMAIL PROTECTED]   2008-01-31 12:53:27 
Re: bug: the schema oid can't be located, please
me@[EMAIL PROTECTED] (&q  2008-01-31 22:01:34 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 4:39:54 CDT 2008.