Re: default_with_oid

Freddy Villalba Arias wrote:
> Hello,
>
>
>
> I've noticed that whenever I create a table, the DBMS is adding an OID
> column without my consent. I've also read that this behaviour can be
> modified (disabled) by setting the default_with_oid (to false, I
> suppose).

That option is only available in 7.5. In earlier releases, you have to
create WITH OIDS or alter the table to now have oids.

> What is the OID column for? How (and where) can I find (and disable) the
> default_with_oid flag?

There is a flag only in 7.5, which will not be released for several
months.

The column gives a unique value to each row. Try SELECT oid FROM tab.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073