Pgadmin - Bug in pgadmin dump

Author

Bug in pgadmin dump

Howard Cole

2005-06-09, 3:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Dave Page

2005-06-09, 7:23 am

> -----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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Sponsored Links