Re: [ADMIN] UUID generation functions

2008-06-06 Thread Peter Eisentraut
Am Dienstag, 3. Juni 2008 schrieb Hyatt, Gordon: > > > http://www.postgresql.org/docs/8.3/static/uuid-ossp.html > > > > My bad - just realised the OP most probably needs a Windows-compatible > > solution and uuid-ossp is not. > > Actually, I'm developing on Windows, but deploying on Linux (both the

Re: [ADMIN] UUID generation functions

2008-06-03 Thread Hyatt, Gordon
Please see my comments in line. > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of Milen A. Radev > Sent: Monday, June 02, 2008 6:24 PM > To: [email protected] > Subject: Re: [ADMIN] UUID generation functions &

Re: [ADMIN] UUID generation functions

2008-06-03 Thread Rommel the iCeMAn
>> But 8.3 still does not generate UUIDs, only stores/compares them This is true, however, only last week I completed a successful pg 8.3 install and during the installation I was able to include UUID generation functions as an option. I now have 10 functions called uuid_something. The ones I

Re: [ADMIN] UUID generation functions

2008-06-02 Thread Milen A. Radev
Milen A. Radev написа: John DeSoi написа: On Jun 2, 2008, at 3:19 PM, Kevin Grittner wrote: Any chance of going to 8.3? http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html But 8.3 still does not generate UUIDs, only stores/compares them. From the link above: PostgreSQL pro

Re: [ADMIN] UUID generation functions

2008-06-02 Thread Milen A. Radev
John DeSoi написа: On Jun 2, 2008, at 3:19 PM, Kevin Grittner wrote: Any chance of going to 8.3? http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html But 8.3 still does not generate UUIDs, only stores/compares them. From the link above: PostgreSQL provides storage and compar

Re: [ADMIN] UUID generation functions

2008-06-02 Thread Joshua D. Drake
On Mon, 2008-06-02 at 18:11 -0400, John DeSoi wrote: > On Jun 2, 2008, at 3:19 PM, Kevin Grittner wrote: > > > Any chance of going to 8.3? > > > > http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html > For reasons mentioned by the other poster, it would be helpful if > PostgreSQL

Re: [ADMIN] UUID generation functions

2008-06-02 Thread John DeSoi
On Jun 2, 2008, at 3:19 PM, Kevin Grittner wrote: Any chance of going to 8.3? http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html But 8.3 still does not generate UUIDs, only stores/compares them. From the link above: PostgreSQL provides storage and comparison functions for

Re: [ADMIN] UUID generation functions

2008-06-02 Thread Hyatt, Gordon
yatt, Gordon; [email protected] > Subject: Re: [ADMIN] UUID generation functions > > >>> On Mon, Jun 2, 2008 at 1:52 PM, in message > <[EMAIL PROTECTED]>, > "Hyatt, > Gordon" <[EMAIL PROTECTED]> wrote: > > does anyone know if there ar

Re: [ADMIN] UUID generation functions

2008-06-02 Thread Kevin Grittner
>>> On Mon, Jun 2, 2008 at 1:52 PM, in message <[EMAIL PROTECTED]>, "Hyatt, Gordon" <[EMAIL PROTECTED]> wrote: > does anyone know if there are any internal > UUID generation functions in pg? I took a quick look at the 8.2 docs > and didn't find anything related. Any chance of going to 8.3? h

[ADMIN] UUID generation functions

2008-06-02 Thread Hyatt, Gordon
Sorry for the OT post, but does anyone know if there are any internal UUID generation functions in pg? I took a quick look at the 8.2 docs and didn't find anything related. I know I can spawn a call to the underlying system to get a UUID. The problem is that calling out to the system for this te