Postgres Pro
Downloads
Home   >   mailing lists

Thread: UUID/GUID

UUID/GUID

From
Ozz Nixon
Date:
I found a page:

    http://www.postgresql.org/docs/8.3/static/uuid-ossp.html

Is that the only way to get UUID from postgresql?

* We are in the midst of porting a replication product to support postgresql, which relies on UUID/GUID for uniqueness
insteadof Sequences and Site ID's. 

Thanks,
O.

Re: UUID/GUID

From
"Joshua D. Drake"
Date:
On Thu, 2010-06-17 at 20:56 -0400, Ozz Nixon wrote:
> I found a page:
>
>     http://www.postgresql.org/docs/8.3/static/uuid-ossp.html
>
> Is that the only way to get UUID from postgresql?
>
> * We are in the midst of porting a replication product to support postgresql, which relies on UUID/GUID for
uniquenessinstead of Sequences and Site ID's. 

No you can use your own library as well (or language library).

Joshua D. Drake


>
> Thanks,
> O.

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering

Re: UUID/GUID

From
"Joshua D. Drake"
Date:
On Thu, 2010-06-17 at 20:56 -0400, Ozz Nixon wrote:
> I found a page:
>
>     http://www.postgresql.org/docs/8.3/static/uuid-ossp.html
>
> Is that the only way to get UUID from postgresql?
>
> * We are in the midst of porting a replication product to support postgresql, which relies on UUID/GUID for
uniquenessinstead of Sequences and Site ID's. 

No you can use your own library as well (or language library).

Joshua D. Drake


>
> Thanks,
> O.

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering