"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 :-)
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