Re: Create index hanging

Yes, that could be the case. We have a python function that imports
CSV files, which can take a long time, and that may have been running
during that time. I didn't look at the pg_lock file. What should I be
looking for?

On Jul 20, 2006, at 3:13 PM, Tom Lane wrote:

> Claire McLister <mclister@zeesource.net> writes:
>>   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.
>
> It sounds like someone had a write lock on the table.  Did you try
> looking in pg_locks?
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster