Markus Mehrwald wrote: > Hi, > > I do not think this will work. As far as I know foreign key checks are > not triggers. Postgres is very strict with things concerning referential > integrity so you cannot turn them off. Actually you are mistaken -- FKs are triggers, and you can turn them off. There is a reason data-only backups are not recommended. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support