We are currently developing a java RMI Server to manage database backup on
FreeBSD 4.1 running Postgres 7.0.2 (we plan to upgrade to 7.1 when it is
released). The server will pg_dump individual tables and entire databases
at specified intervals and manage backup verification and backup file
At 11:09 5/02/01 -0800, Peter Schmidt wrote:
If I pg_dump a single table which has a foreign key constraint, and
subsequently backup the constraint table, won't the data be out of sync?
Each pg_dump will run in it's own transaction, right?
Yes.
Is there a way to dump multiple tables within a
Philip Warner [EMAIL PROTECTED] writes:
If it is dumped as inserts you will get RI errors. If done via copy then
some but not all constraints will be evaluated - I think that COPY does not
fire triggers.
Say what? COPY certainly does fire triggers ...
regards, tom
At 20:16 5/02/01 -0500, Tom Lane wrote:
Philip Warner [EMAIL PROTECTED] writes:
If it is dumped as inserts you will get RI errors. If done via copy then
some but not all constraints will be evaluated - I think that COPY does not
fire triggers.
Say what? COPY certainly does fire triggers ...
Philip Warner [EMAIL PROTECTED] writes:
Say what? COPY certainly does fire triggers ...
Is there any difference between COPY and INSERT other than speed?
COPY does not fire ON INSERT rules. Other than that, AFAIR they're
the same from an integrity point of view.