On 09/01/2008, Thomas H. <[EMAIL PROTECTED]> wrote:
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.
I cannot recreate this on 8.3rc1 using a dummy table and the
trigger/procedure you posted. Can you provide me with a more complete
example in a pg_dump format please?
ok i'll try to make a small contained testcase later today
BTW, when you say 'viewing a particular table', do you mean viewing
it's details in the main window, in the properties dialogue, or using
the 'view data' option?
when clicking on the table's node in the treeview. after hitting the ok
button from the error message, you can still view (some? all?) the
tables properties and stuff. but i'm not sure
regards,
thomas
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
