Hi,
there is a problem with the backup utility when creating a plain backup
- when you select data-only and select the disable triggers option, the
triggers are not disabled. (i.e. it does not add "--disable-triggers" or
"-X" to the command line.
Version: 1.2.1
OS Win XP SP2
Distribution: Postgres 8.0.3 Win32 installer distribution
To reproduce:
1. Create two tables where one references the other with a foreign key.
2. Backup the database using Plain option - Select Data only - Disable
triggers.
3. Examine the resultant file - there are no commands to disable triggers.
This is not an error with the pg_dump.exe since this works from the
command line when you add the --disable-triggers option.
Regards
Howard Cole
www.selestial.com