On Thu, Jul 21, 2005 at 03:57:56PM +0200, Erik Wasser wrote: > Now I've got here a blocking problem. Severel SQL statements (like > renaming a field or UPDATE of a field) are blocked until I kill a > certain task. This task DOES only the INSERTS and UPDATES with a > transaction and the SELECT statements are not within an transaction.
If you set AutoCommit to 0 then all statements are inside a transaction. As you've discovered, SELECT acquires certain locks that persist for the duration of the transaction, so you must commit or roll back the transaction to release those locks (read up on transaction theory to learn more about the rationale for this). -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
