"Steven Flatt" <[EMAIL PROTECTED]> writes: > Hi, we're using Postgres 8.1.4. > We've been seeing deadlock errors of this form, sometimes as often as > several times per hour: > ... > I also see claims that this problem is fixed in 8.2, and if the fix is what > I think it is, it's also in 8.1.6. > Can someone confirm that I've identified the right fix?
Hard to say without a lot more data, but as a general rule you should be on 8.1.latest in any case. See http://www.postgresql.org/support/versioning You might also find ammunition in the release notes: http://developer.postgresql.org/pgdocs/postgres/release.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
