Postgres Pro
Downloads
Home   >   mailing lists

Re: How to generate unique invoice numbers for each day - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: How to generate unique invoice numbers for each day
Date
Msg-id igvthr$g5b$1@dough.gmane.org
Whole thread Raw
In response to Re: How to generate unique invoice numbers for each day  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: How to generate unique invoice numbers for each day
Next
From: Steve Litt
Date:
Subject: Re: Crosstab query on huge amount of values