[ADMIN] Problem with backups and functions.

2005-03-20 Thread Bruno G. Albuquerque
I am not sure if I am doing something wrong or a hit a bug, so here it goes: I am running PostgreSQL 8.0.1 under Windows 2000. We have this database here which is really small and has a set of 5 functions. All the functions are programmed using pgpsql so we used the functionality where we can us

Re: [ADMIN] Problem with backups and functions.

2005-03-18 Thread Joshua D. Drake
On Fri, 2005-03-18 at 17:40 -0300, Bruno G. Albuquerque wrote: > Hi Tom. > > Thanks for the reply. I am sure this is not the case. I am doing test > dumps on my machine (only PostgreSQL 8.0.1 installed) and the server is > also running PostgreSQL 8.0.1. Can you describe your exact process? You

Re: [ADMIN] Problem with backups and functions.

2005-03-18 Thread Bruno G. Albuquerque
Hi Tom. Thanks for the reply. I am sure this is not the case. I am doing test dumps on my machine (only PostgreSQL 8.0.1 installed) and the server is also running PostgreSQL 8.0.1. -Bruno Tom Lane wrote: "Bruno G. Albuquerque" <[EMAIL PROTECTED]> writes: The problem is that when we do a backup/r

Re: [ADMIN] Problem with backups and functions.

2005-03-18 Thread Tom Lane
"Bruno G. Albuquerque" <[EMAIL PROTECTED]> 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 u

[ADMIN] Problem with backups and functions.

2005-03-18 Thread Bruno G. Albuquerque
I am not sure if I am doing something wrong or a hit a bug, so here it goes: I am running PostgreSQL 8.0.1 under Windows 2000. We have this database here which is really small and has a set of 5 functions. All the functions are programmed using pgpsql so we used the functionality where we can use n