Thread: I still cannot force pg_dump to disable triggers
> 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
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 |/