Iñigo Martinez Lasala wrote: > Third one, and we haven't been able to fix it, is we cannot restore data > dump via psql due to psql does not have an option to disable triggers. > So, when restoring data, it fails. So... is there any way to disable in > a psql session all triggers same way like with pg_restore > --disable-triggers? Or can we convert plain text dump to be processed > by pg_restore? Perhaps a table by table trigger disabling script? Have you tried using 8.2's pg_dump instead of the old one? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin