#----------------------------------------------------------------------------- # pg95.log -- log of pg95-1.01 -> pg95-1.02 port/patch merge effort #----------------------------------------------------------------------------- # created log to cronicle this effort pg95.log # established directory structure for patch/port reconciliation pg95 accumulated pg95 archives digests sources pg95-1.01 virgin copy for reference pg95-1.01.i86pc i96pc_solaris port (host for this effort) pg95-1.01.sparc sparc_solaris port (merging drgeorge changes) pg95-1.01.sun3 SunOS.4.1.1 on sun3/110 port pg95-1.01.x386 i86pc_solaris port (first effort: for refernce) pg95-1.02 results pg95.log this file postgres database execution directory postgres95 for unpacking distribution # unpacked postgres95-1.01.tar.gz into pg95-1.01 cd /ubstime.c /user/pg95-1.01.i86pc/src/backend/utils/adt ser gzip -dc pg95/zip/postgres95-1.01.tar.gz | tar xvf - mv postgres95/* pg95-1.01 # made all files/dirctories READONLY in pg95-1.01 cd /user/pg95-1.01 find . -type f -exec chmod 444 {} \; find . -type d -exec chmod 555 {} \; #------------------------------------------------------------------------------ # create new i86pc_solaris port merging changes from several sources #------------------------------------------------------------------------------ # unpacked postgres95-1.01.tar.gz into pg95-1.01.i86pc for port i86pc_solaris cd /user gzip -dc pg95/zip/postgres95-1.01.tar.gz | tar xvf - mv postgres95/* pg95-1.01.i86pc # moved previous Makefile.global to current mv pg95-1.01.x386/src/Makefile.global pg95-1.01.i86pc # differenced 'reference' with 'x386' cd /user diff -r pg95-1.01 pg95-1.01.x386 >& /tmp/diff # move changes indicated by difference to 'i86pc' mkdir /user/pg95-1.01.i86pc/src/backend/port/i86pc_solaris cd /user/pg95-1.01.x386/src/backend/port/i86pc_solaris cp * /user/pg95-1.01.i86pc/src/backend/port/i86pc_solaris cd /user/pg95-1.01.x386/src/backend/storage cp buf_internals.h /user/pg95-1.01.i86pc/src/backend/storage cp ipc.h /user/pg95-1.01.i86pc/src/backend/storage cd ipc cp s_lock.c /user/pg95-1.01.i86pc/src/backend/storage/ipc cd ../../utils/adt cp float.c /user/pg95-1.01.i86pc/src/backend/utils/adt cp nabstime.c /user/pg95-1.01.i86pc/src/backend/utils/ip cd ../mmgr cp aset.c /user/pg95-1.01.i86pc/src/backend/utils/mmgr # make pg95 for 'i86pc_solaris' cd /user/pg95-1.01.i86pc/src make # yacc and lex are needed - set path to include /usr/ccs/bin cd /user/pg95-1.01.i86pc/src make # other compile problems; port specific make file missing cd /user/pg95-1.01.x386/src/mk/port cp postgres.mk.i86pc_solaris /user/pg95-1.01.i86pc/src/mk/port # remake cd /user/pg95-1.01.i86pc/src make clean make # installed and initialized make install rehash initdb # ran regression tests cd /user/pg95-1.01.i86pc/src/test/regres make all runtest # compared output # differnces in filenames, floating overflow, and geographic data # the filenames we will take care of later # searched for _solaris and checked for i86pc_solaris missing cd /user/pg95-1.01.i86pc find . -exec grep _solaris {} \; -print | more # fixed descrepancies # searched digests for references to '_solaris' applied patches # v01.n005 # From: michael.siebenborn@ae3.Hypo.DE (Michael Siebenborn (6929)) # Date: Thu, 22 Feb 1996 11:07:04 +0100 # Subject: Re: [PG95]: Few files descriptors left? # ./src/backend/storage/file/fd.c # ADDED # v01.n053 # From: Randy Kunkee # Date: Mon, 20 May 1996 18:16:19 -0500 (CDT) # Subject: [PG95]: Feedback on postgres95/patches for i386_solaris # REVIEWED # my name 'i86pc_solaris' follows solaris 'arch' conventions # my TEST_AND_SET conventions follow solaris but use GCC inline code for speed # recompiled clean # applied the public patches 1 and 2 # merged code from my sparc port to make comparison of regression tests easier # a path/user independent 'expected.in' is used to make a path/user dependent # 'obj/expected.out' for comparison with 'obj/regress.out' # FuNkY_StUfF strikes again cd /user/pg95-1.01.sun4/src/test/regress cp Makefile /user/pg95-1.01.i86pc/src/test/regress cp expected.* /user/pg95-1.01.i86pc/src/test/regress # merged my changes to 'bin/pgtclsh' to account for tcl7.5/tk4.1 differences cd /user/pg95-1.01.sun4/src/bin/pgtclsh cp Makefile pg*.c /user/pg95-1.01.i86pc/src/bin/pgtclsh # added X11 locations for TCL X11 includes/libs are not always in wellknown # directories added X11 symbols in Makefile.global #------------------------------------------------------------------------------ # reviewed digests for patches to pg95-1.01 # found 51 messages with patch files or instructions for source changes # reviewed two with i86pc_solaris changes to update my i86pc_solaris port < From: Dan McGuirk < Date: Wed, 1 May 1996 13:12:30 -0700 (MST) < Subject: [PG95]: postgres95 for Solaris x86 patch --- > From: Randy Kunkee > Date: Mon, 20 May 1996 18:16:19 -0500 (CDT) > Subject: [PG95]: Feedback on postgres95/patches for i386_solaris # --> noticed multiple definitions of 'semun' for PORTNAME_badi <-- # the version was closed to mine as it was more # solaris orientated, a couple of changes were indicated # had initially missed the mcguirk@indirect.com e-mail as # it was MIME encoded in BASE64 and grep did not see solaris # remake from clean make clean make # ran regression test still failure of select of streets and roads # this may be a platform dependent problem # i will proceed with the patch application # make backup '001' # patch.000 previously applied OK --- src/bin/monitor/monitor.c # patch.001 previously applied OK From: Jolly Chen Date: Wed, 28 Feb 1996 08:42:05 -0800 Subject: [PG95]: PATCH #1: can't drop tables with names longer 16 charactesr --- src/backend/storage/smgr/md.c # patch.002 previously applied OK From: Jolly Chen Date: Thu, 29 Feb 1996 08:49:54 -0800 Subject: [PG95]: PATCH #2: using ~ or LIKE on null text fields cause core dump --- src/backend/utils/adt/like.c --- src/backend/utils/adt/regexp.c # patch.003 From: Julian Assange Date: Tue, 27 Feb 1996 06:29:04 +1100 (EST) Subject: [PG95]: psql/monitor/libpq enhancements (now does html3, alignment, pip es etc) +++ src/bin/psql/psql.c +++ src/bin/monitor/monitor.c +++ src/libpq/fe-exec.c +++ src/libpq/libpq-fe.h +++ doc/man/psql.1 +++ doc/man/libpq.3pq # patch.003 FAILED horribly (it appears to be a patch to 1.0) # it is a very useful patch for generating HTML apply by hand # after reexpanding the backup '001' # reexpanded backup '001' # SKIP patch,003 until source for 1.0 can be obtained for experiment # patch.004 (It's an empty file) RESEARCH needed # patch.005 From: Salvador Ortiz Garcia Date: Wed, 28 Feb 1996 20:56:53 -0600 (CST) Subject: [PG95]: Segmentation faults when using LIKE corrected +++ postgres95/src/backend/utils/adt/like.c # it appears to be fixed already (probably patch,002) # patch.006 From: "Charles F. Randall" Date: Mon, 4 Mar 1996 10:21:43 -0600 Subject: [PG95]: Install Instructions for FreeBSD v2.1R # copied to top level directory cp /user/pg95/patch/pg95-1.01.patch.006 INSTALL.FreeBSD # patch.007 From: "Thomas van Reimersdahl" Date: Mon, 4 Mar 1996 23:13:00 -0800 Subject: [none] src/backend/port/irix5/port-protos.h # patch.008 From: azcb0@sde.uts.amdahl.com Date: Tue, 5 Mar 96 05:29 PST Subject: [PG95]: Various threads src/backend/catalog/pg_operator.h # patch.009 From: Raymond Toy Date: Tue, 05 Mar 1996 13:19:24 -0500 Subject: [PG95]: Disable PAGER if ntuples is small and make bug ./src/libpq/fe-exec.c # patch.010 From: drgeorge@ilt.com (Dr_George_D_Detlefsen) Date: Mon, 11 Mar 96 17:24:22 PST Subject: [none] Makefile to install man pages doc/Makefile src/Makefile ## make backup '001' and remake all # patch.011 From: Massimo Dal Zotto Date: Wed, 13 Mar 1996 11:24:53 +0100 (MET) Subject: [PG95]: postgres95 bug report src/backend/catalog/pg_type.h # patch.012 From: "srikumar (s.) natarajan" Date: Wed, 13 Mar 1996 10:51:00 -0500 Subject: re:[PG95]: PG95 and AIX 4.1 Port src/backend/port/aix/mkldexport.sh /src/backend/utils/adt/misc.c src/backend/port/aix/Makefile.inc # patch.013 From: Massimo Dal Zotto Date: Fri, 15 Mar 1996 14:17:14 +0100 (MET) Subject: [PG95]: patches src/backend/utils/adt/datetimes.c # secs < 62.0 allows for 'leap' seconds # patch.014 From: chris@atlas.onthe.net.au (Chris Dunlop) Date: 18 Mar 1996 15:14:43 +1100 Subject: [PG95]: pg_dump dumps core src/bin/pg_dump/Makefile src/bin/pg_dump/pg_dump.c # patch.015 From: Anton de Wet Date: Mon, 18 Mar 1996 10:14:53 +0200 (GMT+0200) Subject: Re: [PG95]: Assigning to arrays with libpgtcl ./src/libpgtcl/pgtclCmds.c # patch.016 From: Massimo Dal Zotto Date: Tue, 19 Mar 1996 14:00:15 +0100 (MET) Subject: [PG95]: problems updating array elements # --> not applied, see patch.017 # patch.017 From: Massimo Dal Zotto Date: Sat, 23 Mar 1996 17:49:48 +0100 (MET) Subject: [PG95]: postgres95 bug report src/test/regress/create.source src/Makefile.global src/backend/parser/analyze.c src/backend/utils/adt/arrayfuncs.c # patch.018 From: tuttle@crl.dec.com Date: Wed, 27 Mar 96 17:36:46 -0500 Subject: [PG95]: Regression test errors on DEC Alpha/DEC OSF1? src/Makefile -- edited to include Makefile.global before USE_TCL test src/bin/Makefile -- ... # could not find reference to "sigval_t" anywhere src/bin/pgtclsh/Makefile -- already edited src/libpgtcl/Makefile # patch.019 From: "Marc G. Fournier" Date: Tue, 2 Apr 1996 17:25:21 -0500 (EST) Subject: Re: [PG95]: Install Instructions for FreeBSD v2.1R INSTALL.FreeBSD -- appended comments # make backup pg95.002.tar.gz # make clean all # run regression test, same result as before # patch.020 From: "Alistair G. Crooks" Date: Wed, 03 Apr 1996 00:27:01 -0800 Subject: Re: [PG95]: Install Instructions for FreeBSD v2.1R INSTALL.FreeBSD -- appended comments --> need to rectify comments # patch.021 From: Michael Birk Date: Wed, 10 Apr 1996 22:44:37 -0500 Subject: [PG95]: Bug in textcat() (postgres95-1.01) From: Michael Birk Date: Wed, 10 Apr 1996 23:40:46 -0500 Subject: [PG95]: textcat() bug (followup) src/backend/utils/adt/varlena.c # patch.022 From: Michael Talbot-Wilson Date: Mon, 15 Apr 1996 00:37:47 +0930 Subject: [PG95]: Man pages etc. # man pages, nothing done, deferred # patch.023 From: jahowell@dyson.brisnet.org.au (John Howell) Date: Wed, 17 Apr 1996 18:48:49 Subject: [PG95]: Problem defining soundex operator for text # user defined soundex function, needs work, how does one do an # internal operator definition ??? # deferred # patch.024 From: root Date: Thu, 18 Apr 1996 09:42:02 +0300 (GMT+0300) Subject: [PG95]: bug fix src/backend/utils/adt/geo-ops.c # patch.25 From: Jens Rathke <101602.1256@compuserve.com> Date: 19 Apr 96 08:58:07 EDT Subject: [PG95]: bug-report # this patch is for pg96-1.0 and is already applied to 1.01 # patch.26 From: Jolly Chen Date: Mon, 22 Apr 1996 22:44:07 -0700 Subject: Re: [PG95]: pg_class.relnatts and actual number of attributes ./catalog/pg_attribute.h # edited relnum's for pg_class # patch.27 From: "Thomas M. Duff" Date: Tue, 23 Apr 1996 13:07:49 -0700 Subject: [PG95]: FETCH src/backend/parser/gram.y # fetch without arguments will return 1 tuple # regression test does not test the default case where quantity is defaulted # patch.28 From: mike@ibm4.carb.nist.gov (Mike Tung) Date: Tue, 30 Apr 1996 10:39:25 -0400 Subject: Re: [PG95]: Installing Postgres95 on AIX3.2.5 src/Makefile.global comment out CDEBUG= -g # patch.29 From: chris@atlas.onthe.net.au (Chris Dunlop) Date: 1 May 1996 14:23:02 +1000 Subject: [PG95]: FIX: endless loop in backend src/backend/tcop/postgres.c src/backend/utils/error/elog.c # make backup pg95.003.tar.gz # make clean all # run regression test, same result, except 'array' update changes # patch.030 From: Chad Robinson Date: Wed, 1 May 1996 11:28:55 -0400 (EDT) Subject: [PG95]: SYS_DATE function and hooks src/backend/parser/scan.l src/backend/parser/Makefile.inc src/backend/parser/sysfunc.c src/backend/parser/sysfunc.h # patch.031 From: Dan McGuirk Date: Wed, 1 May 1996 13:12:30 -0700 (MST) Subject: [PG95]: postgres95 for Solaris x86 patch # ALREADY merged # patch.032 From: "Geir N. Soerensen" Date: Fri, 3 May 1996 21:43:03 +0200 (MET DST) Subject: [PG95]: Bug when dropping tables? # BUG report, NO code changes # patch.033 From: Massimo Dal Zotto Date: Mon, 6 May 1996 00:41:42 +0200 (MET DST) Subject: [PG95]: patches (support for NULL values in queries) src/backend/parser/analyze.c src/backend/parser/catalog_utils.c src/backend/parser/parser.c src/backend/parser/parse_query.c src/Makefile.global CFLAGS += -DNULL_PATCH # patch.034 From: Massimo Dal Zotto Date: Mon, 6 May 1996 00:44:55 +0200 (MET DST) Subject: [PG95]: bug report + patch (isnull with indices) src/backend/optimizer/path/indxpath.c # patch.035 From: Massimo Dal Zotto Date: Mon, 6 May 1996 01:03:37 +0200 (MET DST) Subject: [PG95]: new operators for arrays # this is an extension, aka 'data blade' for pg95 # created new directory 'extra' for such packages # patch.036 From: "Marc G. Fournier" Date: Thu, 9 May 1996 15:18:30 -0400 (EDT) Subject: [PG95]: patch for pg_dump src/bin/pg_dump/pg_dump.c # patch.037 From: Massimo Dal Zotto Date: Tue, 14 May 1996 14:29:17 +0200 (MET DST) Subject: [PG95]: bug report + patch (hash indices on date and time) src/backend/catalog/pg_amop.h src/backend/catalog/pg_amproc.h # patch.038 From: Massimo Dal Zotto Date: Tue, 14 May 1996 14:31:18 +0200 (MET DST) Subject: [PG95]: new postgres functions # moved to dynamic library # patch.039 From: Holm Tiffe Date: Tue, 14 May 1996 19:00:01 +0200 (MET DST) Subject: [PG95]: locale env # find internationalized regex routines # make backup pg95.004.tar.gz # make clean all # ran regression, same results as before # patch.040 From: Juergen Vigna Date: Thu, 16 May 1996 13:58:29 +0200 (MET DST) Subject: [PG95]: Postgres95 1.01 Bug report # report of problem of interaction of 'monitor' and createuser # no obvious thing to fix # patch.041 From: Jason Wright Date: Fri, 17 May 1996 05:16:12 -0400 (EDT) Subject: Re: [PG95]: Tables named In... src/bin/psql/psql.c # patch.042 From: Vivek Khera Date: Fri, 17 May 1996 10:23:26 -0400 Subject: Re: [PG95]: Postgres95 1.01 Bug report # re: patch,040 # seems fixed already # patch.043 From: Randy Kunkee Date: Mon, 20 May 1996 18:16:19 -0500 (CDT) Subject: [PG95]: Feedback on postgres95/patches for i386_solaris # already applied, needs a review though # patch.044 From: Wayde Nie Date: Wed, 22 May 1996 13:45:33 -0500 (CDT) Subject: [PG95]: External Functions. Adding to Massimo's datetime_functions code # see patch,045 # patch.045 From: Massimo Dal Zotto Date: Wed, 22 May 1996 23:20:56 +0200 (MET DST) Subject: [PG95]: Re: External Functions. Adding to Massimo's datetime_functions code... # updated 'datetime' extensions # patch.046 From: Theodore Buswell Date: Wed, 22 May 1996 18:53:01 -0400 (EDT) Subject: Re: [PG95]: security under postgres # no patches included in mail message, just reference to patches # patch.047 From: Massimo Dal Zotto Date: Mon, 27 May 1996 17:45:16 +0200 (MET DST) Subject: [PG95]: input/output conversion of string values src/backend/parser/scansup.c src/backend/commands/copy.c src/backend/utils/adt/arrayfuncs.c src/Makefile.global ext/escape/string_io.d ext/escape/string_io.sql # patch.048 From: chris@atlas.onthe.net.au (Chris Dunlop) Date: 30 May 1996 16:59:20 +1000 Subject: [PG95]: Re: FIX: 'select distinct on' backend crash src/backend/executor/nodeUnique.c # patch.049 From: chris@atlas.onthe.net.au (Chris Dunlop) Date: 7 Jun 1996 10:31:39 +1000 Subject: [PG95]: Re: Postgres95 bug report # duplicate patch = see patch,029 # make backup pg95.005.tar.gz # make clean all # ran regression, new failures with select distinct # backout patch,048 which deals with select distinct # discovered thet ESCAPE_PATCH was mispelled (patch,047) # make clean all # reran regression, same output as after dump 004 # patch.050 From: chris@atlas.onthe.net.au (Chris Dunlop) Date: 7 Jun 1996 10:40:51 +1000 Subject: [PG95]: Re: Postgres95 crash! src/backend/executor/nodeHash.c # patch.051 From: Michael Talbot-Wilson Date: Fri, 7 Jun 1996 21:02:24 +0930 (CST) Subject: Re: [PG95]: Man page # reviewed digests v01.n062 through v01.n067 which were fetched # a few days ago while in korea # patches 052 through 058 were extracted # patch.052 From: chris@atlas.onthe.net.au (Chris Dunlop) Date: 7 Jun 1996 10:31:39 +1000 Subject: [PG95]: Re: Postgres95 bug report src/backend/tcop/postgres.c src/backend/utils/error/elog.c # patch.053 From: chris@atlas.onthe.net.au (Chris Dunlop) Date: 7 Jun 1996 10:40:51 +1000 Subject: [PG95]: Re: Postgres95 crash! # same as patch,050 # patch.054 From: "Marc G. Fournier" Date: Mon, 10 Jun 1996 19:26:55 -0400 (EDT) Subject: [PG95]: getpwuid(getuid()) in fe_auth.c # searched for getuid in all *.c files src/backend/port/win32/nt.c src/bin/pg_id/pg_id.c src/bin/psql/psql.c src/libpq/fe-auth.c # changed src/bin/psql/psql.c src/libpq/fe-auth.c # patch.055 From: "David Bennett" Date: Tue, 11 Jun 1996 12:53:11 -0006 Subject: [PG95]: New version of pg_dump # TODO get: ftp://ftp.bensoft.com/pub/sql/pg95/pg_dump.113.dhb.tar.gz # patch.056 From: Michael Dutka Date: Fri, 14 Jun 1996 20:37:49 +0200 Subject: [PG95]: pg_atoi() problem on boolean f inserts during initdb src/backend/utils/adt/numutils.c # problem does not seem to exist # patch.057 From: "David Bennett" Date: Sat, 15 Jun 1996 09:01:58 -0006 Subject: [PG95]: Yet another pg_dump version... # TODO get: ftp://ftp.bensoft.com/pub/sql/pg95/pg_dump.113.dhb.2.tar.gz # see patch,055 # patch.058 From: Cees de Groot Date: Wed, 19 Jun 1996 14:47:17 +0200 Subject: [PG95]: [OpenLink] Postgres'95 patches src/backend/utils/adt/varchar.c src/backend/bootstrap/bootstrap.c src/backend/storage/file/fd.c src/backend/storage/smgr/md.c src/backend/tcop/postgres.c src/bin/initdb/initdb.sh # no more patches (at least until the next internet connection) # make backup pg95.006.tar.gz # make clean all # regression produces same results as before # review of drgeorge bug reports which never made it out of 'madmax' # copy bug.1 to patch.059 # other drgeorge bug reports have been installed # patch.059 From: Dr_George_D_Detlefsen Date: 4 Mar 1996 Subject: psql misprints \d output src/bin/psql.c # further review of i86pc port # expanded postgres95-1.01.tar.gz # compared with older x386 port # copied missing directories from postgres95 to x386 # src/backend/utils/error # src/backend/utils/sort # patch.022 (man pages) doc/man/copy.l # patch.023 (soundex) dynamic/soundex/soundex.c dynamic/soundex/soundex.sql # review of i86pc port (fixup x386 port) # POSTGRESDIR -> srcdir in src/mk/port/*.{aix,i86pc_solaris,sparc_solaris) # fetched digests 86-70 via ftp # reviewed digests 68-70 creating patches 60-64 # patch.060 From: Bruce Momjian Date: Mon, 24 Jun 1996 08:36:27 -0400 (EDT) Subject: [PG95]: psql field separator alignment src/bin/psql/psql.c # see patch.059 # patch.061 From: Bruce Momjian Date: Mon, 24 Jun 1996 09:12:05 -0400 (EDT) Subject: [PG95]: BSDI define missing from src/backend/storage/ipc/s_lock.c src/backend/storage/ipc/s_lock.c # patch.062 From: Bruce Momjian Date: Mon, 24 Jun 1996 09:25:09 -0400 (EDT) Subject: [PG95]: BSD/OS changes in 2.1 # neet more detailed information # patch.063 From: Bruce Momjian Date: Mon, 24 Jun 1996 09:32:07 -0400 (EDT) Subject: [PG95]: manual page for select doc/man/select.1 # patch.064 From: Bruce Momjian Date: Tue, 25 Jun 1996 00:45:50 -0400 (EDT) Subject: [PG95]: psql \p both prints and executes, \r missing src/bin/psql/psql.c # make backup pg95.007.tar.gz # updated PORTNAME_i86pc_solaris locking mechanism # to use the note 'port_solaris_x86' assembly code src/backend/storage/ipc/s_lock.c src/backend/port/i86pc_solaris/tas.s # removed reference to "(defined(__i386__) && defined(__GNUC__))" src/backend/storage/ipc.h # to matching references to 'linux', 'BSD44_derived', and 'bsdi' src/backend/storage/ipc/s_lock.c # adjusted the padding to compensate for explicit TEST_AND_SET portnames src/backend/storage/buf_internals.h # NEEDS checking on various architectures # make clean all # run regression test, same results # make backup pg95.008.tar.gz # patch.003 (the big one) From: Julian Assange Date: Tue, 27 Feb 1996 06:29:04 +1100 (EST) Subject: [PG95]: psql/monitor/libpq enhancements (now does html3, alignment, pipes etc) src/bin/psql/psql.c src/bin/monitor/monitor.c src/libpq/fe-exec.c src/libpq/libpq-fe.h #make backup copies before applying patch #patch < patch.003 failed miserably #do the patch by hand src/bin/psql/psql.c src/bin/monitor/monitor.c -- left alone using PQdisplayTuples src/libpq/fe-libpq.c -- did not delete PQdisplayTuples and helpers src/libpq/libpq-fe.h -- did not delete PQdisplayTuples and helpers # make all # can not compile new psql as PGprintOpt doesnot work # made 2 versions of psql # psql is original # psql1 has patch,003 src/bin/psql/psql.c src/bin/psql1/psql.c doc/man/psql.1 doc/man/psql1.1 # default compiles original, new is compiled by 'cd src/bin/psql1; make' # scan of all files containing "PORTNAME" # look for i386 dependencencies, for i96pc_solaris, missed before # collected 1 byte slock_t pad into one #if defined(...) src/backend/storage/buf_internals.h #normalized all lists of PORTNAME_* into alphabetical order src/backend/storage/ipc.h src/backend/storage/buf_internals.h src/backend/storage/ipc/s_lock.c src/backend/utils/adt/misc.c src/backend/utils/adt/nabstime.c src/backend/utils/exc.h # investigated ports to solaris x86 # 1) port_solaris_x86 # pg95-1.01 fails at 'QUERY: SELECT * from street;' # 'QUERY: SELECT * from iexit;' # too much data # pg96-1.0 also fails at same point # floating point values seem different in some points # pg95/BAK/pg95-1.0.sparc.1.tar.gz # 2) patch.031 # expanded postgres95-1.01.tar.gz # applied patch.031 # edited POSTGRESDIR and SRCDIR # make # clean postgres home directory # make install # initdb # run regression # 'QUERY: SELECT * from street;'and 'QUERY: SELECT * from iexit;' # produce less output than expected. # applied public patches 001 and 002 # make # clean postgres home directory # make install # initdb # run regression # 'QUERY: SELECT * from street;'and 'QUERY: SELECT * from iexit;' # produce less output than expected. # recompiled current patched version # make # clean postgres home directory # make install # initdb # run regression # 'QUERY: SELECT * from street;'and 'QUERY: SELECT * from iexit;' # twice as much data as expexted # 3) patch,043 # expanded postgres95-1.01.tar.gz # applied patch.043 # edited POSTGRESDIR and SRCDIR # --> this port does not use 'spinlocks' # make # fixed ) in line 41 src/backend/ipc/ipc.h # run regression # 'QUERY: SELECT * from street;'and 'QUERY: SELECT * from iexit;' # still problems # fetched digests 071-073 # reviewed new digests # reviewed digests 71-73 creating patches 65-69 # further investigation of: # 'QUERY: SELECT * from street;'and 'QUERY: SELECT * from iexit;' # remade *.i86pc without optimization and with debug (-g) # is it a gcc optimization problem ??? # reviewed all warnings from gcc # edited following files /src/backend/parser/scan.l:89: warning: passing arg 1 of `pstrdup' makes pointer from integer without a cast /src/backend/optimizer/path/orindxpath.c:237: warning: cast to pointer from integer of different size src/backend/optimizer/util/clauseinfo.c:106: warning: cast to pointer from integer of different size src/backend/optimizer/util/clauseinfo.c:150: warning: cast to pointer from integer of different size src/backend/optimizer/util/clauseinfo.c:154: warning: cast to pointer from integer of different size src/backend/optimizer/util/plancat.c:327: warning: cast to pointer from integer of different size src/backend/optimizer/util/plancat.c:366: warning: cast to pointer from integer of different size src/backend/optimizer/util/plancat.c:368: warning: cast to pointer from integer of different size src/backend/rewrite/rewriteManip.c:322: warning: passing arg 2 of `FindMatchingTLEntry' from incompatible pointer type src/backend/rewrite/rewriteSupport.c:70: NO CHANGE warning: cast from pointer to integer of different size # make all # run regression # same problems as before # check rest of warnings from gcc src/backend/utils/adt/selfuncs.c:{383,425,487,548}: warning: cast to pointer from integer of different size src/backend/utils/cache/relcache.c:(650,654,658}: NO CHANGE warning: cast from pointer to integer of different size # fetched digests 074-076 # reviewed new digests # reviewed digests 74-76 creating patches 70-74 # apply patches 65 and up # patch.065 From: Erich Stamberger Date: Mon, 1 Jul 1996 00:43:26 +0100 (GMT+0100) Subject: [PG95]: BUGREP/Fix: Typos in libpq src/libpq/fe-connect.c # patch.066 From: Erich Stamberger Date: Wed, 3 Jul 1996 11:42:16 +0100 (GMT+0100) Subject: [PG95]: BUGREP/Fix: libpq: Two memory leaks src/libpq/fe-connect.c # patch.067 From: Bruce Momjian Date: Fri, 5 Jul 1996 08:51:02 -0400 (EDT) Subject: [PG95]: patch for BSD/OS(BSDI) 2.1 src/Makefile.global src/backend/bootstrap/bootstrap.c src/backend/optimizer/path/costsize.c src/backend/port/bsdi_2_1/Makefile.inc src/backend/port/bsdi_2_1/machine.h src/backend/port/bsdi_2_1/port-protos.h src/backend/port/bsdi_2_1/port.c src/backend/postmaster/postmaster.c src/backend/storage/ipc/s_lock.c src/backend/utils/Gen_fmgrtab.sh src/backend/utils/adt/misc.c src/backend/utils/adt/numutils.c src/backend/utils/error/elog.c src/backend/utils/error/exc.c src/mk/port/postgres.mk.bsdi_2_1 # patch.068 From: Bruce Momjian Date: Sun, 7 Jul 1996 12:21:34 -0400 (EDT) Subject: [PG95]: reference manual source problems # DEFERRED # patch.069 From: System Administrator Date: Sun, 7 Jul 1996 13:19:28 -0400 (EDT) Subject: Re: [PG95]: createuser problem: more information # NOT a PROBLEM on i86pc_solaris # SHOULD WE CONVERT all utilities to PSQL ??? # AND DROP monitor # patch.070 From: Michael Talbot-Wilson Date: Mon, 8 Jul 1996 11:46:42 +0930 (CST) Subject: Re: [PG95]: reference manual source problems # DEFERRED check all man page patches # patch.071 From: Andrew Sapozhnikov Date: Mon, 8 Jul 1996 14:33:53 +0600 (ESD) Subject: [PG95]: textcat(text,text) bug found. Patch inside. src/backend/utils/adt/varlena.c # patch.072 From: Bruce Momjian Date: Mon, 8 Jul 1996 21:51:50 -0400 (EDT) Subject: Re: [PG95]: reference manual source problems # DEFERRED check all man page patches # has shell/sed script to convert man page macros # patch.073 From: Bruce Momjian Date: Tue, 9 Jul 1996 22:36:20 -0400 (EDT) Subject: [PG95]: My postgres interface library: source attached # SEE patch,074 for update # patch.074 From: Bruce Momjian Date: Wed, 10 Jul 1996 13:52:47 -0400 (EDT) Subject: [PG95]: Re: pginterface src/pginsert src/pginsert/Makefile src/pginsert/halt.c src/pginsert/halt.h src/pginsert/pginsert.c src/pginsert/pginterface.c src/pginsert/pginterface.h # NEEDS MASSAGE for PG95 makefile system # created directory 'src/extend' for extensions such as 'pginsert' (patch,074) # and the dymanic loadables. This directory needs to be integrated # into the overall makefile system # replaced pg_dump with one from: # ftp://ftp.bensoft.com/pub/sql/pg95/pg_dump.113.dhb.tar.gz # saved pg_dump as pg_dump.0 # make all # review all man page patches 10, 22, 51, 70, 72 # massaged man pages with script from various patchs #! /bin/sh cd man_0 for X in * do sed \ -e 's/^\.(C/.nf/' \ -e 's/^\.)C/.fi/' \ -e 's/\\\*(PG/Postgres95/g' \ -e 's/\\\*(PQ/SQL/g' \ -e 's/\\\*(UU/Unix/g' \ -e 's/\\\*(LI/Libpq/g' \ < $X > ../man/$X done # original files are in doc/man_0 directory # massaged the .TH lines to add Postgres95 as header and left footer # changed COMMANDS to SQL in .TH lines # changed (commands) to (SQL) in the bodies of the man pages # the result formats reasonably well using the 'man' command in Solaris # use the MANPATH environment variable to point to POSTMANDIR # I need to learn more about man page formating and simplifications of # updated 'bug.template' to request executable shell script to illustrate # the problem and to request 'diff -u' format for fixes. # RELEASE alpha 1 = postgres95-1.02.a1.tar.gz # patch.075 From: "Paul 'Shag' Walmsley" Date: Thu, 11 Jul 1996 00:38:23 -0500 (CDT) Subject: Re: [PG95]: Backend process has died unexpectedly... # see revised version in patch.076 # patch.076 From: "Paul 'Shag' Walmsley" Date: Thu, 11 Jul 1996 02:07:54 -0500 (CDT) Subject: Re: [PG95]: Backend process has died unexpectedly... src/libpq/fe-exec.c # patch.077 From: "Paul 'Shag' Walmsley" Date: Thu, 11 Jul 1996 03:02:44 -0500 (CDT) Subject: [PG95]: Another libpq robustness patch for the adventurous src/libpq/fe-connect.c # patch.078 From: Andrew Martin Date: Thu, 11 Jul 1996 12:20:45 +0100 Subject: [PG95]: [PATCH] Fix the problems with create/destroy user/db src/bin/createuser/createuser.sh src/bin/destroyuser/destroyuser.sh src/bin/createdb/createdb.sh src/bin/destroydb/destroydb.sh # may be moot, see patch.009 # do it any way, can't hurt # make clean all # run regression test # search digests for possible corrections for patch.003 to 'psql' # find one -> patch.079 # patch.079 From: Julian Assange Date: Wed, 28 Feb 1996 15:38:22 +1100 (EST) Subject: Re: [PG95]: psql/monitor/libpq enhancements (now does html3, alignment, pipes etc) src/bin/psql_1/psql.c ---- YET TODO ---- debug the patch,003 merge from pg95-1.0 source 'psql1' patch,030 add other SYS_ functions, see SQL-92 patch,033 where x = NULL, see SQL-92 find internationalized regex routines make review of i86pc port create makefile structure for extension directories convert all shell script utilties to 'psql' and drop 'monitor' man page formatting with conventional macros