Re: function "XXX" already exists with same argument types

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: function "XXX" already exists with same argument types
Date: 2011-10-06 06:59:17
Message-ID: 4E8D51C5.7070402@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#ffffff"
text="#000000">
On 10/05/2011 05:27 PM, Alexander Farber wrote:
<blockquote
cite="mid:CAADeyWiQJVZ-5ZCK8gYo6H9at_ztfGHN-PXToj8E0ERYTjV2Cg(at)mail(dot)gmail(dot)com"
type="cite">
<pre wrap="">Thank you Michael, but no -

On Wed, Oct 5, 2011 at 5:24 PM, Michael Glaesemann <a class="moz-txt-link-rfc2396E" href="mailto:grzm(at)seespotcode(dot)net">&lt;grzm(at)seespotcode(dot)net&gt;</a> wrote:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">psql:pref-2011-10-05-a.sql:339: ERROR: &nbsp;function "pref_update_match"
already exists with same argument types
ALTER FUNCTION
</pre>
</blockquote>
<pre wrap="">
Likely someone mistakenly added the functions to template1 of the machine you're restoring onto and they're getting added to the new database when it's created.
</pre>
</blockquote>
<pre wrap="">
# psql -U postgres -W template1
Password for user postgres:
psql (8.4.7)
Type "help" for help.

template1=# \df
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)
</pre>
</blockquote>
What is your process for creating the database?<br>
Did you run your script once and then run it again after failure? It
does not run in a transaction, unless you ask it to, so if it failed
on something and you want to run it again, you should drop the
database and create it again.<br>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.9 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-10-06 07:14:48 Re: I/O error on data file, can't run backup
Previous Message Leif Biberg Kristensen 2011-10-06 06:15:14 Re: I/O error on data file, can't run backup