[Freeswitch-users] PostgreSQL - p_key

[Joel White]

Well here is what I have done, I think that it should work.  The PK is a
SERIAL DataType and I went into the sequence properties and set it to
CYCLED.  The max value is 9223372036854775807 and will re-cycle once that
number is reached.

I only added this to the channels table right now.  I have not seen any
issues yet.

On Mon, Nov 3, 2014 at 4:50 PM, Michael Jerris <mike at jerris.com> wrote:

> 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>
>> wrote:
>>
>>> Thank you Chris
>>>
>>> On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <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>
>>>> 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> 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
>>>>>>
>>>>>> 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.orghttp://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.orghttp://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
>>>>>> 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
>>>>>> 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
>>>>> 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
>>>>> 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
>>>> 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
>>>> 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
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> 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/20141104/64ac6f7b/attachment.html