"Tena Sakai" <tsakai@xxxxxxxxxxxxxx> writes: > I have a weired situation. Out of 17 tables which > comprise a database, one of them refuses to talk to > me. When I issue: > select * from marker; > it hangs. Some other session holding an exclusive lock on the table, perhaps? Have you looked into pg_locks for matches to that table? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org