pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Horst Herb <hherb@malleenet.net.au>
To: pgsql-sql@postgresql.org
Subject: Re: GUID in postgres
Date: Thu, 25 Oct 2001 08:34:09 -0700
Message-ID: <web-492038@davinci.ethosmedia.com> (raw)
In-Reply-To: <20011025034926.30847.qmail@gnumed.dhs.org>

Horst,

> What we are using is the following:
> - All tables in need of a global ID _within_ a database inherit a
> globid 
> table which contains nothing but an ID of type serial.
> - When we need cross-database unique IDs within the same system, the
> globid 
> table contains a database identifier as well (like the OID of the
> pg_database 
> entry for the database).

Well, I think you've just answered your own question.  Build the above.

In more specific: 
1. PostgreSQL does not, as a design decision, support inter-database
queries.  So an inter-database ID is not particularly useful.  
2. If you needed an id to be unique between servers for some reason,
simply make it a two-column ID: one column for the sequence (see below)
and one for the server name/ID
3. Sequences are guarenteed unique within a database up to the limits of
INT4 (2.4 billion).  Read up on them in the postgreSQL docs.  Also see
my posts on pgsql-sql for the last week regarding primary keys.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco







view thread (12+ messages)  latest in thread

Message-ID: <web-492038@davinci.ethosmedia.com>
Permalink:  ../web-492038@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-492038@davinci.ethosmedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: josh@agliodbs.com, hherb@malleenet.net.au
  Subject: Re: GUID in postgres
  In-Reply-To: <web-492038@davinci.ethosmedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox