Table lock while adding a column and clients are logged in - Mailing list 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
cientsare logged out it returns to the normal state. according to our consultant of the application this behavior
doesn'tappear 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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Merged Model for libpq
Next
From: Guillaume Lelarge
Date:
Subject: Re: Table lock while adding a column and clients are logged in