[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

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

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 k...@roeckx.be 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? Yes, making oldcontext

[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

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

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, maybe this is it: http

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 atleast solves the problems with 8.2. Excellent

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. You can see the results on buildfarm

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 to 8.3 and head. 8.3 and head don't have a problem

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 and later. What happens to your

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 difference is this fix: http

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 value for both 8.2 and 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 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, maybe this is it: http

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. You can see the results on buildfarm

[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

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 only affects ecpg?

[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 postgres.

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 rsync

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 stuff

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] 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] 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] 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. It has this comment in it: /* the new

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] 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 doesn't support %$ natively on my libc

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] [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:

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-releases

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 over

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 options?

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: explain

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 is only

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 that

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

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 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 something must be wrong. Those results

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 being a

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 says

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 unfortunately they

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 defined

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 makes the

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

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] I read it to mean that abbreviated forms

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 the

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. Kurt

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

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

[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't really like the idea of having all those generic pointer

[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

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 the

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 (a OR a) AND (a OR c) AND (b OR a) AND (b OR c

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 you using?

[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

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 would think

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

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 feeling

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 to

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 message

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 it.

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 ERROR: could not extend relation . From that point

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 output comes from a different subprocess. Not sure

[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

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

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

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() alone doesn't

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

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 still

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 kernel. Note

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? SVr4, BSD4.3,

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 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

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 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] 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

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-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

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's a Linux system with libc5

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. I

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: warning: dereferencing type-punned pointer will break strict-aliasing

[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 only

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 such

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 platforms

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 yet. The fly

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 code

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)) continue; That way you can rule out

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 collector

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 (pre3).

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 Your

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 determination (in

Re: [HACKERS] Can't find thread on Linux memory overcommit

2003-08-21 Thread Kurt Roeckx
On Thu, Aug 21, 2003 at 01:04:13PM -0400, Tom Lane wrote: Josh Berkus [EMAIL PROTECTED] writes: Well, sadly, the reason I posted is that I (apparently) had a client's database fatally corrupted by this problem. Fatally corrupted? That should not happen --- at worst, an OOM kill should

Re: [HACKERS] IPv6 in 7.4?

2003-08-20 Thread Kurt Roeckx
On Wed, Aug 20, 2003 at 08:22:51AM -0700, Josh Berkus wrote: Guys, So ... do we have full IPv6 support in 7.4, or what? For the network ipv6 support: It should all work. Afaik, there is only 1 piece of the networking code left that doesn't support ipv6 and that is Kerberos 4. And that is

[HACKERS] Bounds error in LockMethodInit().

2003-08-15 Thread Kurt Roeckx
In lmgr.c you have a static LOCKMASK LockConflicts[] with 9 elements in it. You call LockMethodTableInit() with that pointer, and MAX_LOCKMODES - 1 (10 - 1 = 9) That calls LockMethodInit with the same arguments, but it does numModes++. So you basicly have a for loop that looks like: for (i =

  1   2   >