"Stas Oskin" <stas(at)neo(dot)co(dot)il> 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