Hi! 8.0.1 and 8.1 beta. Triggers are still fired although option --disable-triggers is applied to pg_restore. The fired triggers abort pg_restore because of the foreign keys violations. The following restore script used to be working but it suddently doesn't. I don't remember I ever changed this script since it had worked. #Backup command: #PGCLIENTENCODING=UNICODE pg_dump -Fc db1 > db1 # #Restore commands: pg_restore -l db1 >list createdb -E UNICODE db1 pg_restore -F c -L list -v -d db1 -s db1 >log-schema 2>&1 pg_restore -F c -L list -v -d db1 -a --disable-triggers db1 >log-data 2>&1 Any idea will be much appreciated. Regards, CN -- http://www.fastmail.fm - Email service worth paying for. Try it for free ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
