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?