Re: [GENERAL] Drop Index and Create Index

2008-07-22 Thread Scott Marlowe
On Tue, Jul 22, 2008 at 1:39 AM, Giovanni Nervi <[EMAIL PROTECTED]> wrote: > Hi, > > I would like recreate all indexes on a database, the command reindex > is exclusive lock on table so I prefer the method drop index and > create index. Is there a script for extract the command for the create > ind

[GENERAL] Drop Index and Create Index

2008-07-22 Thread Giovanni Nervi
Hi, I would like recreate all indexes on a database, the command reindex is exclusive lock on table so I prefer the method drop index and create index. Is there a script for extract the command for the create index? I see pg_dump but it extract all object definitions. I see the source of pgAdmin f