Re: The -o command line option of pg_dump for a database using foreign keys - Mailing list pgsql-general

From Bruce Momjian
Subject Re: The -o command line option of pg_dump for a database using foreign keys
Date
Msg-id 200108161332.f7GDWCt12062@candle.pha.pa.us
Whole thread Raw
In response to The -o command line option of pg_dump for a database using foreign keys  (Kenji Sugita <sugita@sra.co.jp>)
List pgsql-general
> PostgreSQL 7.1.2 Administrator's Guide says as follows:
>
>     Chapter 8. Backup and Restore
>     8.1. SQL Dump
>
>     Important: When your database schema relies on OIDs (for instances as
>     foreign keys) you must instruct pg_dump to dump the OIDs as well. To do
>     this, use the -o command line option.
>
> Is the -o option still required for 7.1.2 version for a database using foreign
> keys?

Only if you use object ids (OID's).

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Jason Earl
Date:
Subject: Re: Roll Back dont roll back counters
Next
From: Tom Lane
Date:
Subject: Re: why sequential scan