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

Jerry Sievers <gsievers19(at)comcast(dot)net> writes:

> "Sven Haag" <sven-haag(at)gmx(dot)de> 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(at)comcast(dot)net
> p: 305.321.1144

--
Jerry Sievers
e: gsievers19(at)comcast(dot)net
p: 305.321.1144