Jerry Sievers <gsievers19@comcast.net> writes:
> "Sven Haag" <sven-haag@gmx.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@comcast.net
> p: 305.321.1144
--
Jerry Sievers
e: gsievers19@comcast.net
p: 305.321.1144