Dear Adrian!
2018-03-20 15:47 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>: > >> >> When it would be useful? >> > > https://www.postgresql.org/docs/10/static/app-pgrestore.html > "--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. Use this if you have > referential integrity checks or other triggers on the tables that you do > not want to invoke during data reload. > > Presently, the commands emitted for --disable-triggers must be done as > superuser. So you should also specify a superuser name with -S or, > preferably, run pg_restore as a PostgreSQL superuser. > > > > >> Firstly I supposed that data copy somehow could start the triggers - but >> how? >> >> Which triggers? Or how they fired with this order? >> > I have read it, but I don't understand it. Do you have a good example? Thanks! dd
