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

On 10/05/2011 05:27 PM, Alexander Farber wrote: <blockquote
cite="mid:CAADeyWiQJVZ-5ZCK8gYo6H9at_ztfGHN-PXToj8E0ERYTjV2Cg@mail.gmail.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@seespotcode.net"><grzm@seespotcode.net></a>wrote:
 
</pre><blockquote type="cite"><blockquote type="cite"><pre wrap="">psql:pref-2011-10-05-a.sql:339: ERROR:  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
addedto 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 functionsSchema | 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
againafter failure? It does not run in a transaction, unless you ask it to, so if it failed on something and you want
torun it again, you should drop the database and create it again.<br /><br />