Re: [HACKERS] Full GUID support

2011-08-18 Thread David E. Wheeler
On Jul 14, 2011, at 9:53 AM, David E. Wheeler wrote: (2011/07/14 3:49), Thomas Lotterer wrote: Thanks for the hint. Our ftp daemon is dumping core. We are debugging ... Ah, good news, thanks. Where should I report stuff like this in the future? I sent a message about this to

Re: [HACKERS] Full GUID support

2011-07-14 Thread Hiroshi Saito
Hi Thomas-san, Ralf-san. I appreciate your great work. Thanks! CC to Postgres-ML. Regards, Hiroshi Saito (2011/07/14 3:49), Thomas Lotterer wrote: Thanks for the hint. Our ftp daemon is dumping core. We are debugging ... -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Full GUID support

2011-07-14 Thread David E. Wheeler
On Jul 14, 2011, at 12:05 AM, Hiroshi Saito wrote: Hi Thomas-san, Ralf-san. I appreciate your great work. Thanks! CC to Postgres-ML. Regards, Hiroshi Saito (2011/07/14 3:49), Thomas Lotterer wrote: Thanks for the hint. Our ftp daemon is dumping core. We are debugging ... Ah,

Re: [HACKERS] Full GUID support

2011-07-13 Thread Hiroshi Saito
Um, Although I have not caught up with this thread. Ralf-san and the member of OSSP are maintaining OSSP continuously. I think that a reaction can merely be obtained in the intervals of when busy. Please do not need fast response. (2011/07/13 11:35), David E. Wheeler wrote: On Jul 12, 2011,

Re: [HACKERS] Full GUID support

2011-07-13 Thread David E. Wheeler
On Jul 13, 2011, at 6:44 AM, Hiroshi Saito wrote: Um, Although I have not caught up with this thread. Ralf-san and the member of OSSP are maintaining OSSP continuously. I think that a reaction can merely be obtained in the intervals of when busy. Please do not need fast response. I have

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/03/2011 11:54 AM, Peter Eisentraut wrote: On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote: I would like to request that full support for the UUID data type can added. I think that even though there is a contrib module, since this is a standard datatype that Postgres ought to be the

Re: [HACKERS] Full GUID support

2011-07-12 Thread Andrew Dunstan
On 07/12/2011 12:03 PM, Joshua D. Drake wrote: On 07/03/2011 11:54 AM, Peter Eisentraut wrote: On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote: I would like to request that full support for the UUID data type can added. I think that even though there is a contrib module, since this is

Re: [HACKERS] Full GUID support

2011-07-12 Thread Josh Berkus
Magnus, JD, UUID *is* in core. It's just the generation functions that aren't. No, it's not. It's in /contrib, which makes it an extension. Uh UUID/GUID is used pervasively throughout enterprise apps, especially Java apps. Oh, I guess I encounter it a lot less than you. Time for a

Re: [HACKERS] Full GUID support

2011-07-12 Thread Thom Brown
On 12 July 2011 19:24, Josh Berkus j...@agliodbs.com wrote: Magnus, JD, UUID *is* in core. It's just the generation functions that aren't. No, it's not.  It's in /contrib, which makes it an extension. The functions to produce UUIDs are in contrib, but the UUID data type itself is in core.

Re: [HACKERS] Full GUID support

2011-07-12 Thread Robert Haas
On Jul 12, 2011, at 1:24 PM, Josh Berkus j...@agliodbs.com wrote: Magnus, JD, UUID *is* in core. It's just the generation functions that aren't. No, it's not. It's in /contrib, which makes it an extension. Uh UUID/GUID is used pervasively throughout enterprise apps, especially Java

Re: [HACKERS] Full GUID support

2011-07-12 Thread Josh Berkus
Thom, The functions to produce UUIDs are in contrib, but the UUID data type itself is in core. You get the type uuid whether you install the contrib module or not. http://www.postgresql.org/docs/current/static/datatype-uuid.html Oh! I guess that shows you how much I use the type then.

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/12/2011 11:56 AM, Josh Berkus wrote: Thom, The functions to produce UUIDs are in contrib, but the UUID data type itself is in core. You get the type uuid whether you install the contrib module or not. http://www.postgresql.org/docs/current/static/datatype-uuid.html Oh! I guess that

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/12/2011 09:15 AM, Andrew Dunstan wrote: On 07/12/2011 12:03 PM, Joshua D. Drake wrote: On 07/03/2011 11:54 AM, Peter Eisentraut wrote: On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote: I would like to request that full support for the UUID data type can added. I think that even

