Re: Best approach for a "gap-less" sequence - Mailing list pgsql-general

From AgentM
Subject Re: Best approach for a "gap-less" sequence
Date
Msg-id 0773E0E5-AA1A-4B95-997D-DB68AC270D8B@themactionfaction.com
Whole thread Raw
In response to Re: Best approach for a "gap-less" sequence  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Best approach for a "gap-less" sequence  (Jorge Godoy <jgodoy@gmail.com>)
List 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



pgsql-general by date:

Previous
From: "macgillivary"
Date:
Subject: Re: Migrating PostgreSQL database to MySQL/MS Access
Next
From: Michael Fuhr
Date:
Subject: Re: prepared statement already exists