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

Reply via email to