"Sven Haag" <sven-haag@xxxxxx> 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@xxxxxxxxxxx p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
