Re: Table lock while adding a column and clients are logged in - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Table lock while adding a column and clients are logged in
Date
Msg-id 87ei5kkhdk.fsf@comcast.net
Whole thread Raw
In response to Table lock while adding a column and clients are logged in  ("Sven Haag" <sven-haag@gmx.de>)
Responses Re: Table lock while adding a column and clients are logged in
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Henry C."
Date:
Subject: Autovacuum firing up during my manual vacuum on same table
Next
From: "Henry C."
Date:
Subject: Re: Autovacuum firing up during my manual vacuum on same table