On Wed, 2007-03-21 at 13:29 -0400, Bruce Momjian wrote: > Pavan Deolasee wrote: > > On 3/21/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > I am worried that will require CREATE INDEX to wait for a long time. > > > > > > > > Not unless there are long running transactions. We are not waiting > > for the lock, but only for the current transactions to finish. > > Waiting for all transactions might take a while, no?
It would be nice if we could force CREATE INDEX to only run outside a transaction block, but that just isn't possible if you care about existing applications. Any PL function running a CREATE INDEX would fail and I'm pretty sure there's lots of them. Many of them use dynamic SQL, so you wouldn't even be able to scan them prior to run-time to know that they would fail. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
