> 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
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
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)
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
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:
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
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
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
"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
"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
"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
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-
12 matches
Mail list logo