On Wed, 2005-09-21 at 12:51, Stas Oskin wrote: > Hi. > > > > 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. > > > > Perhaps someone is familiar with this behavior, and how it can be > resolved, without the restart of the server? > > > > The server used is PostgreSQL 8.0.3, and the OS is Fedora Core 3.
Have you got a test case that reproduces this in some way? I'm guessing Tom's got it right on committing the transaction, but without knowing EXACTLY what you're doing, we're just guessing here. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
