2009/7/16 Raji Sridar (raji) <r...@cisco.com>: > Hi, > > We use a typical counter within a transaction to generate order sequence > number and update the next sequence number. This is a simple next counter - > nothing fancy about it. When multiple clients are concurrently accessing > this table and updating it, under extermely heavy loads in the system > (stress testing), we find that the same order number is being generated for > multiple clients. Could this be a bug? Is there a workaround? Please let me > know. > > Thanks > Raji
You'll not have this problem if you use serial type. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
