Craig James wrote: > given what you have told us about your application, it is probably > not very important if a few ORDER ID numbers are missing. I'm not so sure. If these are considered accounting records which may be audited by a CPA firm, I would definitely check with the accountants before assuming that's OK. I spent four years working for a CPA firm, participating in audits where computer expertise was needed; these guys considered it a major problem if there were gaps in the sequence numbers of financial transactions without a signed letter bound into the official books to explain each gap. That's probably related to the fact that in most of the cases of embezzlement I heard about, numbering gaps in the sales records were the tip-off that something was wrong. (If there's no record of the sale, who's going to miss the money from it?) Perhaps you have other controls which make that one irrelevant, but I would check.... -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin