Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with backups and functions. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problem with backups and functions.
Date
Msg-id 10064.1111177445@sss.pgh.pa.us
Whole thread Raw
In response to Problem with backups and functions.  ("Bruno G. Albuquerque" <balbuquerque@dba.com.br>)
Responses Re: Problem with backups and functions.  ("Bruno G. Albuquerque" <balbuquerque@dba.com.br>)
List pgsql-admin
Tree view 
"Bruno G. Albuquerque" <balbuquerque@dba.com.br> writes:
> The problem is that when we do a backup/restore procedure (using
> pg_dump/pg_restore), the functions are restored without the named
> parameters, which make then fail as inside the function the parameter
> names are mentioned.

Perhaps you are using a pre-8.0 pg_dump?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Bruno G. Albuquerque"
Date:
Subject: Problem with backups and functions.
Next
From: "Bruno G. Albuquerque"
Date:
Subject: Re: Problem with backups and functions.