Re: [HACKERS] [pgsql-hackers-win32] Build with Visual Studio MSVC

2006-05-05 Thread Thomas Hallgren
Gurjeet Singh wrote: My main grudge is that if we are supporting almost all flovours of nixens and compilers (close to 34 according to official website), then why are we leaving Windows platform alone? This will bring in quite a lot more developers. You should look at MinGW as a development

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Magnus Hagander
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 minor

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Christopher Kings-Lynne
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

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Magnus Hagander
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

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Christopher Kings-Lynne
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

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Hiroshi Saito
- 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 for

Re: [HACKERS] Is a SERIAL column a black box, or not?

2006-05-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us 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

Re: [HACKERS] Altering view ownership doesn't work ...

2006-05-05 Thread Bruce Momjian
Agreed, RULE permissions seem to be of limited usefulness. --- Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: On Sun, Apr 30, 2006 at 12:34:42PM -0400, Tom Lane wrote: 2. Run setRuleCheckAsUser during

[HACKERS] Transactions per second

2006-05-05 Thread 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 a few more counters: Number of commits: Ideally, this would only count

Re: [HACKERS] [pgsql-hackers-win32] Build with Visual Studio MSVC

2006-05-05 Thread William ZHANG
`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

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio

2006-05-05 Thread Chuck McDevitt
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.

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Martijn van Oosterhout
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

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Magnus Hagander
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

[HACKERS] 8.1.3 and unused files

2006-05-05 Thread Rod Taylor
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

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio MSVC

2006-05-05 Thread Magnus Hagander
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

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Tom Lane
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 particularly

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Rod Taylor
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. I think

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Tom Lane
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

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Rod Taylor
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 up

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Tom Lane
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 gave it a

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Rod Taylor
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 thing I can

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Tom Lane
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

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Darcy Buskermolen
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() in the

Re: [HACKERS] Transactions per second

2006-05-05 Thread Hannu Krosing
Ü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 a

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio

2006-05-05 Thread Dave Page
-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.orgpgsql-hackers@postgresql.org, [EMAIL PROTECTED][EMAIL PROTECTED] Subject: Re: [pgsql-hackers-win32]

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Rod Taylor
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 does have

Re: [HACKERS] Transactions per second

2006-05-05 Thread Jim C. Nasby
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

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Tom Lane
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 striking

Re: [HACKERS] XLOG_BLCKSZ vs. wal_buffers table

2006-05-05 Thread Mark Wong
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

Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio

2006-05-05 Thread Chuck McDevitt
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

Re: [HACKERS] 8.1.3 and unused files

2006-05-05 Thread Rod Taylor
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 would have