Search Postgresql Archives

Re: Postgres locks table schema?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux