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.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key
ID32B8FAA1 ======================================== "Neither is there salvation in any other; for
thereis none other name under heaven given among men, whereby we must be saved." Acts 4:12