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 m...@kitchenpc.com

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-25 Thread Dave Page
On Mon, Oct 25, 2010 at 1:12 PM, Michael Gould mgo...@intermodalsoftwaresolutions.net 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

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 t...@??? wrote: Mike Christensen m...@??? writes: On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@??? wrote: If you have a

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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-07 Thread Mike Christensen
On Wed, Oct 6, 2010 at 10:47 PM, Magnus Hagander mag...@hagander.net wrote: On Thu, Oct 7, 2010 at 05:09, Mike Christensen m...@kitchenpc.com wrote: On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 7:38 PM,

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 Dave Page
On Thu, Oct 7, 2010 at 3:56 AM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16 to that instead of carrying a separate

[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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Scott Marlowe
On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen m...@kitchenpc.com 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen m...@kitchenpc.com 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:27 PM, Mike Christensen m...@kitchenpc.com wrote: On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen m...@kitchenpc.com wrote: My production server is running Postgres 9.0 on Ubuntu Server, and

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen m...@kitchenpc.com 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane t...@sss.pgh.pa.us 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)

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane t...@sss.pgh.pa.us wrote: What does ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so say? # ldd

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen m...@kitchenpc.com 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com 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#

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 t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us wrote: So you don't have libuuid installed.  Go forth

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:15 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: However, libuuid.so.16 is still not found.. So have you got

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver adrian.kla...@gmail.com wrote: On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote: On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
 On Wed, Oct 6, 2010 at 7:24 PM, Mike Christensen m...@kitchenpc.com wrote: On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver adrian.kla...@gmail.com wrote: On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote: On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen m...@kitchenpc.com 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,

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Tom Lane
Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us 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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Mike Christensen
On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16 to that instead of carrying a separate

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-06 Thread Magnus Hagander
On Thu, Oct 7, 2010 at 05:09, Mike Christensen m...@kitchenpc.com wrote: On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: If you have a libossp-uuid.so.16, you might