By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Questions of information_schema

P: 51
When I read 9.0.6 upgrade (from 9.0.x) notes, upgrade bin folder is not enough. Need to drop information_schema 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_schema. It causes a lot of errors about depending objects.

So how can I re-create it?
Mar 8 '12 #1

✓ answered by 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_schema.XXX (they should be) then you should be fine.

Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
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_schema.XXX (they should be) then you should be fine.
Mar 8 '12 #2

Expert 100+
P: 700
You can see information_schema in PgAdmin under the "Catalog" node.
If you cannot find it, make sure that "Catalog option" under File->Options->(Display page) is set.
Mar 8 '12 #3

P: 51
I did "drop ... cascade" and re-build by information_schema.sql. Both done successfully. I don't know what catalog is. Anyway, originally under CATALOGS ANSI(information_schema), there are lots of objects. After I did that, it becomes 0 objects. I restart posgresql. It works fine. Did I miss anything?
Mar 9 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.