[Freeswitch-users] Postgress BDR insert failed for "complete" table

[Abdirahman Osman]

Hello,

I am using postgres  with BDR bidirectional replication which requires
primary keys for the freeswitch tables.

 So far so good , except freeswitch is complaining about one table here is
the error

2021-10-26 23:40:47.772796 95.47% [DEBUG] mod_pgsql.c:784 Query (insert
into complete values (0,'hash_remote', 'list', '', '', '', '', '', '', '',
'',  'dagobah-api-gw-1-2')) returned PGRES_FATAL_ERROR
2021-10-26 23:40:47.772796 95.47% [ERR] mod_pgsql.c:551 Error executing
query:
ERROR:  column "complete_uuid" is of type uuid but expression is of type
integer
LINE 1: insert into complete values (0,'hash_remote', 'list', '', ''...

What I noticed is that freeswitch is doing an INSERT INTO command with no
column names specified. I checked the source code and found this to be the
only case for the "complete" table whereas the other tables when INSERT
INTO is used column names are specified.

Here is the structure of my  complete table with the new column
complete_uuid as primary key.

CREATE TABLE :myschema.complete (
complete_uuid uuid DEFAULT public.gen_random_uuid() PRIMARY KEY,
sticky  INTEGER,
a1  VARCHAR(128),
a2  VARCHAR(128),
a3  VARCHAR(128),
a4  VARCHAR(128),
a5  VARCHAR(128),
a6  VARCHAR(128),
a7  VARCHAR(128),
a8  VARCHAR(128),
a9  VARCHAR(128),
a10 VARCHAR(128),
hostname VARCHAR(256)
        );

Any suggestions?

Thanks

Abdirahman A. Osman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20211027/9b93c5cf/attachment.html>