Jerry Sievers <[email protected]> writes: > "Sven Haag" <[email protected]> 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: [email protected] > p: 305.321.1144 -- Jerry Sievers e: [email protected] p: 305.321.1144 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
