Sequences...

From: James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Sequences...
Date: 1998-07-27 20:34:57
Message-ID: 81Jul26.152515edt.35713@gateway.lee.k12.nc.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I had a asked this question earlier and did not get a response, so here
it is again.

When implementing an "autoincrementing" field in several tables, is
common practice to create sequence for each table, or is it OK to use
just one sequence? I know right off the bat that if there was a
requirement that there be no holes in the key for a particualr table
that one sequence over multiple tables (like in check register) would
not do, but if this requirment is not there, would having one sequnence
for all (provided your projected number of total records in all the
tables is less than 4 billion) tables be OK?

Thanks...james

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ferruccio Zamuner 1998-07-28 07:05:51 Nested classes
Previous Message Tod Hagan 1998-07-27 17:24:33 Can Postgres functions be used as stored procedures?