pg_dump and foreign keys

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: pg_dump and foreign keys
Date: 2000-01-20 18:44:53
Message-ID: 200001201844.SAA10286@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I don't seem to be ableto use pg_dump where a table uses foreign key
constraints. I seem to remember there being a message about pg_dump
problems but I can't remember whether it was relevant to this.

$ pg_dump bray
getTables(): relation 'area': cannot find function with oid 1655 for trigger
RI_ConstraintTrigger_20235

[area is a table with RI constaints]

This seems to be because pg_dump.c getFuncs() excludes system functions
and thus causes getTables() to fail when it finds the RI triggers.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Neither is there salvation in any other; for there is
none other name under heaven given among men, whereby
we must be saved." Acts 4:12

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Elphick 2000-01-20 18:55:40 Re: [HACKERS] COPY problems with psql / libpq
Previous Message Oliver Elphick 2000-01-20 18:44:51 Re: [HACKERS] COPY problems with psql / libpq