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

oid or without oid ...

From: Raimon Fernandez <coder(at)montx(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: oid or without oid ...
Date: 2007-05-22 07:30:34
Message-ID: DC4D44E8-0E37-44C6-B578-37A02D3DDADD@montx.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello again,


In my previous databases development, I've been using always a unique  
longint number for identifying each record.

In PostgreSQL I can see that it has the oid, he can do it for you.

Also I see that is an optional parameter, and after surfing the web,  
I could find some people that say never use them, an another ones  
that you can use it ...

Any extra advice would be perfectly before creating the database, if  
it's better for now and future to use oid or simply create an id  
field as a serial or something similar.

thanks,


raimon fernandez


Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2007-05-22 09:57:09
Subject: Re: oid or without oid ...
Previous:From: Derrick BettsDate: 2007-05-21 22:00:57
Subject: Re: Multiple row update with trigger

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