Request a Demo
Home   >   mailing lists

Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS
Date
Msg-id 49905506.10407@dunslane.net
Whole thread Raw
In response to Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS
Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS
List pgsql-hackers
Tree view 

Heikki Linnakangas wrote:
> Andrew Dunstan wrote:
>> How about a pg_dump flag that simply suppresses OIDs from the data 
>> and schema?
>
> pg_dump -s postgres  | sed -e 's/SET default_with_oids = true;/-- &/'
>

No good for non-text dumps.

cheers

andrew

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 64 bit PostgreSQL 8.3.6 build on AIX 5300-09-02-0849 with IBM XL C/C++ 10.1.0.1 - initdb fails (could not dump unrecognized node type: 650)
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: 64 bit PostgreSQL 8.3.6 build on AIX 5300-09-02-0849 with IBM XL C/C++ 10.1.0.1 - initdb fails (could not dump unrecognized node type: 650)