[Freeswitch-users] PostgreSQL - p_key

[Michael Jerris]

I've used bigint with a default of a sequence in the past to good results.
 make sure to add the option to not recreate the tables so we don't mess up
your fields when we change scheme and when upgrading review for schema
changes and make them manually

On Monday, November 3, 2014, Joel White <joelewhite at gmail.com> wrote:

> Is there another datatype that would be more suitable.  I plan to have
> massive amounts of traffic.  Would the time datatype be more suitable?
>
>
>
> On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite at gmail.com
> <javascript:_e(%7B%7D,'cvml','joelewhite at gmail.com');>> wrote:
>
>> Thank you Chris
>>
>> On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr at gmail.com
>> <javascript:_e(%7B%7D,'cvml','blasterjr at gmail.com');>> wrote:
>>
>>> Serial is identical to mysql's Auto Increment, so i'm going to say yes.
>>>
>>> On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite at gmail.com
>>> <javascript:_e(%7B%7D,'cvml','joelewhite at gmail.com');>> wrote:
>>>
>>>> Chris and William,
>>>>
>>>> Can those added PKs have a data type of SERIAL?
>>>>
>>>>
>>>>
>>>> On Wed, Oct 15, 2014 at 11:33 PM, William King <
>>>> william.king at quentustech.com
>>>> <javascript:_e(%7B%7D,'cvml','william.king at quentustech.com');>> wrote:
>>>>
>>>>>  Yes, you can add columns to those tables with no issues. Try it and
>>>>> see.
>>>>>
>>>>> William King
>>>>> Senior Engineer
>>>>> Quentus Technologies, INC
>>>>> 1037 NE 65th St Suite 273
>>>>> Seattle, WA 98115
>>>>> Main:   (877) 211-9337
>>>>> Office: (206) 388-4772
>>>>> Cell:   (253) 686-5518william.king at quentustech.com <javascript:_e(%7B%7D,'cvml','william.king at quentustech.com');>
>>>>>
>>>>> On 10/8/14 9:44 AM, 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: consulting at freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting at freeswitch.org');>http://www.freeswitchsolutions.com
>>>>>
>>>>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>>>>>
>>>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
>>>>>
>>>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users at lists.freeswitch.org');>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>> Professional FreeSWITCH Consulting Services:
>>>>> consulting at freeswitch.org
>>>>> <javascript:_e(%7B%7D,'cvml','consulting at 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 at lists.freeswitch.org
>>>>> <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users at 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 at freeswitch.org
>>>> <javascript:_e(%7B%7D,'cvml','consulting at 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 at lists.freeswitch.org
>>>> <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users at 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 at freeswitch.org
>>> <javascript:_e(%7B%7D,'cvml','consulting at 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 at lists.freeswitch.org
>>> <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users at lists.freeswitch.org');>
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> http://www.freeswitch.org
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141103/1e303ff8/attachment-0001.html