Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4B327475DA3 for ; Tue, 12 Nov 2002 15:12:56 -0500 (EST) Received: from crundall.nidweb.net (crundall.nidweb.net [216.229.174.203]) by postgresql.org (Postfix) with ESMTP id D1246476536 for ; Tue, 12 Nov 2002 15:12:54 -0500 (EST) Received: from ac6rm.net (localhost [127.0.0.1]) by crundall.nidweb.net (8.12.6/8.12.4) with SMTP id gACKCt0C011849 for ; Tue, 12 Nov 2002 12:12:55 -0800 Received: from 24.52.245.104 (SquirrelMail authenticated user martin) by webmail.ac6rm.net with HTTP; Tue, 12 Nov 2002 12:12:55 -0800 (PST) Message-ID: <65026.24.52.245.104.1037131975.squirrel@webmail.ac6rm.net> Date: Tue, 12 Nov 2002 12:12:55 -0800 (PST) Subject: Re: Postgres Date pg_dump/Import: From: "Martin Crundall" To: In-Reply-To: <23459.1037108362@sss.pgh.pa.us> References: <63575.24.52.245.104.1037005800.squirrel@webmail.ac6rm.net> <381.1037020353@sss.pgh.pa.us> <64587.24.52.245.104.1037067727.squirrel@webmail.ac6rm.net> <23459.1037108362@sss.pgh.pa.us> X-Priority: 3 Importance: Normal Reply-To: pgsql@ac6rm.net X-Mailer: SquirrelMail (version 1.2.9) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/199 X-Sequence-Number: 10341 Tom; Not sure how to tell. I didn't explicitly specify anything like this during the ./configure step of install. Poking around in the souce directory, I pulled this out of config.cache ... configure:1243: checking whether the C compiler (gcc -O9 -funroll-loops -ffast-math -malign-double -mcpu=pentiumpro -march=pentiumpro -fomit-frame-pointer -fno-exceptions ) works Note, I didn't use the postgresql that came with Slackware; I downloaded it from the postgres web site. Martin >> i am currently running 7.2.2 on slackware 8.1 (kernel 2.4.18) > > BTW, is it possible that your postgres was built with -ffast-math > in CFLAGS? That is known to cause symptoms like this. Unfortunately > -ffast-math is in the default CFLAGS on some Linux distros. > > regards, tom lane