<div dir="ltr"><div dir="ltr">Hi Giovanni,</div><div dir="ltr"><br></div><div>Thanks for your comment.</div><div><br></div><div>I think the table is used by fs_cli to list available commands.</div><div>Another possible solution I came across is to use Replica Identity " ALTER TABLE mytable REPLICA IDENTITY FULL", will give it a try.</div><div dir="ltr"><br clear="all"><div><div dir="ltr" data-smartmail="gmail_signature"><div dir="ltr">Abdirahman A. Osman<div><div><br></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 27 Oct 2021 at 13:53, Giovanni Maruzzelli <<a href="mailto:gmaruzz@gmail.com" target="_blank">gmaruzz@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div>On Wed, Oct 27, 2021 at 5:44 PM Abdirahman Osman <<a href="mailto:abdirahman.osm@gmail.com" target="_blank">abdirahman.osm@gmail.com</a>> wrote:<br></div></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>I am using postgres with BDR bidirectional replication which requires primary keys for the freeswitch tables.</div><div><br></div><div> So far so good , except freeswitch is complaining about one table here is the error<br></div><div><br></div><div>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<br>2021-10-26 23:40:47.772796 95.47% [ERR] mod_pgsql.c:551 Error executing query:<br>ERROR: column "complete_uuid" is of type uuid but expression is of type integer<br>LINE 1: insert into complete values (0,'hash_remote', 'list', '', ''...<br></div><div><br></div><div>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. </div><div><br></div><div>Here is the structure of my complete table with the new column complete_uuid as primary key.</div><div><br></div><div>CREATE TABLE :myschema.complete (<br>complete_uuid uuid DEFAULT public.gen_random_uuid() PRIMARY KEY,<br>sticky INTEGER,<br>a1 VARCHAR(128),<br>a2 VARCHAR(128),<br>a3 VARCHAR(128),<br>a4 VARCHAR(128),<br>a5 VARCHAR(128),<br>a6 VARCHAR(128),<br>a7 VARCHAR(128),<br>a8 VARCHAR(128),<br>a9 VARCHAR(128),<br>a10 VARCHAR(128),<br>hostname VARCHAR(256)<br> );<br></div><div><br></div><div>Any suggestions?</div><div><br></div></div></blockquote><div><br></div><div>What is the table "complete" used for? by which module?<div><br></div><div>You can't do anything, only modify source in a way to explicit use fields, and give a default to generate pk, or fill the pk explicitly.</div><div><br></div><div>Anyway, which module uses this table?</div><div></div></div><div><br></div><div>-giovanni</div><div><br></div><div><br>--<br></div></div><div dir="ltr">Sincerely,<br><br>Giovanni Maruzzelli<br>OpenTelecom.IT<br>cell: +39 347 266 56 18<br><br></div></div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a href="https://signalwire.com" rel="noreferrer" target="_blank">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a href="https://signalwire.community" rel="noreferrer" target="_blank">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div></div>