Re: [GENERAL] Help with row locks on 7.4 to 8.0 migration

2005-09-06 Thread Tom Lane
Kevin Barnard <[EMAIL PROTECTED]> writes: > FATAL: terminating connection due to administrator command > CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."client" x WHERE > "division" = $1 FOR UPDATE OF x" > That's what happens when I kill the SQL that was locking everything. The > only prob

[GENERAL] Help with row locks on 7.4 to 8.0 migration

2005-09-06 Thread Kevin Barnard
I've just upgraded a 7.4 install to 8.0.3 and we've suddenly run into lock issues that were not present in 7.4.  I'm look for help on this matter, because I'm a little confused.  Downgrading is really not an option at this point,  we really really need the 8.0 features on the DB and a dump/restore