Re: [GENERAL] Moving a database between servers

2003-12-11 Thread Tom Lane
"Michael ." <[EMAIL PROTECTED]> writes: > [ SQL function that references a TEMP table ] > How do I get these functions to import correctly if it > fails due to this "current_transaction" table not > being found? I don't think there is any good solution in 7.3, because it will insist on trying to

Re: [GENERAL] Moving a database between servers

2003-12-10 Thread Keith C. Perry
Quoting "Michael ." <[EMAIL PROTECTED]>: > I am trying to move a postgresql database from one > server to another. The original server is 7.1.3, and > the new one is 7.3.4. > > I went on the old and used the command: > pg_dumpall > dump > > On the new: > psql -e < dump > > I get this for multi

[GENERAL] Moving a database between servers

2003-12-10 Thread Michael .
I am trying to move a postgresql database from one server to another. The original server is 7.1.3, and the new one is 7.3.4. I went on the old and used the command: pg_dumpall > dump On the new: psql -e < dump I get this for multiple functions. (Error follows surrounded by *'s) CREATE FUN