Re: [HACKERS] Full GUID support

2011-07-12 Thread Andrew Dunstan
On 07/12/2011 03:44 PM, Joshua D. Drake wrote: What about extensions makes them less usable? It is an extra step, that is less usable. Does it matter? Shrug, I know I hate having to type apt-get just to use xyz, does it mean it is a big deal? Probably not. By that argument we wouldn't

Re: [HACKERS] Full GUID support

2011-07-12 Thread k...@rice.edu
On Tue, Jul 12, 2011 at 04:29:33PM -0400, Andrew Dunstan wrote: On 07/12/2011 03:44 PM, Joshua D. Drake wrote: What about extensions makes them less usable? It is an extra step, that is less usable. Does it matter? Shrug, I know I hate having to type apt-get just to use xyz, does it

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/12/2011 01:29 PM, Andrew Dunstan wrote: On 07/12/2011 03:44 PM, Joshua D. Drake wrote: What about extensions makes them less usable? It is an extra step, that is less usable. Does it matter? Shrug, I know I hate having to type apt-get just to use xyz, does it mean it is a big deal?

Re: [HACKERS] Full GUID support

2011-07-12 Thread David E. Wheeler
On Jul 12, 2011, at 1:40 PM, k...@rice.edu wrote: That is why I think having the UUID generators be a contrib module is the correct place for them to be, but the UUID type is better as a core function. I'm okay with this, though given the fact that ftp.ossp.org has been down for *months*,

Re: [HACKERS] Full GUID support

2011-07-12 Thread Josh Berkus
David, I'm okay with this, though given the fact that ftp.ossp.org has been down for *months*, I'm inclined to think that we ought to include it in the contrib distribution for easy linking. What license is it under? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent

Re: [HACKERS] Full GUID support

2011-07-12 Thread Tom Lane
David E. Wheeler da...@kineticode.com writes: On Jul 12, 2011, at 1:40 PM, k...@rice.edu wrote: That is why I think having the UUID generators be a contrib module is the correct place for them to be, but the UUID type is better as a core function. I'm okay with this, though given the fact

Re: [HACKERS] Full GUID support

2011-07-12 Thread David E. Wheeler
On Jul 12, 2011, at 5:07 PM, Tom Lane wrote: Curious considering that the machine is there (responds to ping), and the ossp.org webserver works fine. Has anyone bugged the owner about that? I've sent him email and Twitter DMs, to no avail. Best, David -- Sent via pgsql-hackers mailing

Re: [HACKERS] Full GUID support

2011-07-12 Thread David E . Wheeler
On Jul 12, 2011, at 5:06 PM, Josh Berkus wrote: I'm okay with this, though given the fact that ftp.ossp.org has been down for *months*, I'm inclined to think that we ought to include it in the contrib distribution for easy linking. What license is it under? COPYRIGHT AND LICENSE

Re: [HACKERS] Full GUID support

