Saranya Sivakumar <sarlavk@yahoo.com> writes:
> I am having trouble to dump a table on postgres 8.1.5 version using pg_dump 7.3/7.4.
Why would you expect that to work? An old pg_dump can't be expected to
understand system catalog changes that happened after it came out.
> I have tried dumping using the 8.1.5 version of pg_dump and restore using 7.3, but that gives errors too, and I have
tomanually edit and comment out the lines causing problem.
Going backwards is always going to cause problems, especially across
multiple releases --- there's a pretty large feature gap between 7.3
and 8.1. Why in the world would you want to, anyway?
regards, tom lane