Re: [BUGS] BUG #3905: configure cannot find ossp UUID libs and/or includes

2008-01-28 Thread David E. Wheeler
On Jan 28, 2008, at 13:52, Tom Lane wrote: Hmph ... works for me on a reasonably stock OS X 10.5.1 machine. You did do "make" and "make install" in the contrib subtree, right? No. I assumed that that's what --with-ossp-uuid would do for me. But yeah, that does work: trigger# cd postgresql-

Re: [BUGS] BUG #3907: Deadlock while "vacuum verbose analyze" runs...

2008-01-28 Thread Tom Lane
"Martin Fandel" <[EMAIL PROTECTED]> writes: > on this weekend my database runs into a deadlock every time I run "vacuum > verbose analyze". What is the other process doing? regards, tom lane ---(end of broadcast)--- TIP 2: D

Re: [BUGS] BUG #3905: configure cannot find ossp UUID libs and/or includes

2008-01-28 Thread Tom Lane
"David E. Wheeler" <[EMAIL PROTECTED]> writes: > On Jan 28, 2008, at 10:08, Tom Lane wrote: >> Did you run the module's SQL script? > It was not put into /usr/local/pgsql/share/contrib. Neither of these > had any output: > trigger% ll /usr/local/pgsql/share/contrib/*.sql | grep uuid > trigger% l

[BUGS] BUG #3909: src\tools\msvc\clean.bat clears parse.h file

2008-01-28 Thread Pavel Golub
The following bug has been logged online: Bug reference: 3909 Logged by: Pavel Golub Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: WinXP Description:src\tools\msvc\clean.bat clears parse.h file Details: Executing clean.bat from src\to

Re: [BUGS] BUG #3905: configure cannot find ossp UUID libs and/or includes

2008-01-28 Thread David E. Wheeler
On Jan 28, 2008, at 10:08, Tom Lane wrote: david=# select uuid_generate_v1(); ERROR: function uuid_generate_v1() does not exist Did you run the module's SQL script? It was not put into /usr/local/pgsql/share/contrib. Neither of these had any output: trigger% ll /usr/local/pgsql/share/co

Re: [BUGS] BUG #3905: configure cannot find ossp UUID libs and/or includes

2008-01-28 Thread David E. Wheeler
On Jan 27, 2008, at 18:43, Tom Lane wrote: Oh, it finds it all right. It's just complaining (not incorrectly) that uuid.h fails when included after . AFAICT this is just cosmetic, since we don't use it that way. If you go ahead and build then everything should be fine. Hrm. It doesn't see

Re: [BUGS] BUG #3905: configure cannot find ossp UUID libs and/or includes

2008-01-28 Thread Tom Lane
"David E. Wheeler" <[EMAIL PROTECTED]> writes: > Hrm. It doesn't seem to have been installed: > david=# select uuid_generate_v1(); > ERROR: function uuid_generate_v1() does not exist Did you run the module's SQL script? regards, tom lane ---(end

[BUGS] BUG #3908: Error when loading pgsql service

2008-01-28 Thread MARCO A GONZALEZ
The following bug has been logged online: Bug reference: 3908 Logged by: MARCO A GONZALEZ Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: WIN XP SP2 Description:Error when loading pgsql service Details:

[BUGS] BUG #3907: Deadlock while "vacuum verbose analyze" runs...

2008-01-28 Thread Martin Fandel
The following bug has been logged online: Bug reference: 3907 Logged by: Martin Fandel Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Suse Linux Enterprise 10 Description:Deadlock while "vacuum verbose analyze" runs... Details: Hi, on

Re: [BUGS] BUG #3897: plJava dll still doesn't load for 8.3RC2

2008-01-28 Thread Dave Page
On Jan 28, 2008 9:33 AM, David JL Gradwell <[EMAIL PROTECTED]> wrote: > Hi Dave, > > Thanks for the help. I have now got pljava working fine on 8.3RC2 and have > re-run all my tests against RC2. On a database with a data structure of > 100+ tables and about 15 views with extensive (20+ per view)

Re: [BUGS] BUG #3897: plJava dll still doesn't load for 8.3RC2

2008-01-28 Thread David JL Gradwell
Hi Dave, Thanks for the help. I have now got pljava working fine on 8.3RC2 and have re-run all my tests against RC2. On a database with a data structure of 100+ tables and about 15 views with extensive (20+ per view) unions the performance is far better than 8.1 and better than 8.2.6, even on a

Re: [BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-28 Thread Peter Koczan
> I think you misunderstand what is happening. The parent postmaster > process is not restarting, because it did not crash. The crash is > happening in a child process that is forked off by the postmaster to > service a particular connection. I see what you're saying, that it's one particular co