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

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

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