On Fri, 2006-05-05 at 18:53 -0400, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > On Fri, 2006-05-05 at 16:11 -0400, Tom Lane wrote:
> >> Hm. I wonder if there are any uses of "exit(1)" in the Slony triggers.
>
> > It doesn't appear so. It does have this though:
>
> Well, a SIGTERM
Statically link the c library, and your problem is solved.
Or ship the dll with the installer, like any normal commercial
application would. Microsoft specifically grants the right to do this.
There is no other "runtime" besides the c library.
Either approach is simple, and doesn't tie us to an
On Tue, 02 May 2006 10:52:38 +0100
Simon Riggs <[EMAIL PROTECTED]> wrote:
> On Sun, 2006-04-30 at 22:14 -0700, Mark Wong wrote:
> > I would have gotten this out sooner but I'm having trouble with our
> > infrastructure. Here's a link to a table of data I've started putting
> > together regarding
Rod Taylor <[EMAIL PROTECTED]> writes:
> On Fri, 2006-05-05 at 16:11 -0400, Tom Lane wrote:
>> Hm. I wonder if there are any uses of "exit(1)" in the Slony triggers.
> It doesn't appear so. It does have this though:
Well, a SIGTERM would have resulted in a bleat in the postmaster log.
The striki
On Sat, May 06, 2006 at 12:09:45AM +0300, Hannu Krosing wrote:
> ??hel kenal p??eval, N, 2006-05-04 kell 17:23, kirjutas Jim Nasby:
> > I often find myself wanting to know how many transactions per second
> > a database is committing to disk, as well as how many queries per
> > second it's proc
On Fri, 2006-05-05 at 16:11 -0400, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > % 1960 2006-05-02 17:03:19 EDTLOG: 0: server process (PID 10171)
> > exited with exit code 1
>
> Hm. I wonder if there are any uses of "exit(1)" in the Slony triggers.
It doesn't appear so. It
-Original Message-
From: "Chuck McDevitt"<[EMAIL PROTECTED]>
Sent: 05/05/06 18:01:49
To: "Magnus Hagander"<[EMAIL PROTECTED]>, "Gurjeet Singh"<[EMAIL PROTECTED]>,
"pgsql-hackers@postgresql.org", "[EMAIL
PROTECTED]"<[EMAIL PROTECTED]>
Subject: Re: [pgsql-hackers-win32] [HACKERS] Build wi
Ühel kenal päeval, N, 2006-05-04 kell 17:23, kirjutas Jim Nasby:
> I often find myself wanting to know how many transactions per second
> a database is committing to disk, as well as how many queries per
> second it's processing. While Larry's busy making stats changes, I'd
> like to propose
On Friday 05 May 2006 13:11, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > % 1960 2006-05-02 17:03:19 EDTLOG: 0: server process (PID 10171)
> > exited with exit code 1
>
> Hm. I wonder if there are any uses of "exit(1)" in the Slony triggers.
No, there are no calls to exit()
Rod Taylor <[EMAIL PROTECTED]> writes:
> % 1960 2006-05-02 17:03:19 EDTLOG: 0: server process (PID 10171) exited
> with exit code 1
Hm. I wonder if there are any uses of "exit(1)" in the Slony triggers.
regards, tom lane
---(end of broadcas
On Fri, 2006-05-05 at 15:10 -0400, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > On Fri, 2006-05-05 at 14:31 -0400, Tom Lane wrote:
> >> Unless you had an actual backend crash, that's not an adequate
> >> explanation. Transaction abort does clean up created files.
>
> > The only th
Rod Taylor <[EMAIL PROTECTED]> writes:
> On Fri, 2006-05-05 at 14:31 -0400, Tom Lane wrote:
>> Unless you had an actual backend crash, that's not an adequate
>> explanation. Transaction abort does clean up created files.
> The only thing I can come up with is that perhaps someone forcefully
> gav
On Fri, 2006-05-05 at 14:31 -0400, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > At some point it must have failed in copying the data across, aborted,
> > and restarted.
>
> Unless you had an actual backend crash, that's not an adequate
> explanation. Transaction abort does clean
Rod Taylor <[EMAIL PROTECTED]> writes:
> At some point it must have failed in copying the data across, aborted,
> and restarted.
Unless you had an actual backend crash, that's not an adequate
explanation. Transaction abort does clean up created files.
regards, tom lane
-
On Fri, 2006-05-05 at 14:09 -0400, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > Am I correct in the thought that the various files listed below are not
> > used by the database and can be safely removed? There were no other
> > active db connections when I issued this command.
>
>
Rod Taylor <[EMAIL PROTECTED]> writes:
> Am I correct in the thought that the various files listed below are not
> used by the database and can be safely removed? There were no other
> active db connections when I issued this command.
> I think truncate (Slony) left them behind.
I don't particula
> VC++6.0 isn't a very good compiler and it's not very compatible with
> gcc, while Visual Studio 2005 compiler is much more
> compatible and has a better optimizer.
>
> Plus, VC++6.0 had a closed "proprietary" data format for .dsp
> and .dsw files, while the current Visual Studio uses a
> stan
Am I correct in the thought that the various files listed below are not
used by the database and can be safely removed? There were no other
active db connections when I issued this command.
I think truncate (Slony) left them behind.
ssdb=# select file
from pg_ls_dir('base/'|| (select oid
> > You mean they have a tool that parses GNU Makefiles and generate VC
> > project files? Sure, that might be interesting. I've seen I
> think two
> > others, and tried, but they fell over badly because the pg build
> > system was too complicated. But I beleive I'm still allowed
> to loko at
On Fri, May 05, 2006 at 09:50:38AM +0200, Magnus Hagander wrote:
> You mean they have a tool that parses GNU Makefiles and generate VC
> project files? Sure, that might be interesting. I've seen I think two
> others, and tried, but they fell over badly because the pg build system
> was too complica
VC++6.0 isn't a very good compiler and it's not very compatible with
gcc, while Visual Studio 2005 compiler is much more compatible and has a
better optimizer.
Plus, VC++6.0 had a closed "proprietary" data format for .dsp and .dsw
files, while the current Visual Studio uses a standard XML format.
`vcproject` is based on pgsql-8.0.3. It's purpose is to make pgsql built
with MSVC++.
But I found there are few people intrested on it, so I stopped maintaining
it months
ago. `vcproject` still need MSYS/MinGW, the basic idea behind it is:
1) Let we do configure, make, make install in MinGW first.
I often find myself wanting to know how many transactions per second
a database is committing to disk, as well as how many queries per
second it's processing. While Larry's busy making stats changes, I'd
like to propose a few more counters:
Number of commits: Ideally, this would only count
Agreed, RULE permissions seem to be of limited usefulness.
---
Tom Lane wrote:
> Martijn van Oosterhout writes:
> > On Sun, Apr 30, 2006 at 12:34:42PM -0400, Tom Lane wrote:
> >> 2. Run setRuleCheckAsUser during rule load r
Tom Lane wrote:
> Bruce Momjian writes:
> > My idea is to create a new SECURITY DEFINER function called
> > serial_nextval(), and use that for SERIAL defaults.
>
> You haven't thought about this at all. Who will own that function?
> Surely we don't want to create a new one for every SERIAL colum
- Original Message -
From: "Magnus Hagander"
> The target is VC++ 2003 and 2005 ATM, but it should just be a matter of
> a different output format for VC 6.0 I guess.
>
> You will still need things like bison and flex if you want to build off
> cvs, of course - there is no builtin support
You mean they have a tool that parses GNU Makefiles and generate VC
project files? Sure, that might be interesting. I've seen I think two
others, and tried, but they fell over badly because the pg build system
was too complicated. But I beleive I'm still allowed to loko at GPL
stuff and get ideas
> > Yes. There is a patch pending on -patches which fix almost all of
> > these in HEAD. (There are a few tiny things related to perl and NLS
> > that aren't included in it ATM. And I'm just assuming you're seeing
> > the same problems as I was but I didn't base my work off
> vcproject).
> > I
Yes. There is a patch pending on -patches which fix almost all of these
in HEAD. (There are a few tiny things related to perl and NLS that
aren't included in it ATM. And I'm just assuming you're seeing the same
problems as I was but I didn't base my work off vcproject). I'm also
working on a build
> Hi William(uniware), Chuck and Hackers,
>
> I have been interested in doing complete PGSQL
> development in MSVC for a long time now. With reference to
> one of Chuck's mails to
> -hackers-win32 with the same subject, you said that you were
> able to successfully compile PG 8.1 with some
30 matches
Mail list logo
