Joe Kramer <cckra...@gmail.com> writes: > On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver <akla...@comcast.net> wrote: >> What version of Postgres are you dumping from, restoring to? Which version of
> I am using client 8.1.9 to dump from server 8.3.0 (unable to use client > 8.3.x) > Importing to server 8.3.7. You mean you are dumping from an 8.3 server with an 8.1 pg_dump? That is pretty much guaranteed not to work; I am surprised that the only symptom you notice is bad trigger state. Why do you feel you can't use an up-to-date pg_dump? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general