| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2005-06-09 09:44:15 | Re: Bug in pgadmin dump |
| Previous Message | Miha Radej | 2005-06-07 19:30:50 | Re: startup error message "cannot convert from |