Table lock while adding a column and clients are logged in

Поиск
Список
Период
Сортировка
От Sven Haag
Тема Table lock while adding a column and clients are logged in
Дата
Msg-id 20110402090952.281770@gmx.net
обсуждение исходный текст
Ответы Re: Table lock while adding a column and clients are logged in  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Table lock while adding a column and clients are logged in  (Jerry Sievers <gsievers19@comcast.net>)
Re: Table lock while adding a column and clients are logged in  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Re: Table lock while adding a column and clients are logged in  (juan pedro meriño <juapdiaz@gmail.com>)
Список pgsql-general
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
cientsare logged out it returns to the normal state. according to our consultant of the application this behavior
doesn'tappear in oracle or sql-server. 

how can i avoid this?

cheers sven
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Merged Model for libpq
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Table lock while adding a column and clients are logged in