X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EBE5B56805 for ; Fri, 18 Mar 2005 19:57:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41358-04 for ; Fri, 18 Mar 2005 19:57:14 +0000 (GMT) Received: from camelopardalis.dba.com.br (unknown [200.184.148.70]) by svr1.postgresql.org (Postfix) with ESMTP id C48EE56540 for ; Fri, 18 Mar 2005 19:57:12 +0000 (GMT) Received: from [10.17.5.187] (HP1201L5 [10.17.5.187]) by cygnus.dba.com.br with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2655.55) id HDWWMVS7; Fri, 18 Mar 2005 16:55:42 -0300 Message-ID: <423B323F.1080401@bug-br.org.br> Date: Fri, 18 Mar 2005 16:55:43 -0300 From: "Bruno G. Albuquerque" Organization: DBA Engenharia de Sistemas User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Problem with backups and functions. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/308 X-Sequence-Number: 16806 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