Re: [HACKERS] broken configure, broken makefile?

2005-09-01 Thread Tom Lane
Gavin Sherry [EMAIL PROTECTED] writes:
 And this is the reason why it is old. You're asking for pain if you're
 using 7.0.3 and this is just the start.

There are several good reasons why the community stopped supporting
versions before 7.2, which we did quite some time ago.  Don't expect
a lot of sympathy here when 7.0 eats your data.

regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] broken configure, broken makefile?

2005-09-01 Thread Robert Treat
On Thursday 01 September 2005 09:15, Tom Lane wrote:
 Gavin Sherry [EMAIL PROTECTED] writes:
  And this is the reason why it is old. You're asking for pain if you're
  using 7.0.3 and this is just the start.

 There are several good reasons why the community stopped supporting
 versions before 7.2, which we did quite some time ago.  Don't expect
 a lot of sympathy here when 7.0 eats your data.


Easy there guys! I'm in the process of building a new demo server for 
phppgadmin. We use that for demos and testing, especially on these older 
versions. On the current server we support all the way back to 7.0 (on 
slackware 8 iirc).  I fully agree that you don't want to be using these older 
versions if you can avoid it, but just a week or so ago we got a bug report 
from someone using 7.1, so those people are out there, and if we can help 
them I don't see anything wrong with that.

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] broken configure, broken makefile?

2005-09-01 Thread David Fetter
On Thu, Sep 01, 2005 at 10:15:19AM -0400, Robert Treat wrote:
 On Thursday 01 September 2005 09:15, Tom Lane wrote:
  Gavin Sherry [EMAIL PROTECTED] writes:
   And this is the reason why it is old. You're asking for pain if
   you're using 7.0.3 and this is just the start.
 
  There are several good reasons why the community stopped
  supporting versions before 7.2, which we did quite some time ago.
  Don't expect a lot of sympathy here when 7.0 eats your data.
 
 
 Easy there guys! I'm in the process of building a new demo server
 for phppgadmin. We use that for demos and testing, especially on
 these older versions. On the current server we support all the way
 back to 7.0 (on slackware 8 iirc).  I fully agree that you don't
 want to be using these older versions if you can avoid it, but just
 a week or so ago we got a bug report from someone using 7.1, so
 those people are out there, and if we can help them I don't see
 anything wrong with that.

The best help you can give these people is to get them onto a system
released since the end of the Clinton administration.

Cheers,
D
-- 
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [HACKERS] broken configure, broken makefile?

2005-09-01 Thread Alvaro Herrera

You current problem has to do with multiline gcc --version.  You could
backport the fix for that, or you could wrap gcc with a script so it
only reports only line for --version.

I have 7.1.3 running here, I patched configure as attached.  Very ugly,
but it works.

 Easy there guys! I'm in the process of building a new demo server for 
 phppgadmin. We use that for demos and testing, especially on these older 
 versions. On the current server we support all the way back to 7.0 (on 
 slackware 8 iirc).  I fully agree that you don't want to be using these older 
 versions if you can avoid it, but just a week or so ago we got a bug report 
 from someone using 7.1, so those people are out there, and if we can help 
 them I don't see anything wrong with that.

Yeah -- I'm supporting a company running 7.1.3, which has several
reliability problems and has suffered from corruption, but has had a
long way to upgrading.  Fortunately all the problems have convinced them
of the importance of the upgrade.  Previously they had so much trouble,
and the system was performing so horribly, that they had asked help from
IBM to migrate to DB2.  Someone managed to convince them to upgrade Pg
instead, and got me to help with that -- in the meantime, we have to
keep the 7.1.3 server running.

-- 
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
La naturaleza, tan fr?gil, tan expuesta a la muerte... y tan viva
Index: configure
===
RCS file: /home/alvherre/cvs/pgsql/configure,v
retrieving revision 1.127.2.2
diff -c -r1.127.2.2 configure
*** configure   13 Aug 2001 20:09:03 -  1.127.2.2
--- configure   9 Mar 2005 18:14:37 -
***
*** 1617,1623 
  
  # Create compiler version string
  if test x$GCC = xyes ; then
!   cc_string=GCC `${CC} --version`
  else
cc_string=$CC
  fi
--- 1617,1623 
  
  # Create compiler version string
  if test x$GCC = xyes ; then
!   cc_string=GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-10)
  else
cc_string=$CC
  fi

---(end of broadcast)---
TIP 6: explain analyze is your friend


[HACKERS] broken configure, broken makefile?

2005-08-31 Thread Robert Treat
running vanilla configure, i see the following toward the end, and my makefile 
is incomplete as well:

checking alignment of int... (cached) 4
checking alignment of long... (cached) 4
checking alignment of long long int... (cached) 4
checking alignment of double... (cached) 4
checking for POSIX signal interface... yes
checking for tclsh... (cached) /usr/bin/tclsh
creating ./config.status
creating GNUmakefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating Makefile.global
sed: file conftest.s1 line 35: Unterminated `s' command
creating backend/port/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating backend/catalog/genbki.sh
sed: file conftest.s1 line 35: Unterminated `s' command
creating backend/utils/Gen_fmgrtab.sh
sed: file conftest.s1 line 35: Unterminated `s' command
creating bin/pg_dump/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating bin/pg_version/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating bin/pgtclsh/mkMakefile.tcldefs.sh
sed: file conftest.s1 line 35: Unterminated `s' command
creating bin/pgtclsh/mkMakefile.tkdefs.sh
sed: file conftest.s1 line 35: Unterminated `s' command
creating bin/psql/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating include/version.h
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/libpq/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/ecpg/lib/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/ecpg/preproc/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/libpq++/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/libpgeasy/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/libpgtcl/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/odbc/GNUmakefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating interfaces/odbc/Makefile.global
sed: file conftest.s1 line 35: Unterminated `s' command
creating pl/plpgsql/src/Makefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating pl/plpgsql/src/mklang.sql
sed: file conftest.s1 line 35: Unterminated `s' command
creating pl/tcl/mkMakefile.tcldefs.sh
sed: file conftest.s1 line 35: Unterminated `s' command
creating test/regress/GNUmakefile
sed: file conftest.s1 line 35: Unterminated `s' command
creating include/config.h
include/config.h is unchanged
linking ./backend/port/dynloader/linux.c to backend/port/dynloader.c
linking ./backend/port/dynloader/linux.h to include/dynloader.h
linking ./include/port/linux.h to include/os.h
linking ./makefiles/Makefile.linux to Makefile.port
linking ./backend/port/tas/dummy.s to backend/port/tas.s
linking ./include/port to interfaces/odbc/port
linking ./makefiles to interfaces/odbc/makefiles
linking ./template to interfaces/odbc/template
linking ./include/config.h to interfaces/odbc/config.h

I couldnt seem to find a conftest.s1 file nor the sed command being called, 
can someone point me in the right direction?

oh... this is compiling 7.0.3 on slackware 10.1, lmk if you need more info.  
TIA

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] broken configure, broken makefile?

2005-08-31 Thread Gavin Sherry
On Thu, 1 Sep 2005, Robert Treat wrote:

 running vanilla configure, i see the following toward the end, and my makefile
 is incomplete as well:


Old problem.
http://archives.postgresql.org/pgsql-ports/2003-04/msg00015.php.


 I couldnt seem to find a conftest.s1 file nor the sed command being called,
 can someone point me in the right direction?

 oh... this is compiling 7.0.3 on slackware 10.1, lmk if you need more info.

And this is the reason why it is old. You're asking for pain if you're
using 7.0.3 and this is just the start.

Gavin

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings