pg_restore man page question - Mailing list pgsql-general

From Karsten Hilbert
Subject pg_restore man page question
Date
Msg-id 20160307171717.GA5209@hermes.hilbert.loc
Whole thread Raw
Responses Re: pg_restore man page question  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: pg_restore man page question  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
The man page of pg_restore says

    --disable-triggers
        This option is relevant only when performing a
        data-only restore. It instructs pg_restore to execute
        commands to temporarily disable triggers on the
        target tables while the data is reloaded. [...]

This hint seems overly narrow: when doing a restore of schema
PLUS data (IOW, not a schema-only restore) it should apply,
too, shouldn't it ?

Otherwise it would suggest that pg_restore does this:

- restore basic table structure
- restore data
- restore constraints and triggers and ...

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: index problems (again)
Next
From: rob stone
Date:
Subject: Re: Inserting JSON via Java PreparedStatment