On Wed, May 17, 2006 at 14:21:47 +0200,
Q Beukes <pgsql-novice(at)postgresql(dot)org> wrote:
> I have a few questions/thoughts about OIDS.
> 1. What are the pros/cons of having them against not having them in your
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: kmh496||Date: 2006-05-20 00:28:46|
|Subject: send psql output to file and setting pager=more|
|Previous:||From: Verena Ruff||Date: 2006-05-19 06:52:02|
|Subject: Re: select count(*) and limit|