Tomas Vondra wrote on 16.01.2011 23:41:
Yes, locking may in some cases lead to deadlocks, that's true. For example creating several invoices (for different days) in a single transaction may lead to a deadlock. But that's a feature, not a bug.
Hmm, a single transaction cannot deadlock itself as far as I know. A deadlock can only happen between two different transactions (T1 locks R1, waits for R2, T2 locks R2 waits for R1) Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
