Hi Jodi,
Its to stop the triggers firing when you restore the new database from
the dumped file.
Imagine that the triggers have already done their work on other tables
when the data was first inserted or
later changed.
With pg_dump you are taking a snap shot that you would lat
On Tue, 9 Apr 2002, Jodi Kanter wrote:
> I just completed a data only dump of a table by using the following command:
>
> pg_dump genex -Rau -t species > species.sql
>
> I noticed that the first line of the file seems to be disabling some
> postgres trigger. It reads:
>
> UPDATE "pg_class" SET "
I just completed a data only dump of a table
by using the following command:
pg_dump genex -Rau -t species >
species.sql
I noticed that the first line of the file
seems to be disabling some postgres trigger. It reads:
UPDATE "pg_class" SET "reltriggers" = 0 WHERE
"relname" = 'species';
