Hi. I will give it a try. Although, I do remember that the lock occurs on the first transaction - so basically there should be nothing to commit yet? Thanks, Stas. -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Wednesday, September 21, 2005 9:35 PM To: Stas Oskin Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Postgres locks table schema? "Stas Oskin" <stas@xxxxxxxxx> writes: > When running SQL scripts, which change the tables' schema, we sometimes > experience a lock of these tables' schema. The lock occurs on the first > command of the script, on the first modified table. When this occurs, no > further schema modification for this table is possible, until the server is > restarted, which is very problematic for a production environment. Try committing the transaction that performed the schema modification ;-) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
