Re: [HACKERS] Subversion repo up

2007-05-03 Thread Hannes Eder
main cvs repository? kind regards, Hannes Eder Footnotes: [1] http://subversion.tigris.org/svn_1.4_releasenotes.html#svnsync [2] http://projects.commandprompt.com/public/pgsql/repo/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Boatload of warnings in CVS HEAD :-(

2007-05-03 Thread Hannes Eder
Tome Lane wrote: > We can fix this for gcc by putting __attribute__((noreturn)) on the > declaration of pg_re_throw(), but what about other compilers? For MSVC 2005 use __declspec(noreturn) (see [1]). I think this also work for some older versions of MSVC. Regards, Hannes Eder Referenc

[HACKERS] msvc, build and install with cygwin in the PATH

2007-05-23 Thread Hannes Eder
With a small modification to src/tools/msvc/Install.pm (see attached patch) it's possible for me to build with msvc and install postgres on a Windows xp box and leave cygwin in the PATH. Since I use cygwin frequently it's usfull for me to have it in the PATH. This might not work on Win9x platf

Re: [HACKERS] msvc, build and install with cygwin in the PATH

2007-05-30 Thread Hannes Eder
Andrew Dunstan schrieb: Hannes Eder wrote: -open($D, "dir /b $subdirs $spec |") || croak "Could not list $spec\n"; +open($D, "cmd /c dir /b $subdirs $spec |") || croak "Could not list $spec\n"; What the heck are we doing here anyway? We shoul

Re: [HACKERS] msvc, build and install with cygwin in the PATH

2007-05-30 Thread Hannes Eder
Magnus Hagander schrieb: Are you actually *running* the script from inside cygwin? How else does it pick up the wrong command processor? I run the script within cmd.exe, but cygwin´s /usr/bin directory is in my PATH, therefor cygwin dir executable is in the PATH (/usr/bin/dir). Instead of ru

Re: [HACKERS] msvc, build and install with cygwin in the PATH

2007-06-06 Thread Hannes Eder
Magnus Hagander wrote: >Hannes Eder wrote: >> Is it worth doing this the "Perl-way" and using File::Find? If so, I can >> work an a patch for that. >> > It's certainly cleaner that way, but I don't find it a major issue. But I'd > rath

Re: [PATCHES] [HACKERS] msvc, build and install with cygwin in the PATH

2007-07-25 Thread Hannes Eder
Magnus Hagander schrieb: I used to have a different patch from Andrew that did part of this, and more, and conflicted rather badly with it. However, I never got around to applying that one, and I can't seem to find it anymore. Andrew -do you recall if you had all this in yours, and is it still s

Re: [HACKERS] MSVC build system

2007-09-14 Thread Hannes Eder
Andrew Dunstan wrote: I want to overhaul the MSVC build system somewhat and want to discuss my plans. [snip]. Apart from fixing the issue with using the systems "dir" command rather than using File::Find, which I will revisit, I think that's all I would do now, given how close we are to Bet

Re: [HACKERS] Debugger

