I've read over the docs on Concurrency Control but still not clear about when transactions block other updates, and how to deal with that on the application level. If I do a BEGIN and an UPDATE in one psql session and then try and do an UPDATE in another psql session that UPDATE waits until either a COMMIT or ROLLBACK. Is it common for applications using Postgresql to set a timer on updates and abort? -- Bill Moseley moseley@xxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
