Search Postgresql Archives

Re: partitioning question -- how to guarantee uniqueness across partitions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Hi Whit,
>
> you could consider using GUIDs instead of Integer for primary keys.
> Here is a nice blog post explaining how to do this in Rails:
>    http://ariejan.net/2008/08/12/ruby-on-rails-uuid-as-your-activerecord...
>
> Best Regards,
>   Arndt Lehmann

just a note: As per above blog post, the GUID are generated using a
Ruby module.
PostgreSQL actually comes with a baked in UUID column type. That
probably will be a more efficient solution.

Regards,
  Arndt

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux