Re: [ADMIN] UUID generation functions
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 web-server and the DB server), so a solution that is independent of platform is the most desirable. I was hoping that PG would have something to generate UUIDs internally. It does. Read the above link. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] UUID generation functions
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 use most begin with uuid_generate. I can call these functions from within my own stored procs. Rommel the iCeMAn Barbados, Caribbean. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] UUID generation functions
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: pgsql-admin@postgresql.org Subject: Re: [ADMIN] UUID generation functions 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 comparison functions for UUIDs, but the core database does not include any function for generating UUIDs, because no single algorithm is well suited for every application. As far as I can see, there are really only 2 types, either time-based or random. I guess a third type could be one where 2 long integers are used to generate the UUID. Would this really add that much code? I haven't yet implemented such algorithms to know - I've simply used the underlying systems services when I needed UUIDs. For reasons mentioned by the other poster, it would be helpful if PostgreSQL could generate them. Is there really more than 2 or 3 needed options where it would be huge code bloat to include sufficient alternatives? 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 web-server and the DB server), so a solution that is independent of platform is the most desirable. I was hoping that PG would have something to generate UUIDs internally. If PG doesn't have the ability to generate UUIDs, I'll put the code in the web-server (tomcat) to do so. I was hoping to have this functionality as close as possible to the persistence of the data (where rules of uniqueness and integrity can be more easily enforced). Gord -- Milen A. Radev -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] UUID generation functions
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 tends to lock one into a specific O/S. In the case of Linux, uuidgen is _usually_ available for this; on Windows, however, a custom app to call a specific API would be necessary. The idea I had was to call this internal UUID generation function in an INSERT trigger to generate a unique, traceable that identifies a sample as it traverses numerous information systems/databases. Thanks in advance, Gord Hyatt -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
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 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? http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] UUID generation functions
Thanks Kevin, Not yet - the plan is to migrate later this year or early next year. There are a number of systems that will be upgraded at that time. Gord -Original Message- From: Kevin Grittner [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 3:19 PM To: Hyatt, Gordon; pgsql-admin@postgresql.org 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 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? http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin