| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
| Cc: | gss+pg(at)cs(dot)brown(dot)edu, postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: circular REFERENCES |
| Date: | 2002-06-20 17:12:49 |
| Message-ID: | 3D120D11.F5B0F665@Yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Wood | 2002-06-20 17:13:30 | Re: Yet another "Why won't PostgreSQL use my index?" |
| Previous Message | philip johnson | 2002-06-20 17:07:14 | Re: database size |