We have a pretty large db (10 G and ~ 100 tables). Sometimes (when somebody deleted something usefull from table) it is necessary to restore only one or two tables from backup. I've set up daily full database backup (pg_dump -U <user> <db>) and per-table backups (pg_dump -U <user> -t <table> <db>).
The question is about constrains & foreign keys. It's clear that restoring only one table to yesturday's state may break some foreign keys. Do I need to do some extra things to make restore successfully?
Postgres 8.1.x
-- Vladimir Rusinov Voronezh, Russia UNIX Admin @ Murano Software