No, this is a brand new index, so no drops.
On Jul 20, 2006, at 2:03 PM, Ian Harding wrote:
On 7/20/06, Claire McLister <[EMAIL PROTECTED]> wrote:
Hi,
We have a couple of tables (40,000 and 600,000 rows each) that I am
trying to build an index on an integer column.
When I issue the "create index foo_index on foo(id);" command in
psql it just does not return. I've waited over half an hour for the
smaller table.
The same command worked with no problems on a test environment with
roughly the same data.
Any ideas what may be going on?
I thought maybe locks, but my brief experimentation shows that locks
don't seem to block index creation, but they do seem to block dropping
one. Hmmm. Are you trying to drop it first?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq