postgres function error on Insert operation for object identifier types : SQL Error [42725]: ERROR: more than one operator named +

Postgresql Insert statement on Objectidentifier datatype 'regoper' returns error 'SQL Error [42725]: ERROR: more than one operator named +' even though a single operator value is given

Hi, I have a created a table for all Object Identifier data types of Postgresql. The DDL statement for the same is as follows :

CREATE TABLE public.objectidentifiers (
	pk int4 NOT NULL,
	col_oid oid NULL,
	col_regclass regclass NULL,
	col_regcollation regcollation NULL,
	col_regconfig regconfig NULL,
	col_regdictionary regdictionary NULL,
	col_regnamespace regnamespace NULL,
	col_regoper regoper NULL,
	col_regoperator regoperator NULL,
	col_regproc regproc NULL,
	col_regprocedure regprocedure NULL,
	col_regrole regrole NULL,
	col_regtype regtype NULL,
	CONSTRAINT objectidentifiers PRIMARY KEY (pk)
);

where public is the schema name and objectidentifiers is the table.

I am trying to execute this Insert Operation :

INSERT INTO public.objectidentifiers VALUES
(1,
564182,
'pg_type',
'"POSIX"',
'english',
'simple',
'pg_catalog',
'+',
'*(integer,integer)',
'"SRC"."area_equal_procedure"',
'sum(int4)',
'postgres',
'integer'
);

But this is giving the below error :

> Error occurred during SQL query execution
>
> Reason:<BR> SQL Error [42725]: ERROR: more than one operator named +
>
> Position: 114"

Can someone tell what is wrong in the Insert statement, even though I am using the right value for the data type

the issue is probably because regoper in postgres expects an operator object identifier instead of the operator itself so I think '+' is triggering the issue.
Instead you can use pg_operator system catalog table to find the operator id for +.

INSERT INTO public.objectidentifiers VALUES
(1,
564182,
'pg_type',
'"POSIX"',
'english',
'simple',
'pg_catalog',
(SELECT oid FROM pg_operator WHERE oprname = '+'),
'*(integer,integer)',
'"SRC"."area_equal_procedure"',
'sum(int4)',
'postgres',
'integer'
);