Postgres Pro
Downloads
Home   >   mailing lists

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

From Jorge Godoy
Subject Re: Best approach for a "gap-less" sequence
Date
Msg-id 871wrkvhs8.fsf@gmail.com
Whole thread Raw
In response to Best approach for a "gap-less" sequence  (Jorge Godoy <jgodoy@gmail.com>)
Responses Re: Best approach for a "gap-less" sequence  (Ron Johnson <ron.l.johnson@cox.net>)
Re: Best approach for a "gap-less" sequence  (Chris <dmagick@gmail.com>)
List pgsql-general
Tree view 
Jorge Godoy <jgodoy@gmail.com> writes:

> Is there a better way to guarantee that there will be no gaps in my sequence
> if something goes wrong with my transaction?

From the overwhelming feedback I assume there isn't a better way yet...
Thanks.  I'll see how I can improve the model then to separate these sequences
into different tables.

--
Jorge Godoy      <jgodoy@gmail.com>

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: cannot create table using pl/perl
Next
From: "Bill Bartlett"
Date:
Subject: Re: Migrating PostgreSQL database to MySQL/MS Access