| From: | Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | pjw(at)rhyme(dot)com(dot)au |
| Subject: | I still cannot force pg_dump to disable triggers |
| Date: | 2001-05-09 15:23:34 |
| Message-ID: | Pine.LNX.4.21.0105091716190.17210-100000@pc10.radnoti-szeged.sulinet.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Date: Fri, 16 Mar 2001 22:58:42 +1100
> From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
> To: kovzol(at)math(dot)u-szeged(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michaël Fiey | 2001-05-09 15:36:53 | Re: Case sensitive order by |
| Previous Message | Tom Lane | 2001-05-09 15:21:30 | Re: Outstanding patches |