[HACKERS] [PATCH] OpenSSL 1.1.0 support

2016-09-01 Thread Kurt Roeckx
Hi, Attached is a patch to make it build with OpenSSL 1.1.0. There is probably a minor problem on windows where the name of the dlls got changed. Someone probably should look into that. Kurt >From efd7aa3499b2b4eedd4c4d4164b75175f3c10d2f Mon Sep 17 00:00:00 2001 From: Kurt Roeckx Date:

Re: [HACKERS] Gcc 4.4 causes abort in plpython.

2008-12-29 Thread Kurt Roeckx
On Mon, Dec 29, 2008 at 11:19:56AM -0500, Tom Lane wrote: > Kurt Roeckx writes: > > On Mon, Dec 29, 2008 at 09:25:47AM -0300, Alvaro Herrera wrote: > >> I think a simplistic solution is to declare the variable volatile. > >> Would you test that and report back? &g

Re: [HACKERS] Gcc 4.4 causes abort in plpython.

2008-12-29 Thread Kurt Roeckx
On Mon, Dec 29, 2008 at 09:25:47AM -0300, Alvaro Herrera wrote: > > I think a simplistic solution is to declare the variable volatile. > Would you test that and report back? Yes, making oldcontext volatile makes the test pass. It now fails at the ECPG-Check stage, but it seems that is a common p

[HACKERS] Gcc 4.4 causes abort in plpython.

