Skip site navigation (1) Skip section navigation (2)

Re: OIDS

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Q Beukes <pgsql-novice(at)postgresql(dot)org>
Subject: Re: OIDS
Date: 2006-05-19 15:45:18
Message-ID: 20060519154518.GA19641@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, May 17, 2006 at 14:21:47 +0200,
  Q Beukes <pgsql-novice(at)postgresql(dot)org> wrote:
> Hey,
> 
> I have a few questions/thoughts about OIDS.
> 
> 1. What are the pros/cons of having them against not having them in your
> table.

Generally you don't want to use them. Use sequences/serial instead.

> 2. Are they unique throughout tables/database/postgres setup.

No. If you want to enforce uniqueness, you need to add a constraint and be
prepared to retry on failures.

In response to

  • OIDS at 2006-05-17 12:21:47 from Q Beukes

pgsql-novice by date

Next:From: kmh496Date: 2006-05-20 00:28:46
Subject: send psql output to file and setting pager=more
Previous:From: Verena RuffDate: 2006-05-19 06:52:02
Subject: Re: select count(*) and limit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group