Claire McLister <[EMAIL PROTECTED]> 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