OIDS question - Mailing list pgsql-novice

From Frank Bax
Subject OIDS question
Date
Msg-id 48938F67.7060502@sympatico.ca
Whole thread Raw
Responses Re: OIDS question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I know we shouldn't use them; but ...

We have some apps that are using OIDS only as a unique key for updating
single records in table.

To transfer these tables to another system using pg_dump; I really only
need "WITH OIDS" on the CREATE TABLE command, not the COPY statements.

While playing with this I noticed that using the -c -o options of
pg_dump together; I get OIDS in COPY statements, but not in the CREATE
commands.  Either this is a bug; or I'm missing something here...

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: Upgrading database format on PostgreSQL 8.1 on FC6
Next
From: Tom Lane
Date:
Subject: Re: OIDS question