Jerry Sievers <gsievers19@xxxxxxxxxxx> writes: > "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 :-) Oops! Make that MVCC ! > 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 -- 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
