Re: Dumpall without OID

On Friday 28 January 2011 4:54:18 am Girts Laudaks wrote:
> Well, seems that everything is OK. There are no OIDs used from the
> application side but they still appear in the database tables, this was
> what made the confusion.
>
> Thanks,
> G.
>

OIDS on user tables have not been on by default since 8.0. Possible reasons why
they exist:
If the tables have been around since 8.0- OIDS will carry on with them.
The table CREATE statements have the WITH OIDS clause.
In postgresql.conf the default_with_oids setting is set on.

In addition to the point I made yesterday, some old database drivers rely on
OIDS to determine uniqueness. If you are positive that they are not needed you
can use the ALTER TABLE table_name SET WITHOUT OIDS to remove the OID column
from a table
(http://www.postgresql.org/docs/9.0/interactive/sql-altertable.html)




--
Adrian Klaver
adrian.klaver@gmail.com