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:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 9:35 PM To: Stas Oskin Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres locks table schema? "Stas Oskin" <[EMAIL PROTECTED]> 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