| << 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:
|
me@[EMAIL PROTECTED]
(&q |
2008-01-09 04:43:28 |
|
dpage@[EMAIL PROTECTED]
|
2008-01-09 10:32:40 |
|
me@[EMAIL PROTECTED]
(&q |
2008-01-09 15:17:06 |
|
me@[EMAIL PROTECTED]
(&q |
2008-01-31 13:43:58 |
|
dpage@[EMAIL PROTECTED]
|
2008-01-10 10:21:54 |
|
dpage@[EMAIL PROTECTED]
|
2008-01-31 12:53:27 |
|
me@[EMAIL PROTECTED]
(&q |
2008-01-31 22:01:34 |
|
Post A Reply:

|