> On 09/01/2008, Thomas H. <me@[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!"
>>
>> refre****ng 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
|
