Joel, i use MySQL (i know you're looking for PG) i have added primary keys to most of my tables (Voicemail Preferences, Voicemail Messages, FIFO tables) without any issues, i have yet to test against the the calls & call state tables.  I don't think it'd cause any issues except if FreeSWITCH ever tries to rebuild the tables in a later update, at which point you'd have to readd your PK

On Wed, Oct 15, 2014 at 10:35 AM, Joel White <joelewhite@gmail.com> wrote:
Not sure

What I am trying to do is setup a Multi-Master replication of all database entries.  This way when the system fails over to the secondary or tertiary servers all call details for recovery etc are on that system.

So I am trying to add a primary key to all db tables that I want to be replicated.

I just do not want to run into the situation of FreeSWITCH breaking because it does not understand how to handle the added primary key

On Thu, Oct 9, 2014 at 1:14 AM, Seven Du <dujinfang@gmail.com> wrote:
pg has a hidden oid which is unique, can you use that? 


On Wednesday, October 8, 2014 at 9:44 PM, Joel White wrote:

Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?

I am asking because I am working on a multi-master replication setup

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:

Official FreeSWITCH Sites

FreeSWITCH-powered IP PBX: The CudaTel Communication Server

FreeSWITCH-users mailing list


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org