| From: | "Bruno G(dot) Albuquerque" <bga(at)bug-br(dot)org(dot)br> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Problem with backups and functions. |
| Date: | 2005-03-18 19:55:43 |
| Message-ID: | 423B323F.1080401@bug-br.org.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 named parameters in the functions.
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.
For example, the funtion that would originally be:
cubfn002_recuperar_nu_ordem(numero_pessoa int8)
Would be restored as:
cubfn002_recuperar_nu_ordem(int8)
Due to that the function errors out as "numero_pessoa" is used inside it
but is now an unknow identifier.
Am I missing something?
Thanks in advance.
-Bruno
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno G. Albuquerque | 2005-03-18 20:04:41 | Problem with backups and functions. |
| Previous Message | Steve Crawford | 2005-03-18 16:24:09 | Re: Too many clients----A big problem for my team |