Thread: Bug in pgadmin dump

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

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Howard Cole
> Sent: 09 June 2005 08:40
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Bug in pgadmin dump
>
> 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.

Hi,

Thanks for the bug report Howard - I've fixed this in SVN trunk and back
patched it for 1.2.3.

Regards, Dave.