Table lock while adding a column and clients are logged in

From: "Sven Haag" <sven-haag(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Table lock while adding a column and clients are logged in
Date: 2011-04-02 09:09:52
Message-ID: 20110402090952.281770@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello pg fans,

we have an application that communicates via ODBC directly to the postgres database.

if i'm trying to add an additional column to a table in pgadmin while clients are logged in, pgadmin hangs. only if all cients are logged out it returns to the normal state. according to our consultant of the application this behavior doesn't appear in oracle or sql-server.

how can i avoid this?

cheers sven
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2011-04-02 09:38:29 Re: Table lock while adding a column and clients are logged in
Previous Message John R Pierce 2011-04-02 05:47:38 Re: Merged Model for libpq