Questions of information_schema

[datactrl]

When I read 9.0.6 upgrade (from 9.0.x) notes, upgrade bin folder is not enough. Need to drop information_sch ema and recreate it by a sql file in share folder.

My questions are
1) Why I can't fine that schema on pgAdmin in each database.
2) I tried to query its tables and it works. That means it's there.
3) I try to drop it: drop schema information_sch ema. It causes a lot of errors about depending objects.

So how can I re-create it?

[r035198x]

1.) Could be because it's just a set of views and is not available on the search path by default.
2.) It's there by default in all databases
3.) Doesn't it give the hint HINT: Use DROP ... CASCADE to drop the dependent objects too. ? As long as all listed dependent objects are called information_sch ema.XXX (they should be) then you should be fine.

[rski]

You can see information_sch ema in PgAdmin under the "Catalog" node.
If you cannot find it, make sure that "Catalog option" under File->Options->(Display page) is set.

[datactrl]

I did "drop ... cascade" and re-build by information_sch ema.sql. Both done successfully. I don't know what catalog is. Anyway, originally under CATALOGS ANSI(informatio n_schema), there are lots of objects. After I did that, it becomes 0 objects. I restart posgresql. It works fine. Did I miss anything?