Re: circular REFERENCES - Mailing list pgsql-general

From Jan Wieck
Subject Re: circular REFERENCES
Date
Msg-id 3D120D11.F5B0F665@Yahoo.com
Whole thread Raw
In response to circular REFERENCES  (Gregory Seidman <gss+pg@cs.brown.edu>)
List pgsql-general
Jean-Luc Lachance wrote:
>
> I know exactly what you what to do but...
> Try to do a dump and restore...

If you think dump and restore would fail on circular references you're
wrong. They get restored and it works perfectly good, even if you do a
data-only dump, because pg_dump then emits special commands disabling
triggers before loading the data :-)


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Yet another "Why won't PostgreSQL use my index?"
Next
From: Peter Dimov
Date:
Subject: URGENT: Performance tuning