From: Bruno G. Albuquerque <bga@bug-br.org.br>
To: pgsql-admin@postgresql.org
Subject: Problem with backups and functions.
Date: Fri, 18 Mar 2005 16:55:43 -0300
Message-ID: <423B323F.1080401@bug-br.org.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bga@bug-br.org.br
Subject: Re: Problem with backups and functions.
In-Reply-To: <423B323F.1080401@bug-br.org.br>
References: <423B323F.1080401@bug-br.org.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox