2009/7/16 Raji Sridar (raji) <raji@xxxxxxxxx>: > 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-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
