Re: problem with foreign keys + data-only backup

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Markus Mehrwald <mehrwald(at)ira(dot)uka(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with foreign keys + data-only backup
Date: 2008-08-22 16:02:41
Message-ID: 20080822160241.GA4169@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2008-08-22 16:42:03 Re: [GENERAL] Surprising syntax error
Previous Message Tom Lane 2008-08-22 15:37:35 Re: Postgresql 8.3 statistic stadistinct value dead wrong even with default_statistics_target=1000