> Date: Fri, 16 Mar 2001 22:58:42 +1100
> From: Philip Warner <pjw@rhyme.com.au>
> To: kovzol@math.u-szeged.hu
> Subject: Re: I cannot force pg_dump to disable triggers
> 
> At 12:49 16/03/01 +0100, kovacsz wrote:
> >I downloaded the current snapshot and realized that you changed the
> >dumping behaviour about disabling and enabling triggers. Unfortunately I
> >couldn't find the appropriate switches to get the same output before you
> >made this change (I mean beta4). Could you please help? In beta4 I used
> >-xacnDO for the desired result. Now I never get any lines in the output
> >which contains "-- Enable triggers" or "-- Disable triggers".
> 
> I just tried:
> 
>     pg_dump -xacnDO pjw
> 
> and got the enable/disable stuff. Can you check that you did a 'make
> distclean' in pg_dump before you ran the dump? The latest rule is that it
> only does an enable/disable if the dump (or restore) is data-only.
Well, I stopped trying it in March but I'm in a need of changing to 7.1 (I
should use Tom's patch). I did a 'make distclean' but no difference: there
are no lines switching the triggers on/off. I'm using "PostgreSQL 7.1 on
i686-pc-linux-gnu, compiled by GCC egcs-2.91.66".

TIA, Zoltan


Wed, 9 May 2001 17:23:34 +0200 (CEST)
Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
I still cannot force pg_dump to disable triggers
At 17:23 9/05/01 +0200, Kovacs Zoltan wrote:
>Well, I stopped trying it in March but I'm in a need of changing to 7.1 (I
>should use Tom's patch). I did a 'make distclean' but no difference: there
>are no lines switching the triggers on/off. I'm using "PostgreSQL 7.1 on
>i686-pc-linux-gnu, compiled by GCC egcs-2.91.66".

It's because the data-only dump is (incorrectly) dumping the COMMENTs, and
treats SEQUENCE SET entries as schema entries, not data entries. It will be
fixed soon.
 


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Thu, 10 May 2001 03:09:53 +1000
Philip Warner <pjw@rhyme.com.au>
Re: I still cannot force pg_dump to disable triggers