Many thanks again. I figured out how to get only the tables that have indexes created less these PK indexes so I can used the pg_get_indexdef to rebuild them all through a scheduled Pgagent job in a loop using CONCURRENTLY as our production assumes DB access 24/7.
Lawrence Cohan. -----Original Message----- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2008 12:57 PM To: Lawrence Cohan Cc: Tom Lane; pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4238: pg_class.relhasindex not updated by vacuum Lawrence Cohan wrote: > Isn't a PK a CONSTRAINT and not an INDEX??? Sure, from a logical point of view. The implementation of that constraint is an index. > In that case the two separate pg_class relhasindex and relhaspkey would > make sense indeed - just a thought nothing else and we'll take it as is. What would be the point? If you want to figure out whether a table has a primary key, you can query the catalogs. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