2007-09-20 Thread Hannes Eder
Peter Eisentraut schrieb: Pedro Belmino wrote: I am with a problem. When I am using debugger, breakpoints that they are inside of main function (stop the execution in the marked point) but when breakpoint is marked in another archive (index.c for example) breakpoint does not function (the exe

[HACKERS] compiler warnings in ecpglib/execute.c (uninitialized local variable 'prepname' used)

2007-09-20 Thread Hannes Eder
while rebuilding pgsql with msvc 2005 I noticed this compiler warning: .\src\interfaces\ecpg\ecpglib\execute.c(1495): warning C4700: uninitialized local variable 'prepname' used ECPGfree(prepname) is called in line 1495, prepname was not unitialized befor. Below the line 1495 ECPGfree(prepname

[HACKERS] minor compiler warning in backend/utils/adt/tsrank.c

2007-09-20 Thread Hannes Eder
while rebuilding postgres with msvc 2005 I noticed some minor compiler warnings: .\src\backend\utils\adt\tsrank.c(24): warning C4305: 'initializing' : truncation from 'double' to 'float' .\src\backend\utils\adt\tsrank.c(24): warning C4305: 'initializing' : truncation from 'double' to 'float' .

Re: [PATCHES] [HACKERS] msvc, build and install with cygwin in the PATH

2007-09-23 Thread Hannes Eder
Magnus Hagander schrieb: Tom Lane wrote: Magnus Hagander <[EMAIL PROTECTED]> writes: Andrew Dunstan wrote: I have committed a fix that is somewhat similar to this. The Install.pm module needs some love, but that will have to wait till the next cycle. Thanks, Andrew!

[HACKERS] msvc >= VC7 understands __FUNCTION__

2007-09-28 Thread Hannes Eder
Hi, Starting from version VC7 msvc supports __FUNCTION__, so I think this could be enabled in pg_config.h.win32, see attached diff. -Hannes *** ../pgsql-cvshead/src/include/pg_config.h.win32 Mon Apr 16 20:39:19 2007 --- src/include/pg_config.h.win32 Fri Sep 28 22:32:50 2007 ***

[HACKERS] minor compiler warning in libpg/fe-secure.c on win32 (msvc)

2007-10-02 Thread Hannes Eder
Hi, while rebuilding the entire project I ran across following warning: .\src\interfaces\libpq\fe-secure.c(593): warning C4101: 'fp' : unreferenced local variable see attached diff for a fix. -Hannes *** ../pgsql-cvshead/src/interfaces/libpq/fe-secure.c Tue Oct 2 11:43:05 2007 --- src/inte

Re: [HACKERS] Latest ecpg patch broke MSVC build

2007-10-02 Thread Hannes Eder
Magnus Hagander schrieb: On Sun, Sep 30, 2007 at 11:30:35PM -0400, Andrew Dunstan wrote: Tom Lane wrote: This morning's ecpg patch certainly seems to have been snake-bit. Although the Windows gcc buildfarm members seem happy, the MSVC ones are all failing with Linking... Crea

Re: [HACKERS] Latest ecpg patch broke MSVC build

2007-10-03 Thread Hannes Eder
Magnus Hagander schrieb: Since this is an actual API library, perhaps a proper fix is to create a .def file listing the exports in it, the same way we do for libpq? And then we could (should!) also filter the exports the same ways as we do for libpq these days. (see the exports.txt file in libpq

[HACKERS] random dataset generator for SKYLINE operator

2007-10-11 Thread Hannes Eder
We wrote a little contrib module, which we'd like to share. It can be used to generate random datasets as they have been used in [Borzsonyi2001] and related work. The code is based directly on the code of the authors, thanks to Donald Kossmann for sharing the code. Donald Kossmann agrees on sharin

Re: [HACKERS] random dataset generator for SKYLINE operator

2007-10-17 Thread Hannes Eder
Hannes Eder worte: We wrote a little contrib module, which we'd like to share. It can be used to generate random datasets as they have been used in [Borzsonyi2001] and related work. [snip] The module was moved to: http://randdataset.projects.postgresql.org/ resp.

Re: [HACKERS] random dataset generator for SKYLINE operator

2007-11-21 Thread Hannes Eder
Hannes Eder worte: We wrote a little contrib module, which we'd like to share. It can be used to generate random datasets as they have been used in [Borzsonyi2001] and related work. [snip] We release a command line version of this module. See: http://randdataset.projects.postgresql.org/

Re: [HACKERS] WIP: Hash Join-Filter Pruning using Bloom Filters

2008-11-02 Thread Hannes Eder
On Sun, Nov 2, 2008 at 10:49 PM, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > Similarly, I > created a GUC to enable pruning, named bloom_pruning. I guess calls to bloom_filter_XXX should be surrounded by "if (bloom_pruning) ..." or a similar construct, i.e. make use of the GUC variable bloom_prun

Re: [HACKERS] Get Date value from Datum

2008-11-03 Thread Hannes Eder
On Tue, Nov 4, 2008 at 12:30 AM, imad <[EMAIL PROTECTED]> wrote: > What do you want to print? The integer value or the date string like > "29-01-2008". Use the date_out function to convert your value to date. > > --Imad > > On Tue, Nov 4, 2008 at 10:19 AM, Zhe He <[EMAIL PROTECTED]> wrote: >> Hi, >

Re: [HACKERS] Stack trace

2008-11-17 Thread Hannes Eder
On Mon, Nov 17, 2008 at 7:08 AM, Bramandia Ramadhana <[EMAIL PROTECTED]> wrote: > Hm the backtrace() method does not give the line numbers of the methods in > the stack trace, it only gives the hexadecimal offset. Is there anyway to > retrieve the line numbers? the binutil addr2line should do the

[HACKERS] WIP: The Skyline Operator

2008-12-02 Thread Hannes Eder
The skyline operator is a non-standard extension (even SQL:2008 does not include it). Queries of that type can be expressed in standard SQL (although a bit clumsy and the execution is slow). Others have also worked on extending PostgreSQL with the skyline operator, see: http://archives.postgresq