I still cannot force pg_dump to disable triggers 
Author Message
 I still cannot force pg_dump to disable triggers

Quote:
> Date: Fri, 16 Mar 2001 22:58:42 +1100


> Subject: Re: I cannot force pg_dump to disable triggers


> >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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 26 Oct 2003 23:48:22 GMT
 I still cannot force pg_dump to disable triggers


Quote:
>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.   |----/       -  \

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   |/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Mon, 27 Oct 2003 01:44:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. pg_dump:cannot find function for trigger

2. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

3. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump ...

4. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

5. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump ...

6. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

7. pgsql/src/bin/pg_dump common.c pg_dump.c pg_dump.h

8. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump.h

9. pgsql/src/bin/pg_dump common.c pg_dump.c pg_dump.h

10. pgsql/src/bin/pg_dump (common.c pg_backup_archiver.h pg_dump.c pg_dump.h)

11. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

12. pgsql/src/bin/pg_dump (pg_dump.c pg_dump.h pg_dumpall.sh)


 
Powered by phpBB® Forum Software