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 dump from Windows creating a file foo.sql You restore the file where? What OS? What command? Sincerely, Joshua D. Drake > > -Bruno > > Tom Lane wrote: > > "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 using a pre-8.0 pg_dump? > > > > regards, tom lane > > > > ********************************************************************** > InformaÃÃo transmitida destina-se apenas à pessoa a quem foi endereÃada e > pode conter informaÃÃo confidencial, legalmente protegida e para > conhecimento exclusivo do destinatÃrio. Se o leitor desta advertÃncia nÃo > for o seu destinatÃrio, fica ciente de que sua leitura, divulgaÃÃo ou > cÃpia à estritamente proibida. Caso a mensagem tenha sido recebida por > engano, favor comunicar ao remetente e apagar o texto de qualquer computador. > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon this information, by person or entity > other than the intended recipient is prohibited. If you received this in > error, please contact the sender and delete the material from any computer. > ********************************************************************** > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564 Custom programming, 24x7 support, managed services, and hosting Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG Reliable replication, Mammoth Replicator - http://www.commandprompt.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
