Re: [GENERAL] Missing uuid_generate_v1()

2010-10-25 Thread Dave Page
On Mon, Oct 25, 2010 at 1:12 PM, Michael Gould wrote: > Is there a patch being worked on which will allow this contrib module to > work properly under Windows 64 bit machines using the 64 bit Postgres > server?  We need to be able to support both Windows and Linux servers > running Postgres. It's

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-25 Thread Michael Gould
Is there a patch being worked on which will allow this contrib module to work properly under Windows 64 bit machines using the 64 bit Postgres server? We need to be able to support both Windows and Linux servers running Postgres. Best Regards Michael Gould "Mike Christensen" wrote: > Oh, BTW,

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-22 Thread Mike Christensen
Oh, BTW, Tom - You were right about symlinking.. What I did totally hosed Apache (though it didn't crash until 2 days later, then wouldn't restart).. Apache then griped about libuuid not loading. I had to get my friend Brian (Linux guru) to SSH in and clean up the whole mess I made.. I think no

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-22 Thread Alexia Lau
Does anyone know where I can see what's already fixed at 9.0.2? Thanks, Alexia On 2010-10-07 09:54, Dave Page wrote: > On Thu, Oct 7, 2010 at 3:56 AM, Tom Lane wrote: > > Mike Christensen writes: > >> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote: > >>> If you have a libossp-uuid.so.16, you

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-07 Thread Dave Page
On Thu, Oct 7, 2010 at 3:56 AM, Tom Lane wrote: > Mike Christensen writes: >> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote: >>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16 >>> to that instead of carrying a separate file. > >> So now what you're saying is if it's no

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-07 Thread Peter Eisentraut
On ons, 2010-10-06 at 18:18 -0700, Mike Christensen wrote: > ERROR: could not load library > "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: > cannot open shared object file: No such file or directory > SQL state: 58P01 apt-get install libossp-uuid16 -- Sent via pgsql-general

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-07 Thread Mike Christensen
On Wed, Oct 6, 2010 at 10:47 PM, Magnus Hagander wrote: > On Thu, Oct 7, 2010 at 05:09, Mike Christensen wrote: >> On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane wrote: >>> Mike Christensen writes: On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote: > If you have a libossp-uuid.so.16, you might

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Magnus Hagander
On Thu, Oct 7, 2010 at 05:09, Mike Christensen wrote: > On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane wrote: >> Mike Christensen writes: >>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote: If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16 to that instead of carrying

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane wrote: > Mike Christensen writes: >> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote: >>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16 >>> to that instead of carrying a separate file. > >> So now what you're saying is if it's no

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen writes: > On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote: >> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16 >> to that instead of carrying a separate file. > So now what you're saying is if it's not broke, fix it till it is :) Well, it's hard to argue

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote: > Mike Christensen writes: >> Yup that's exactly what I did..  I'm on 10.04, which doesn't have >> libuuid 1.6 in the software repository, go figure.. > > Oh ... we're in package-naming hell, is where we are.  Poking around > some more on my Fedora

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen writes: > Yup that's exactly what I did.. I'm on 10.04, which doesn't have > libuuid 1.6 in the software repository, go figure.. Oh ... we're in package-naming hell, is where we are. Poking around some more on my Fedora 13 box, I find I have two different, similarly named packa

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
 On Wed, Oct 6, 2010 at 7:24 PM, Mike Christensen wrote: > On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver wrote: >> On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote: >>> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote: >>> > Mike Christensen writes: >>> >> On Wed, Oct 6, 2010 at 6:

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver wrote: > On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote: >> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote: >> > Mike Christensen writes: >> >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote: >> >>> So you don't have libuuid installe

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:15 PM, Tom Lane wrote: > Mike Christensen writes: >> On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane wrote: >>> Mike Christensen writes: However, libuuid.so.16 is still "not found".. >>> >>> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case >>> may b

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Adrian Klaver
On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote: > On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote: > > Mike Christensen writes: > >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote: > >>> So you don't have libuuid installed.  Go forth and get it ... > >> > >> What's the easiest way

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen writes: > On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane wrote: >> Mike Christensen writes: >>> However, libuuid.so.16 is still "not found".. >> >> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case >> may be)? > /usr/lib# ls -l libuuid* > -rw-r--r-- 1 root root

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane wrote: > Mike Christensen writes: >> However, libuuid.so.16 is still "not found".. > > So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case > may be)? > >                        regards, tom lane > /usr/lib# ls -l libuuid* -rw-r--r-- 1

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen writes: > However, libuuid.so.16 is still "not found".. So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case may be)? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote: > Mike Christensen writes: >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote: >>> So you don't have libuuid installed.  Go forth and get it ... > >> What's the easiest way to do that?  Is there a .bin file I can run? >> Or a URL I can wget?  Thanks

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen writes: > On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote: >> So you don't have libuuid installed.  Go forth and get it ... > What's the easiest way to do that? Is there a .bin file I can run? > Or a URL I can wget? Thanks! I'd expect it'd be available as a standard package fo

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote: > Mike Christensen writes: >> On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane wrote: >>> What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so" >>> say? > >> # ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so >>       linux-vdso.so.1 =>  (0x00

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen writes: > On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane wrote: >> What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so" >> say? > # ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so > linux-vdso.so.1 => (0x7fff5a5ff000) > libuuid.so.16 => not found >

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane wrote: > Mike Christensen writes: >> Oh btw, the file does actually exist..  Maybe it's missing some >> permission or something? > >> ls -l /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so >> -rwxr-xr-x 1 root daemon 12648 Oct  3 20:03 >> /opt/PostgreSQL/9.

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen writes: > Oh btw, the file does actually exist.. Maybe it's missing some > permission or something? > ls -l /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so > -rwxr-xr-x 1 root daemon 12648 Oct 3 20:03 > /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so What does "ldd /opt/Postgr

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:27 PM, Mike Christensen wrote: > On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe wrote: >> On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen wrote: >>> My production server is running Postgres 9.0 on Ubuntu Server, and I'm >>> getting some errors in sprocs that call uuid_ge

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe wrote: > On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen wrote: >> My production server is running Postgres 9.0 on Ubuntu Server, and I'm >> getting some errors in sprocs that call uuid_generate_v1()..  This is >> because the function is missing. >>

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Scott Marlowe
On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen wrote: > My production server is running Postgres 9.0 on Ubuntu Server, and I'm > getting some errors in sprocs that call uuid_generate_v1()..  This is > because the function is missing. > > On my Windows box, this function would automatically be in

[GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
My production server is running Postgres 9.0 on Ubuntu Server, and I'm getting some errors in sprocs that call uuid_generate_v1().. This is because the function is missing. On my Windows box, this function would automatically be installed as part of the database.. If I try to create the function