Re: Best approach for a "gap-less" sequence

From: AgentM <agentm(at)themactionfaction(dot)com>
To: PostgreSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Best approach for a "gap-less" sequence
Date: 2006-08-14 15:14:36
Message-ID: 0773E0E5-AA1A-4B95-997D-DB68AC270D8B@themactionfaction.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Since the gapless numbers are purely for the benefit of the tax
people, you could build your db with regular sequences as primary
keys and then regularly (or just before tax-time) insert into a table
which maps the gapless sequence to the real primary key.

-M

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-08-14 15:27:00 Re: BUG #2574: C function: arg TEXT data corrupt
Previous Message Alvaro Herrera 2006-08-14 14:45:45 Re: Best approach for a "gap-less" sequence