Forum OpenACS Q&A: Re: General Comments Broken?

Collapse
Posted by Richard Hamilton on
Here are the duplicate pl_pgsql functions. Is it possible that an upgrade script has failed to 'create or replace'?

Could such duplicates explain this error?

Which of the functions should be kept?

oakmasters=# \df apm*

List of functions
Schema | Name | Result data type |
Argument data types

--------+--------------------------------------------+-------------------+-----------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------
--------------------
public | apm__get_value | character varying | character varying, character varying
public | apm__get_value | character varying | integer, character varying

public | apm__id_for_name | integer | character varying, character varying
public | apm__id_for_name | integer | integer, character varying

public | apm__register_parameter | integer | integer, character varying, character varying, character varying
, character varying, character varying, character varying, character varying, integer, integer
public | apm__register_parameter | integer | integer, character varying, character varying, character varying
, character varying, character varying, character varying, integer, integer

public | apm__set_value | integer | character varying, character varying, character varying
public | apm__set_value | integer | integer, character varying, character varying

public | apm_package_version__remove_dependency | integer | character varying, character varying, integer
public | apm_package_version__remove_dependency | integer | integer

public | apm_package_version__remove_interface | integer | character varying, character varying, integer
public | apm_package_version__remove_interface | integer | integer

...

(55 rows)