On Mon, Mar 07, 2016 at 11:03:39AM -0700, David G. Johnston wrote: > > 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 ... > > > > ... indexes > > > Why is the surprising? It's not surprising to me. I was making sure which way things are because the documentation I consulted wasn't clear on that for me. The way things turn out to be -- so much the better ! Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general