Skip site navigation (1) Skip section navigation (2)

Bug in pgadmin dump

From: Howard Cole <howard(dot)cole(at)selestial(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug in pgadmin dump
Date: 2005-06-09 07:39:44
Message-ID: 42A7F240.7080108@selestial.com (view raw or flat)
Thread:
Lists: pgadmin-support
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




pgadmin-support by date

Next:From: Dave PageDate: 2005-06-09 09:44:15
Subject: Re: Bug in pgadmin dump
Previous:From: Miha RadejDate: 2005-06-07 19:30:50
Subject: Re: startup error message "cannot convert from

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group