Postgres Pro
Downloads
Home   >   mailing lists

Re: problem with foreign keys + data-only backup - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: problem with foreign keys + data-only backup
Date
Msg-id 20080822160241.GA4169@alvh.no-ip.org
Whole thread Raw
In response to Re: problem with foreign keys + data-only backup  (Markus Mehrwald <mehrwald@ira.uka.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql 8.3 statistic stadistinct value dead wrong even with default_statistics_target=1000
Next
From: Decibel!
Date:
Subject: Re: Single character bitfields