Re: Table lock while adding a column and clients are logged in

Jerry Sievers  writes:

> "Sven Haag"  writes:
>
>> 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?
>
> Discharge that clueless consultant and study up on NVCC :-)

Oops!   Make that MVCC !

> Then, find out why there are long running transactions in your
> application.
>
>> cheers sven
>> -- 
>> Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
>> belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
>
> -- 
> Jerry Sievers
> e: gsievers19@comcast.net
> p: 305.321.1144

-- 
Jerry Sievers
e: gsievers19@comcast.net
p: 305.321.1144