Re: Create index hanging

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 <mclister@zeesource.net> 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?