2011-07-11 Thread Magnus Hagander
On Sun, Jul 10, 2011 at 20:59, Josh Berkus j...@agliodbs.com wrote: On 7/3/11 2:02 PM, Tom Lane wrote: Yeah.  If there were One True Way to create a UUID, I would probably agree that we should push that functionality into core.  But there are a lot of ways (and the reason for that is that they

Re: [HACKERS] Full GUID support

2011-07-11 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Sun, Jul 10, 2011 at 20:59, Josh Berkus j...@agliodbs.com wrote: Also, I think that UUIDs fall into the class of datatypes used by less than 10% of users which should always remain extensions. I'd consider CITEXT for core before UUID. UUID *is*

Re: [HACKERS] Full GUID support

2011-07-11 Thread Peter Eisentraut
On mån, 2011-07-11 at 11:13 -0400, Tom Lane wrote: Magnus Hagander mag...@hagander.net writes: On Sun, Jul 10, 2011 at 20:59, Josh Berkus j...@agliodbs.com wrote: Also, I think that UUIDs fall into the class of datatypes used by less than 10% of users which should always remain extensions.

Re: [HACKERS] Full GUID support

2011-07-11 Thread Alvaro Herrera
Excerpts from Peter Eisentraut's message of lun jul 11 11:48:22 -0400 2011: That said, there have been several proposals over the years to move a few things out of the core into add-ons, and now that extension support exists, we could potentially reopen that discussion. Surely we ought to

Re: [HACKERS] Full GUID support

2011-07-11 Thread Joshua D. Drake
On 07/10/2011 11:59 AM, Josh Berkus wrote: On 7/3/11 2:02 PM, Tom Lane wrote: Yeah. If there were One True Way to create a UUID, I would probably agree that we should push that functionality into core. But there are a lot of ways (and the reason for that is that they all suck in one fashion

Re: [HACKERS] Full GUID support

2011-07-11 Thread Patrick Earl
I'd have to agree on the importance of UUID support. It's pretty much essential for any sort of disconnected sync model. We use UUIDs (generated with the guid.comb technique) for our surrogate keys in around 50 apps, and it has served us well. We have also been seriously missing the 64-bit

Re: [HACKERS] Full GUID support

2011-07-10 Thread Josh Berkus
On 7/3/11 2:02 PM, Tom Lane wrote: Yeah. If there were One True Way to create a UUID, I would probably agree that we should push that functionality into core. But there are a lot of ways (and the reason for that is that they all suck in one fashion or another :-(). Between that and the lack

Re: [HACKERS] Full GUID support

2011-07-08 Thread Peter Eisentraut
On sön, 2011-07-03 at 17:02 -0400, Tom Lane wrote: Yeah. If there were One True Way to create a UUID, I would probably agree that we should push that functionality into core. But there are a lot of ways (and the reason for that is that they all suck in one fashion or another :-(). Between

Re: [HACKERS] Full GUID support

2011-07-04 Thread Dave Page
Should be in 9.0.5/9.1b3 On Sunday, July 3, 2011, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: gt; Does this look to be something that will surface around for 9.1 gt; gt; Sent from Samsung mobile gt; gt; Dave Page lt;dp...@pgadmin.orggt; wrote: gt; gt;gt;On Sunday, July 3, 2011,

Re: [HACKERS] Full GUID support

2011-07-04 Thread Michael Gould
Dave, This is wonderful news. Best Regards Michael Gould Dave Page dp...@pgadmin.org wrote: Should be in 9.0.5/9.1b3 On Sunday, July 3, 2011, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: Does this look to be something that will surface around for 9.1 Sent from

Re: [HACKERS] Full GUID support

2011-07-03 Thread Peter Eisentraut
On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote: I would like to request that full support for the UUID data type can added. I think that even though there is a contrib module, since this is a standard datatype that Postgres ought to be the one actually assigning the value. What

Re: [HACKERS] Full GUID support

2011-07-03 Thread Michael Gould
Peter, I don't believe that the library that the contrib module runs with can run on Window 64 bit servers or even Windows 7 64 bit. That is problem as most shops are using 64 bit OS and if Window the contrib module is going to fail. Taking the responsibility to handle this internally means

Re: [HACKERS] Full GUID support

2011-07-03 Thread Dave Page
On Sunday, July 3, 2011, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: gt; Peter, gt; gt; I don't believe that the library that the contrib module runs with can run gt; on Window 64 bit servers or even Windows 7 64 bit.  That is problem as most gt; shops are using 64 bit OS and if

Re: [HACKERS] Full GUID support

2011-07-03 Thread Tom Lane
Dave Page dp...@pgadmin.org writes: Even If that weren't the case, integrating the type wouldn't fix the problem anyway, unless you're suggesting we implement our own UUID generator (which isn't nearly as straightforward as it might seem, as I understand it).. Yeah. If there were One True

Re: [HACKERS] Full GUID support

2011-07-03 Thread Michael Gould
Does this look to be something that will surface around for 9.1 Sent from Samsung mobile Dave Page dp...@pgadmin.org wrote: On Sunday, July 3, 2011, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: gt; Peter, gt; gt; I don't believe that the library that the contrib module runs with