2008-12-26 Thread Kurt Roeckx
Hi, I've been trying a gcc 4.4 snapshot (20081213) on buildfarm member panda. It gets a abort during the pl-install-check part. Here is the backtrace: Core was generated by `postgres: build-farm pl_regression [local] SELECT '. Program terminated with signal 6, Aborted. [New process 3588] #0 0x0

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-26 Thread Kurt Roeckx
On Tue, Mar 25, 2008 at 06:03:39PM -0400, Andrew Dunstan wrote: >> >> Patches committed, please re-enable the back branches so we can >> see what happens. > > I have tested this back as far as 8.0, and all seems OK. 7.4 passed too. Kurt -- Sent via pgsql-hackers mailing list (pgsql-hackers@po

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-25 Thread Kurt Roeckx
On Tue, Mar 25, 2008 at 02:11:30PM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > On Mon, Mar 24, 2008 at 05:59:33PM -0400, Tom Lane wrote: > >> http://archives.postgresql.org/pgsql-committers/2007-03/msg00292.php > > > This patch atl

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-25 Thread Kurt Roeckx
On Mon, Mar 24, 2008 at 05:59:33PM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > I did try the patch. It fails just the same way. > > Hmph. So we still don't know why 8.2 and 8.3 behave differently ... > [ pokes around ... ] Hah

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-24 Thread Kurt Roeckx
On Mon, Mar 24, 2008 at 05:59:33PM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > I did try the patch. It fails just the same way. > > Hmph. So we still don't know why 8.2 and 8.3 behave differently ... > [ pokes around ... ] Hah

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-24 Thread Kurt Roeckx
On Mon, Mar 24, 2008 at 03:52:09PM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > On Mon, Mar 24, 2008 at 02:52:18PM -0400, Tom Lane wrote: > >> Please try that patch and see what it fixes pre-8.3. > > > No, returnValue contains the same valu

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-24 Thread Kurt Roeckx
On Mon, Mar 24, 2008 at 02:52:18PM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > 8.2 and 8.3 actually get the same value in fmgr_oldstyle(), it just > > seems they do something else with it somewhere else. > > Doh. I'll bet the d

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-24 Thread Kurt Roeckx
On Mon, Mar 24, 2008 at 03:05:31PM -0300, Alvaro Herrera wrote: > Kurt Roeckx wrote: > > > No, this has nothing to do with CFLAGS. It's calling a function which > > returns something other than it actually returns. > > Yeah but apparently gcc 4.3 is working in 8.3

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-24 Thread Kurt Roeckx
On Mon, Mar 24, 2008 at 02:05:14PM -0300, Alvaro Herrera wrote: > Kurt Roeckx wrote: > > On Thu, Mar 20, 2008 at 06:53:27PM -0400, Tom Lane wrote: > > > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > > > I did some tests with gcc 4.3 on the branches from 7.4 t

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-24 Thread Kurt Roeckx
On Thu, Mar 20, 2008 at 06:53:27PM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > I did some tests with gcc 4.3 on the branches from 7.4 to 8.3 and head. > > 8.3 and head don't have a problem. All others failed in the > > ContribCheck state. &

Re: [HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-23 Thread Kurt Roeckx
On Thu, Mar 20, 2008 at 06:53:27PM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > I did some tests with gcc 4.3 on the branches from 7.4 to 8.3 and head. > > 8.3 and head don't have a problem. All others failed in the > > ContribCheck state. &

[HACKERS] gcc 4.3 breaks ContribCheck in 8.2 and older.

2008-03-20 Thread Kurt Roeckx
Hi, I did some tests with gcc 4.3 on the branches from 7.4 to 8.3 and head. 8.3 and head don't have a problem. All others failed in the ContribCheck state. You can see the results on buildfarm member panda. Kurt -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make c

Re: [HACKERS] Re: [COMMITTERS] pgsql: Don't need -Wno-error anymore, because flex is no longer

2008-03-19 Thread Kurt Roeckx
On Tue, Mar 18, 2008 at 07:23:40PM +0100, Peter Eisentraut wrote: > Am Dienstag, 18. März 2008 schrieb Bruce Momjian: > > Peter Eisentraut wrote: > > > Log Message: > > > --- > > > Don't need -Wno-error anymore, because flex is no longer producing > > > warnings. > > > > I see this patch on

[HACKERS] SHM_HUGETLB on Linux 2.6.

2008-01-19 Thread Kurt Roeckx
Hi, Has anyone tried to use the huge tlb support of the Linux 2.6 kernel? If you compile the kernel with support for it (CONFIG_HUGETLBFS), you can call shmget() with a SHM_HUGETLB parameter so that it will use larger pages. Has anyone tried to use it? Is it worth trying to set it up? Kurt -

Re: [HACKERS] Spoofing as the postmaster

2007-12-23 Thread Kurt Roeckx
On Sun, Dec 23, 2007 at 02:52:28PM -0500, Tom Lane wrote: > Gregory Stark <[EMAIL PROTECTED]> writes: > > Bruce summarized the problem pretty well when he said that if Postgres > > is being run as a non-root user then one non-root user's "postgres" is > > as good as any other non-root user's "postg

Re: [HACKERS] [SUGGESTION] CVSync

2006-03-23 Thread Kurt Roeckx
On Thu, Mar 23, 2006 at 01:32:34PM -0800, Joel Miller wrote: > Hello, > > I've been trying to get a local mirror of the cvs repository, but my > connection attempts using rsync to cvsup.postgresql.org are always > refused when I try to actually retrieve the pgsql-cvs collection. I tried > to use r

Re: [HACKERS] Fw: Is anyone interested in getting PostgreSQL working

2006-01-09 Thread Kurt Roeckx
On Mon, Jan 09, 2006 at 03:03:28PM +0100, Stefan Kaltenbrunner wrote: > > > >well that is good news, can you tell me what version of linux you are > >using and what gcc version also. I will let > >Martin know. > > > lionfish is a stock Debian/Sarge box (a cobalt cube) with gcc 3.3.5. Martin is

Re: [HACKERS] *printf and zero size

2005-12-05 Thread Kurt Roeckx
On Mon, Dec 05, 2005 at 04:35:31PM -0500, Bruce Momjian wrote: > > but it seems this is some BSD'ism that we don't need to support if the > standard doesn't say so. I think the Linux manpage is more informative about this: The functions snprintf and vsnprintf do not write more than

Re: [HACKERS] -fPIC

2005-09-12 Thread Kurt Roeckx
On Mon, Sep 12, 2005 at 09:06:03AM +0200, Martijn van Oosterhout wrote: > > The new gcc visibility stuff gives you way of shrinking the symbol > table and improving performance. And you really should start with making use of static, which has about the same effect, except that the visibility stuf

Re: [HACKERS] Spinlocks, yet again: analysis and proposed patches

2005-09-11 Thread Kurt Roeckx
On Sun, Sep 11, 2005 at 05:59:49PM -0400, Tom Lane wrote: > > I kinda suspect that the cmpb test is a no-op or loss on all > Intelish processors: it can only be a win if you expect a lot > of contention for the spin lock, but in percentage terms we still > have a very low conflict rate, so in most

Re: [HACKERS] -fPIC

2005-09-11 Thread Kurt Roeckx
On Sun, Sep 11, 2005 at 05:49:40PM +0200, Peter Eisentraut wrote: > So far, we have tended to use -fpic to compile position-independent code > until we have received some sort of overflow that forced the use of > -fPIC. Since 8.0, the makefiles to build shared libraries are also > available to

Re: [HACKERS] Bumping libpq version number?

2005-03-13 Thread Kurt Roeckx
On Fri, Mar 11, 2005 at 12:58:28PM -0500, Bruce Momjian wrote: > Are we still bumping the libpq major version number for 8.0.2? I think > it is a bad idea because we will require too many client apps to be > recompiled, and we have had few problem reports. > > We do need to bump the major version

Re: [HACKERS] Bumping libpq version number?

2005-03-13 Thread Kurt Roeckx
On Fri, Mar 11, 2005 at 01:29:46PM -0500, Bruce Momjian wrote: > Kurt Roeckx wrote: > > > > Does initdb call pg_snprintf directly? Or does it call some > > libpq function that calls it? > > With the current CVS, initdb calls pg_snprintf() on my platform which > doe

Re: [HACKERS] Bumping libpq version number?

2005-03-13 Thread Kurt Roeckx
On Fri, Mar 11, 2005 at 04:49:23PM -0500, Bruce Momjian wrote: > > In fact, based on the few complaints we have heard about the current > situation, I am sure we are going to get many more complaints if we bump > up the major version in 8.0.2. I think it's better to have people complain that they

Re: [HACKERS] date_trunc problem in HEAD

2005-03-13 Thread Kurt Roeckx
On Sun, Mar 13, 2005 at 12:48:00PM -0700, Robert Creager wrote: > When grilled further on (Sun, 13 Mar 2005 19:40:02 +0100), > Kurt Roeckx <[EMAIL PROTECTED]> confessed: > > > > Attached is a patch against HEAD for your review. > >

Re: [HACKERS] date_trunc problem in HEAD

2005-03-13 Thread Kurt Roeckx
On Sun, Mar 13, 2005 at 11:12:32AM -0700, Robert Creager wrote: > > Hey All, > > I goofed with the patch I submitted last year for adding 'week' capability to > the date_trunc function. > > Attached is a patch against HEAD for your review. It has this comment in it:

Re: [HACKERS] [PATCHES] [pgsql-hackers-win32] Repleacement for src/port/snprintf.c

2005-02-22 Thread Kurt Roeckx
On Mon, Feb 21, 2005 at 10:53:08PM -0500, Bruce Momjian wrote: > > Applied. The configure test is a little broken. It needs to quote the $'s. I've rewritten the test a little. Kurt Index: config/c-library.m4 === RCS file: /proje

Re: [HACKERS] segfault caused by heimdal (was: SUSE port)

2005-01-12 Thread Kurt Roeckx
On Wed, Jan 12, 2005 at 07:36:52PM +0100, Reinhard Max wrote: > > The problem is, that the heimdal implementation of kerberos5 used on > sles8 needs an extra include statement for com_err.h in > src/interfaces/libpq/fe-auth.c to get the prototype for > error_message(), while on newer SUSE-relea

Re: [HACKERS] race condition for drop schema cascade?

2004-12-29 Thread Kurt Roeckx
> pgbuildfarm=# select name, operating_system, stage, count from buildsystems > b, (select sysname, stage, count(*) as count from build_status where log ~ > 'tablespace "testspace" is not empty' group by sysname, stage) as s where > s.sysname=b.name; Note that the expected log has that as error

Re: [HACKERS] Need access to a Linux box

2004-12-05 Thread Kurt Roeckx
On Sun, Dec 05, 2004 at 08:21:36PM +0100, Thomas Hallgren wrote: > I'm in process of releasing a PL/Java based on the latest 8.0.0rc1. My > Linux box is x86_64 based and even if I can cross-compile a 32 bit > binary on it, I feel it's not really the same thing. Normally I use the > "testdrive" o

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-04 Thread Kurt Roeckx
On Fri, Dec 03, 2004 at 09:37:42PM +0100, Peter Eisentraut wrote: > > Once RC1 is out and the build farm has picked it up, we should start > filling out our little table with the build farm results and then look > for ways to fill the holes. Does the build farm turn on all the > compiler optio

Re: [HACKERS] Postgres performs a Seq Scan instead of an Index Scan!

2004-10-26 Thread Kurt Roeckx
On Tue, Oct 26, 2004 at 06:12:36PM +0200, Jos van Roosmalen wrote: > > CREATE TABLE TESTTABLE (ATTR1 INT8,ATTR2 INT4,ATTR3 TIMESTAMP); > CREATE UNIQUE INDEX TESTINDEX ON TESTTABLE(ATTR1,ATTR2,ATTR3); > EXPLAIN SELECT * FROM TESTTABLE WHERE ATTR1=1 AND ATTR2=2 AND > ATTR3='2004-01-01'; try: expl

Re: [HACKERS] 7.5 beta version

2004-04-13 Thread Kurt Roeckx
On Mon, Apr 12, 2004 at 10:00:05PM +0200, Jeroen T. Vermeulen wrote: > On Mon, Apr 12, 2004 at 12:35:15PM -0700, Dann Corbit wrote: > > > I do know of important differences in compilers in this regard. You can > > (for instance) have 80 bit floating point on one compiler using double > > but it

Re: [HACKERS] fsync method checking

2004-03-18 Thread Kurt Roeckx
On Thu, Mar 18, 2004 at 03:34:21PM -0500, Bruce Momjian wrote: > Kurt Roeckx wrote: > > Here are my results on Linux 2.6.1 using cvs version 1.7. > > > > Those times with > 20 seconds, you really hear the disk go crazy. > > > > And I have the feeling som

Re: [HACKERS] fsync method checking

2004-03-18 Thread Kurt Roeckx
Here are my results on Linux 2.6.1 using cvs version 1.7. Those times with > 20 seconds, you really hear the disk go crazy. And I have the feeling something must be wrong. Those results are reproducible. Kurt Simple write timing: write0.139558 Compare fsync times

Re: [HACKERS] fsync method checking

2004-03-18 Thread Kurt Roeckx
On Thu, Mar 18, 2004 at 02:22:10PM -0500, Bruce Momjian wrote: > > OK, what better test do you suggest? Right now, there has been no > testing of these. I suggest you start by doing atleast preallocating a 16 MB file and do the tests on that, to atleast be somewhat simular to what WAL does. I h

Re: [HACKERS] fsync method checking

2004-03-18 Thread Kurt Roeckx
On Thu, Mar 18, 2004 at 01:50:32PM -0500, Bruce Momjian wrote: > > I'm not sure I believe these numbers at all... my experience is that > > getting trustworthy disk I/O numbers is *not* easy. > > These numbers were reproducable on all the platforms I tested. It's not because they are reproducable

Re: [HACKERS] socket calls in signal handler (WAS: APC + socket restrictions un der Win32?)

2004-03-08 Thread Kurt Roeckx
On Mon, Mar 08, 2004 at 11:33:17PM +0100, Magnus Hagander wrote: > > >The postmaster's use of nominally unsafe stuff in signal > >handlers is not > >and never has been a problem, because there is only one place in the > >main loop where signals are unblocked, thus no possibility for > >something

Re: [HACKERS] socket calls in signal handler (WAS: APC + socket restrictions un der Win32?)

2004-03-08 Thread Kurt Roeckx
On Mon, Mar 08, 2004 at 09:12:52PM +1100, Claudio Natoli wrote: > > Hi all, > > Was just discussing the issues related to the above off list with Magnus: > http://archives.postgresql.org/pgsql-hackers-win32/2004-03/msg00041.php > > Whilst we can think of a number of work-arounds (the simplest be

Re: [HACKERS] Pre-1970 dates under Win32

2004-02-02 Thread Kurt Roeckx
On Mon, Feb 02, 2004 at 01:57:15AM -0500, Tom Lane wrote: > Claudio Natoli <[EMAIL PROTECTED]> writes: > > Under Win32, localtime returns NULL for dates pre 1970. > > Count on Microsloth to get it wrong :-( I had a discussion about time_t some weeks ago. There is nothing in the standard that say

Re: [HACKERS] feature request... case sensitivity without double quotes

2004-01-18 Thread Kurt Roeckx
On Thu, Jan 15, 2004 at 10:02:34PM -0500, Pete wrote: > Hi, > > I'm not sure if this is the correct place to make a feature request. If > not hopefully I can be kindly pointed in that direction. > > I have several project that use MySQL and I would like to port them to > PostgreSQL unfortunatel

Re: [HACKERS] RFC: bufmgr locking changes

2004-01-07 Thread Kurt Roeckx
On Wed, Jan 07, 2004 at 05:37:09PM -0500, Neil Conway wrote: > > - if a backend holds the BufMgrLock, it will never try to > LWLockAcquire() a per-buffer meta data lock, due to the risk of > deadlock (and the loss in concurrency if we got blocked waiting > while still holding

Re: [HACKERS] Brokenness in parsing of pg_hba.conf

2004-01-07 Thread Kurt Roeckx
On Wed, Jan 07, 2004 at 01:58:54PM -0500, Andrew Dunstan wrote: > Kurt Roeckx wrote: > > >[IP6] [Option Start] If the specified address family is AF_INET6 or > >AF_UNSPEC, standard IPv6 text forms described in inet_ntop() are > >valid. [Option End]

Re: [HACKERS] Brokenness in parsing of pg_hba.conf

2004-01-07 Thread Kurt Roeckx
On Wed, Jan 07, 2004 at 01:58:54PM -0500, Andrew Dunstan wrote: > > I read it to mean that abbreviated forms (via inet_addr()) are OK for > AF_INET but not for AF_INET6 (via inet_pton()) > But we use AF_UNSPEC/PF_UNSPEC. Kurt ---(end of broadcast)

Re: [HACKERS] Brokenness in parsing of pg_hba.conf

2004-01-07 Thread Kurt Roeckx
On Wed, Jan 07, 2004 at 12:53:19PM -0500, Bruce Momjian wrote: > Greg Stark wrote: > > a.b.c > > > > When a three-part address is specified, the last part shall be interpreted > > as a 16-bit quantity and placed in the rightmost two bytes of the network > > address. This make

Re: [HACKERS] Brokenness in parsing of pg_hba.conf

2004-01-07 Thread Kurt Roeckx
On Tue, Jan 06, 2004 at 10:52:19PM -0500, Andrew Dunstan wrote: > > A few points. > > 1. clarification of my IRC comment: A quick examination seems to shaw > that we use the native getaddrinfo() where it exists, otherwise we use > our own, which in turn calls inet_ntoa(). > 2. ip6 has a well de

Re: [HACKERS] time format

2004-01-03 Thread Kurt Roeckx
On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote: > > but what about default style ? > first time when i saw DateStyle i thought that i can use it like C/C++ > function strftime. I would be not bad idea to have custom data style :) Use to_char() function to put it in any format you want. Ku

Re: [HACKERS] Issue with Linux+Pentium SMP Context Switching

2003-12-19 Thread Kurt Roeckx
On Fri, Dec 19, 2003 at 11:17:31AM -0800, Josh Berkus wrote: > > Important fact left out of the problem description: The issue happens when > *two or more* intensive queries are running simultaneosly. So two queries are enough to get this problem? I assume the tables are so big that they don't

Re: [HACKERS] Issue with Linux+Pentium SMP Context Switching

2003-12-19 Thread Kurt Roeckx
On Fri, Dec 19, 2003 at 10:30:13AM -0800, Josh Berkus wrote: > > Linux Versions Reported: RH and Gentoo reported, Kernels 2.4.18 to 2.4.22 > Not tested on other distros/kernels. Kernels are SMP-enabled. Does the same problem show with an SMP kernel on an UP system? > When a query is

[HACKERS] Dates BC.

2003-12-18 Thread Kurt Roeckx
I find this a little strange: select date_part('year', '0002-01-01 BC'::date); date_part --- -1 It seems 1 BC and 0 are the same year. In backend/utils/adt/formatting.c: if (tmfc.bc) { if (tm->tm_year > 0) tm->tm_year = -(

Re: [HACKERS] Walker/mutator prototype.

2003-12-14 Thread Kurt Roeckx
On Sat, Dec 13, 2003 at 10:24:23PM -0500, Greg Stark wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > > I'm trying to change all the walkers and mutators to have a more > > strict prototype. I had to do this with lots of casts. > > > > I don&#

[HACKERS] Walker/mutator prototype.

2003-12-12 Thread Kurt Roeckx
I'm trying to change all the walkers and mutators to have a more strict prototype. I had to do this with lots of casts. I don't really like the idea of having all those generic pointer types (Node * and void *), but currently see no better way to deal with it. I attached the patch. Kurt Index

Re: [HACKERS] Canonicalization of WHERE clauses considered harmful

2003-12-10 Thread Kurt Roeckx
On Wed, Dec 10, 2003 at 05:35:11PM -0500, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > On Wed, Dec 10, 2003 at 04:54:54PM -0500, Tom Lane wrote: > >> (a AND b) OR (a AND c) > >> expands by repeated application of the distributive law to > >&

Re: [HACKERS] Canonicalization of WHERE clauses considered harmful

2003-12-10 Thread Kurt Roeckx
On Wed, Dec 10, 2003 at 04:54:54PM -0500, Tom Lane wrote: > Currently, this is accomplished by the roundabout method of converting > the WHERE clause to CNF (AND-of-ORs) and then simplifying duplicate > sub-clauses within an OR: > (a AND b) OR (a AND c) > expands by repeated application of th

[HACKERS] on_shmem_exit() callback function type.

2003-12-08 Thread Kurt Roeckx
It seems that on_shmem_exit() first argument is a function that needs to be called back. The function itself doesn't have a prototype, but it's called with and int and Datum as argument when it's used. It seems that almost none of the functions it calls will actually need any argument, I could on

Re: [HACKERS] CVS HEAD compile failure

2003-12-08 Thread Kurt Roeckx
On Mon, Dec 08, 2003 at 01:27:35PM -0500, Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I've been able to reproduce this on one of my machines, and it's nasty. > > > In that case I'm confused about why this code compiles on my machine: > > What compiler are

Re: [HACKERS] IDENT and IPv6 (was Re: [GENERAL] pg_hba.conf

2003-12-06 Thread Kurt Roeckx
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote: > Hi, > > The ident server we currently use is pidentd 3.0.16 > from : > http://www.lysator.liu.se/ or > ftp://ftp.lysator.liu.se/pub/ident/servers The ChangeLog of it says: Solaris 8 (including IPv6) support added. But I have a feeli

Re: [HACKERS] IDENT and IPv6 (was Re: [GENERAL] pg_hba.conf

2003-12-06 Thread Kurt Roeckx
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote: > Hi, > > The ident server we currently use is pidentd 3.0.16 The only I could find in a short time was oidentd. It says it runs on Linux, *BSD and Solaris. http://dev.ojnk.net/ I've been told that FreeBSD's inetd's internal identd

Re: [HACKERS] IDENT and IPv6 (was Re: [GENERAL] pg_hba.conf change in 7.4)

2003-12-06 Thread Kurt Roeckx
On Sat, Dec 06, 2003 at 02:09:25PM -0500, Tom Lane wrote: > [ moved to -hackers ] > > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> We are also wonder if there is a version of Ident server > >> that the PostgreSQL community knows that will work > >> with IPv6. > > > That is the big question. I

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-29 Thread Kurt Roeckx
On Fri, Nov 28, 2003 at 08:22:30PM -0500, Tom Lane wrote: > > One variable I didn't think to ask about is whether you are running > NTP. In my experience an ntp daemon that has achieved lock will never > step the clock back by even 1 usec (it's supposed to use much more > subtle methods than that

Re: [HACKERS] A rough roadmap for internationalization fixes

2003-11-26 Thread Kurt Roeckx
On Tue, Nov 25, 2003 at 04:19:05PM -0500, Tom Lane wrote: > > UCS-2 is impractical without some *extremely* wide-ranging changes in > the backend. To take just the most obvious point, doesn't it require > allowing embedded zero bytes in text strings? If you're going to use unicode in the rest of

Re: [HACKERS] A rough roadmap for internationalization fixes

2003-11-25 Thread Kurt Roeckx
On Tue, Nov 25, 2003 at 08:40:57PM +0900, Tatsuo Ishii wrote: > > On Tue, 25 Nov 2003, Peter Eisentraut wrote: > > > > I've always thought unicode was enough to even represent Japanese. Then > > the client encoding can be something else that we can convert to. In any > > way, the encoding of the

Re: [HACKERS] Using -Wshadow

2003-11-24 Thread Kurt Roeckx
On Mon, Nov 24, 2003 at 12:25:32PM -0500, Neil Conway wrote: > If there are any other GCC warning flags anyone else feels would be > useful, let me know. I find the following also useful: -Wcast-align -Wcast-qual -Wpointer-arith -Wstrict-prototypes And maybe: -Waggregate-return Kurt -

Re: [HACKERS] [7.4] statistics collector: Protocol not supported

2003-11-23 Thread Kurt Roeckx
On Sat, Nov 22, 2003 at 11:32:18PM -0400, Marc G. Fournier wrote: > > I suspect it might be because I'm running in a jail'd environment, but > what should I be looking at to confirm? > > could not create socket for statistics collector: Protocol not supported You probably shouldn't worry about i

Re: [HACKERS] 7.4 logging bug.

2003-11-21 Thread Kurt Roeckx
On Fri, Nov 21, 2003 at 02:49:28AM -0500, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > It's still logging the "recycled transation log file". Is that > > send to stdout instead of stderr maybe? > > No, it all goes to stderr. But that

Re: [HACKERS] 7.4 logging bug.

2003-11-21 Thread Kurt Roeckx
On Thu, Nov 20, 2003 at 04:08:28PM -0500, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > I just installed a 7.4 on windows/cygwin. I restored a dump but > > ran out of disk space during the creating of an index. In psql I > > saw the "

[HACKERS] 7.4 logging bug.

2003-11-20 Thread Kurt Roeckx
I just installed a 7.4 on windows/cygwin. I restored a dump but ran out of disk space during the creating of an index. In psql I saw the "ERROR: could not extend relation ". >From that point on it seems to have stopped logging most things. The ERROR and HINT are not in the log file, it stop

Re: [HACKERS] 7.4RC2 regression failur and not running stats collector process

2003-11-14 Thread Kurt Roeckx
On Thu, Nov 13, 2003 at 04:04:23PM -0500, Derek Morr wrote: > > the > machine I'm using (a V880 running 2.8) has no IPv6 address on any of its > interfaces. So the for loop over the addresses that are returned should go over both socket() and bind() instead of only socket(). And probably conne

Re: [HACKERS] Background writer process

2003-11-13 Thread Kurt Roeckx
On Thu, Nov 13, 2003 at 05:39:32PM -0500, Bruce Momjian wrote: > Jan Wieck wrote: > > Bruce Momjian wrote: > > > He found that write() itself didn't encourage the kernel to write the > > > buffers to disk fast enough. I think the final solution will be to use > > > fsync or O_SYNC. > > > > write(

Re: [HACKERS] Background writer process

2003-11-13 Thread Kurt Roeckx
On Thu, Nov 13, 2003 at 04:35:31PM -0500, Jan Wieck wrote: > For sure the sync() needs to be replaced by the discussed fsync() of > recently written files. And I think the algorithm how much and how often > to flush can be significantly improved. But after all, this does not > change the real ch

Re: [HACKERS] 7.4RC2 regression failur and not running stats collector process on Solaris

2003-11-12 Thread Kurt Roeckx
On Wed, Nov 12, 2003 at 10:32:38AM -0500, Tom Lane wrote: > "Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes: > > Are we using an api that only returns nslookup responses and not > > /etc/hosts entries ? At least on AIX it looks like it. > > We use getaddrinfo(), or if that doesn't exist get

Re: [HACKERS] Call for port reports

2003-11-08 Thread Kurt Roeckx
On Sat, Nov 08, 2003 at 06:36:38PM -0500, Bruce Momjian wrote: > > Kurt, this patch added special includes for testing un.h, and I believe > it caused regression failures for the statistics collector. Is it still > needed? What platform is this? It's a linux system with an (old) libc5. It's st

Re: [HACKERS] Bogus bind() warnings

2003-11-06 Thread Kurt Roeckx
On Thu, Nov 06, 2003 at 03:42:39PM -0500, Tom Lane wrote: > >> Is it possible that that kernel considers binding to an IPv6 port to > >> conflict with binding to the "same" port number as an IPv4 port? > > Actually, I think that that may be expected behavior depending on the > vintage of the kerne

Re: [HACKERS] Performance features the 4th

2003-11-05 Thread Kurt Roeckx
On Wed, Nov 05, 2003 at 03:49:54PM -0500, Jan Wieck wrote: > Andrew Dunstan wrote: > > >Jan Wieck wrote: > > > >> > >>How portable is getrusage()? Could the postmaster issue that > >>frequently for RUSAGE_CHILDREN and leave the result somewhere in the > >>shared memory for whoever is concerned?

Re: [HACKERS] \xDD patch for 7.5devel

2003-11-05 Thread Kurt Roeckx
On Wed, Nov 05, 2003 at 02:47:17PM -0600, Larry Rosenman wrote: > > > --On Thursday, November 06, 2003 07:43:07 +1100 Jason Godden > <[EMAIL PROTECTED]> wrote: > > >On Thu, 6 Nov 2003 06:25 am, Markus Bertheau wrote: > >>? ???, 05.11.2003, ? 16:25, Tom Lane ?: > >>> > +#define HEXVALUE(c) (

Re: [HACKERS] Annotated release notes

2003-10-31 Thread Kurt Roeckx
On Thu, Oct 30, 2003 at 11:59:05PM -0500, Bruce Momjian wrote: > > OK, I have committed changes to release.sgml so most complex entries > have a paragraph describing the change. You can see the result at: * Full support for IPv6 connections and IPv6 address data types Prior releases

Re: [HACKERS] Call for port reports

2003-10-26 Thread Kurt Roeckx
On Sun, Oct 26, 2003 at 08:27:10AM -0500, Bruce Momjian wrote: > > Ports list updated: > > http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html > > Should I mention Solaris as 2.6 or 5.6? Normally you speak about Solaris 2.5, 2.6, 7, 8 and 9. Which are also known as

Re: [HACKERS] regression failure with current

2003-10-26 Thread Kurt Roeckx
On Sun, Oct 26, 2003 at 08:27:52PM +0900, Tatsuo Ishii wrote: > I have seen following regression failure with current(I cvs up'ed 10 > minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc > 2.2.4. Maybe the change of TZ (summer to winter time) tonight caused this. Kurt ---

Re: [HACKERS] Call for port reports

2003-10-26 Thread Kurt Roeckx
On Sat, Oct 25, 2003 at 08:42:36PM -0400, Bruce Momjian wrote: > > I am confused by your report. I have success from Solaris kernel 5.8. > I see 2.6 mentioned, and I know there is Solaris 7-9. What does uname > -a show? SunOS oink 5.6 Generic_105182-09 i86pc i386 i86pc Which is the same as So

Re: [HACKERS] Call for port reports

2003-10-25 Thread Kurt Roeckx
On Sat, Oct 25, 2003 at 01:03:37PM +0200, Noèl Köthe wrote: > [EMAIL PROTECTED]:~/pgsql$ uname -a > Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux > > It says i686 but its AMD Opteron: Just wondering, but does it run in 32 or 64 bit mode? I have a feeling it's only 32

Re: [HACKERS] Call for port reports

2003-10-25 Thread Kurt Roeckx
On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce Momjian wrote: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. checking build system type... i386-pc-solaris2.6 checking host system type... i386-pc-solaris2.6 checking whi

Re: [HACKERS] Call for port reports

2003-10-24 Thread Kurt Roeckx
On Sat, Oct 25, 2003 at 12:46:39AM +0200, Peter Eisentraut wrote: > Kurt Roeckx writes: > > > I need this small patch so it properly detects I have unix domain > > sockets. Otherwise no problems. > > What system? What happens without the patch? Details, please. It

Re: [HACKERS] Call for port reports

2003-10-24 Thread Kurt Roeckx
On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce Momjian wrote: > It is time for people to report their port testing. Please test against > current CVS or beta5 and report your 'uname -a'. I need this small patch so it properly detects I have unix domain sockets. Otherwise no problems. Kurt In

Re: [HACKERS] Improving REINDEX for system indexes (long)

2003-09-21 Thread Kurt Roeckx
On Mon, Sep 22, 2003 at 04:56:35AM +0900, Hiroshi Inoue wrote: > First it should have been discussed before your commitment or at least > it should be discussed after reversing your change. > > I require you to explain me why you committed the change > with no discussion and little investigation.

Re: [HACKERS] compile warnings in CVS HEAD?

2003-09-15 Thread Kurt Roeckx
On Mon, Sep 15, 2003 at 08:09:22PM +0200, Peter Eisentraut wrote: > Neil Conway writes: > > > On Thu, 2003-09-04 at 13:14, Kurt Roeckx wrote: > > > > > tablecmds.c: In function `validateForeignKeyConstraint': > > > > > tablecmds.c:3546: warnin

[HACKERS] Make check uses wrong binary.

2003-09-14 Thread Kurt Roeckx
I've seen this before, and I'm not sure why I get this. When I run make check, in the top dir, I get: == removing existing temp installation== == creating temporary installation== == initializing database system

Re: [HACKERS] Stats Collector Error 7.4beta1 and 7.4beta2

2003-09-09 Thread Kurt Roeckx
On Tue, Sep 09, 2003 at 02:10:20AM -0700, Kevin Brown wrote: > > I could go for Jan's idea of putting a random key into the messages, > > if anyone feels that we should not trust to the kernel to enforce the > > packet source address restriction. But the memcmp() test seems a clear > > loser given

Re: [HACKERS] Stats Collector Error 7.4beta1 and 7.4beta2

2003-09-05 Thread Kurt Roeckx
On Fri, Sep 05, 2003 at 09:35:11AM -0400, Jan Wieck wrote: > Redhat 7.1 says > >The file descriptor sockfd must refer to a socket. If the >socket is of type SOCK_DGRAM then the serv_addr address is >the address to which datagrams are sent by default, and >the o

Re: [HACKERS] Stats Collector Error 7.4beta1 and 7.4beta2

2003-09-04 Thread Kurt Roeckx
On Thu, Sep 04, 2003 at 04:04:38PM -0400, Jan Wieck wrote: > > And I agree with Tom that it is very likely that the IPV4/IPV6 stuff is > the reason. IIRC the postmaster creates the socket and noone ever does > bind(2) on it - so it uses it's dynamically assigned port number. Both, > the collect

Re: [HACKERS] Stats Collector Error 7.4beta1 and 7.4beta2

2003-09-04 Thread Kurt Roeckx
On Thu, Sep 04, 2003 at 05:01:54PM -0400, Jan Wieck wrote: > > > Kurt Roeckx wrote: > > > >It could be useful to have a warning at the following line: > > > >if (memcmp(&fromaddr, &pgStatAddr, fromlen)) > >

Re: [HACKERS] Win32 native port

2003-09-04 Thread Kurt Roeckx
On Thu, Sep 04, 2003 at 12:27:58PM -0700, Dann Corbit wrote: > Did you read this: > "This means that unless you modify the tools so that compiled > executables do not make use of the Cygwin library, your compiled > programs will also have to be free software distributed under the GPL > with source

Re: [HACKERS] TCP/IP with 7.4 beta2 broken?

2003-09-04 Thread Kurt Roeckx
On Thu, Sep 04, 2003 at 07:18:57PM +0200, Peter Eisentraut wrote: > Tom Lane writes: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Can we allow the IPv6 entries to be in pg_hba.conf but ignore them on > > > non-IPv6 machines, or allow the connection to fail? > > > > I don't see a good way

Re: [HACKERS] Stats Collector Error 7.4beta1 and 7.4beta2

2003-09-04 Thread Kurt Roeckx
On Thu, Sep 04, 2003 at 01:39:04AM -0400, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Doesn't the stats collector use unix domain sockets, not IP? > > No. IIRC, we deliberately chose IP/UDP because it had buffering > behavior we liked. Once you said it was because not all pla

Re: [HACKERS] compile warnings in CVS HEAD?

2003-09-04 Thread Kurt Roeckx
On Wed, Sep 03, 2003 at 10:30:05PM -0400, Tom Lane wrote: > > > tablecmds.c: In function `validateForeignKeyConstraint': > > tablecmds.c:3546: warning: dereferencing type-punned pointer will break > > strict-aliasing rules > > Hm. Got any idea what these are really complaining about? I see no >

Re: [HACKERS] Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)

2003-09-03 Thread Kurt Roeckx
On Wed, Sep 03, 2003 at 03:36:53PM -0400, Bruce Momjian wrote: > > I would like every operating system that supports thread-safety to run > this program and report back the results. On a Linux system with glibc 2.1: Your gethostbyname() is _not_ thread-safe Your getpwuid() is _not_ thread-safe Yo

Re: [HACKERS] TCP/IP with 7.4 beta2 broken?

2003-09-03 Thread Kurt Roeckx
On Mon, Sep 01, 2003 at 09:59:17PM +0200, Tommi Mäkitalo wrote: > > psql: FATAL: no pg_hba.conf entry for host ":::127.0.0.1", user > "postgres", database "template1" This is a Linux system that does not have the IPV6_V6ONLY setsockopt() option. Linux only has this option since 2.4.21 (pre

Re: [HACKERS] Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)

2003-08-31 Thread Kurt Roeckx
On Sun, Aug 31, 2003 at 12:04:58PM +0200, Peter Eisentraut wrote: > Lee Kindness writes: > > > You don't... and you simply shouldn't care. If there is a_r version > > available then we should use it - even if the plain version is "safe". > > The problem with this is that the automatic determinati

  1   2   >