On Thu, 4 Sep 2003, Marcus Andree S. Magalhaes wrote:
> I need to transfer a database from postgres 7.3.3 to another server, managed
> by other people, running version 7.2.3.
>
> So, I've pg_dump'ed the db with SQL output.
>
> While visually inspecting the file, I've noticed that were no reference
> to table constraints, like foreign keys. Going on with the process, I've
> tried to restore the database using psql -f <filename> and it generated
> tons of errors (one error per SQL command, I guess) related to SQL syntax.
Can you give some examples of the lines that errored and what the errors
were to help us narrow it down a bit.