Problem dropping a table
От | Daniel Armbrust |
---|---|
Тема | Problem dropping a table |
Дата | |
Msg-id | 4460FDE9.9040600@comcast.net обсуждение исходный текст |
Ответы |
Re: Problem dropping a table
|
Список | pgsql-jdbc |
I have a java application that is trying to dynamically drop a set of tables. Problem is, when it gets to a particular table and I execute the "drop table foo cascade" command from a prepared statement, the query never returns. It just hangs indefinitely. I presume that it is waiting on a lock for this table, but there is nothing that I know of that should be locking this table. So, I have two issues - the first, how do I prevent myself from hanging indefinitely? I tried 'setQueryTimeout' on the prepared statement, but it doesn't seem to have any effect. Still hangs indefinitely. Is setQueryTimeout implemented in the driver? I first posted on the regular mailing list, and Tom answered that the server should be supporting it. The second, how can I track down what is locking this table? I presume that it is some of my code somewhere... maybe a prepared statement that I didn't get closed - but I can't find it. I've checked my code twice for any reference to this table, and every use of it is properly closing the result sets and the prepared statement. It seems like maybe the driver isn't releasing a lock when it is supposed to? Any ideas? Thanks, Dan -- ***************************** Daniel C. Armbrust Biomedical Informatics Information Services Mayo Clinic Rochester Harwick 8-36 (507) 538-1549 daniel.armbrust@mayo.edu *****************************
В списке pgsql-jdbc по дате отправления: