OSDN Git Service
Bruce Momjian [Thu, 12 Jun 1997 16:43:08 +0000 (16:43 +0000)]
Update psql EXPLAIN help description, from Thomas.
Vadim B. Mikheev [Thu, 12 Jun 1997 15:41:52 +0000 (15:41 +0000)]
Someone forgot about aligning in fastgetiattr()...
Vadim B. Mikheev [Thu, 12 Jun 1997 15:39:44 +0000 (15:39 +0000)]
Datum *idatum;
^
Bruce Momjian [Wed, 11 Jun 1997 14:57:39 +0000 (14:57 +0000)]
Update docs for release.
Vadim B. Mikheev [Wed, 11 Jun 1997 05:20:05 +0000 (05:20 +0000)]
Compare 'char' and 'text' lexicographically.
Vadim B. Mikheev [Wed, 11 Jun 1997 05:18:02 +0000 (05:18 +0000)]
Lexicographically compare 'char' and 'text'.
Vadim B. Mikheev [Wed, 11 Jun 1997 02:44:12 +0000 (02:44 +0000)]
geqo_rel_paths(): compute_joinrel_size() shouldn't be called
for non-JoinPath path! So now we have:
if ( IsA_JoinPath (cheapest) )
rel->size = compute_joinrel_size(cheapest);
Marc G. Fournier [Wed, 11 Jun 1997 01:14:49 +0000 (01:14 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PORTS] Makefile.aix patch.
Have to add libc.a to the link when making a shared lib.
Marc G. Fournier [Wed, 11 Jun 1997 01:13:10 +0000 (01:13 +0000)]
From: Robert Bruccoleri <bruc@bms.com>
Subject: [PORTS] Patches for Irix 6.4
I have worked out how to compile PostgreSQL on Irix 6.4 using the -n32 compiler
mode and version 7.1 of the C compiler. (The n32 compiler use 32 bits
addressing,
but allows access to all the instructions in the MIPS4 instruction set.)
There were several problems:
1) The ld command is not referenced as a macro in all the Makefiles. On
this platform, you have to include -n32 on all the ld commands. Makefiles
were changed as needed.
3) Lots of warnings are generated from the compiler. Since the regression
tests worked OK, I didn't attempt to fix them. If anyone wants the compilation
log, please let me know, and I'll email it to you.
The version of postgresql was 970602. Here is Makefile.custom:
CUSTOM_COPT = -O2 -n32
MK_NO_LORDER = 1
LD = ld -n32
CC += -n32
Marc G. Fournier [Wed, 11 Jun 1997 01:05:48 +0000 (01:05 +0000)]
From: "Brian E. Gallew" <geek+@cmu.edu>
Subject: Re: [PORTS] Re: [PATCHES] DG/UX 5.4R11 patches
Comments in boot.sed break DG/UX port
Marc G. Fournier [Wed, 11 Jun 1997 01:03:38 +0000 (01:03 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] sequences display in psql
Well, I am away at Progress training (not Postgres!!) and desided to do
this patch during a break. This will allow listing of sequences in
addition to listing of tables and indicies:
\d would should indicies, tables, and sequences
\ds would show sequences only.
Marc G. Fournier [Wed, 11 Jun 1997 01:02:01 +0000 (01:02 +0000)]
From: "Eric H. Raskin" <ehr@listworks.com>
Subject: [PATCHES] DG/UX 5.4R11 patches
1) config.guess -- it doesn't understand that the new default
"TARGET_BINARY_INTERFACE" (m88kdgux) is now an ELF
format, not BCS.
Bruce Momjian [Tue, 10 Jun 1997 13:01:32 +0000 (13:01 +0000)]
LO patches for loimport/loexport from Raymond Toy
Vadim B. Mikheev [Tue, 10 Jun 1997 07:55:47 +0000 (07:55 +0000)]
if ( rel->size <= 0 )
rel->size = compute_rel_size(rel);
Vadim B. Mikheev [Tue, 10 Jun 1997 07:53:55 +0000 (07:53 +0000)]
if ( new_rel->size <= 0 )
new_rel->size = compute_rel_size(new_rel);
Vadim B. Mikheev [Tue, 10 Jun 1997 07:28:50 +0000 (07:28 +0000)]
Duplicates handling...
Bruce Momjian [Sat, 7 Jun 1997 18:43:50 +0000 (18:43 +0000)]
Update docs for release.
Bruce Momjian [Sat, 7 Jun 1997 17:34:35 +0000 (17:34 +0000)]
Cleanup on xinv# table names.
Bruce Momjian [Sat, 7 Jun 1997 05:29:22 +0000 (05:29 +0000)]
Make LO patter consistent with psql.
Bruce Momjian [Sat, 7 Jun 1997 05:19:06 +0000 (05:19 +0000)]
avoid xinv* table name conflict with large objects.
Marc G. Fournier [Sat, 7 Jun 1997 03:42:17 +0000 (03:42 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Subject: [PATCHES] Patch for INSTAL file.
The following patch does the following:
- In step 6, recommend doing a database backup if you are upgrading
from any version of the release, rather than ones before a specific
date.
- Added step 22a on regular maintainence.
Marc G. Fournier [Fri, 6 Jun 1997 22:08:04 +0000 (22:08 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] destroydb.1 patch
This is a patch to destroydb man page so that it shows and explains "-i"
option.
Marc G. Fournier [Fri, 6 Jun 1997 22:05:23 +0000 (22:05 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] psql and large objects fix
Psql was broken by using "Inv[0-9]+" instead of "xin[xv][0-9]+" to not
show large object files. Been this way for a long time too. Relic of
an older naming convention, perhaps?
Marc G. Fournier [Fri, 6 Jun 1997 22:04:04 +0000 (22:04 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [PATCHES] backend/storage/ipc/shmem.c
- strname is only used if assert checking is on
Marc G. Fournier [Fri, 6 Jun 1997 22:02:37 +0000 (22:02 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [PATCHES] backend/lib/fstack.c
- The FixedStackIsValid so obviously needs to be a macro
- FixedStackContains only called if assert checking on
Thomas G. Lockhart [Fri, 6 Jun 1997 06:13:10 +0000 (06:13 +0000)]
Change one date away from PST to avoid trouble after daylight savings time.
Thomas G. Lockhart [Fri, 6 Jun 1997 06:05:53 +0000 (06:05 +0000)]
Change one date away from PST to avoid trouble after daylight savings time.
Bruce Momjian [Fri, 6 Jun 1997 03:41:16 +0000 (03:41 +0000)]
lowercase large object table name fix.
Vadim B. Mikheev [Fri, 6 Jun 1997 03:18:02 +0000 (03:18 +0000)]
gimme_tree(): got rid of compute_rel_size() -
compute_joinrel_size already called by geqo_rel_paths.
Vadim B. Mikheev [Fri, 6 Jun 1997 03:11:46 +0000 (03:11 +0000)]
Added check is new item successfuly inserted to a page or not.
Marc G. Fournier [Fri, 6 Jun 1997 01:42:02 +0000 (01:42 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] More psql and libpq patches
Well..these would be the last patches until the release (I hope)...
I ran the regression tests while watching psql under purify, and it did
not leak even one byte.
In this patch:
* Plugged a major leak when PSQL reads files for input (either through
\i options or through -f option)
* Fixed the one remaining leak in PSQL in not clearing PGresult *results
everywhere it is supposed to. (Thanks Tymm)
* Fixed A small leak in PSQL not clearing all the PGsettings correctly.
* A not-so-obvious (but small) leak in Libpq when PQsetdb fails for any
reason.
* Added \n to some Libpq error messages to make them easier to digest..
* Finally, added /* PURIFY */ comment to some of the code indicating
the reason for why it was added/changed...for future developers.
Marc G. Fournier [Fri, 6 Jun 1997 01:39:24 +0000 (01:39 +0000)]
From: "Brian E. Gallew" <geek+@cmu.edu>
Define USE_POSIX_TIME for dgux port
Marc G. Fournier [Fri, 6 Jun 1997 01:38:24 +0000 (01:38 +0000)]
From: Phil Nelson <phil@cs.wwu.edu>
Subject: [PATCHES] Patches to allow generic NetBSD support
Marc G. Fournier [Fri, 6 Jun 1997 01:37:23 +0000 (01:37 +0000)]
From: Phil Nelson <phil@cs.wwu.edu>
Subject: [PATCHES] Added support for NetBSD/pc532.
Marc G. Fournier [Fri, 6 Jun 1997 01:35:57 +0000 (01:35 +0000)]
From: PortSite <info@portsite.nl>
The GNUmakefile in src/test/regress uses `gmake' for
the make program. This should be $(MAKE)
Marc G. Fournier [Fri, 6 Jun 1997 01:34:59 +0000 (01:34 +0000)]
From: PortSite <info@portsite.nl>
Install file says: Type flex -- version
There is a space between -- and version that shouldn't
be there :-(
Marc G. Fournier [Fri, 6 Jun 1997 00:38:17 +0000 (00:38 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [HACKERS] src.original/./backend/lib/fstack.c
Another change I suggested. I bracket an unused function and add a
return to quiet the compiler. In addition I added an internal
consistency check.
Marc G. Fournier [Fri, 6 Jun 1997 00:37:23 +0000 (00:37 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [HACKERS] backend/optimizer/geqo/geqo_erx.c
I sent these changes in with a bunch of others. Some were folded in but
others, like these, were not. I am not sure why so I am resending this
to the developers list by itself for discussion.
The readon why I suggest these changes is that the compiler can't tell
that minimum_count is initialized before it is used. The tests that I
add in here will cause an immediate error if it doesn't. As the comments
below suggest, if it is 100% guaranteed that the variable will always
be initialized then how this is so should be commented here. I don't
know how much strain the actual test puts on the performance but if it
isn't too much then maybe leave it in for absolute safety anyway.
There are also a few returns just to stop warnings.
Bruce Momjian [Thu, 5 Jun 1997 22:59:45 +0000 (22:59 +0000)]
Fix for large objects and case sensitivity, from Raymond Toy.
Bruce Momjian [Thu, 5 Jun 1997 17:36:43 +0000 (17:36 +0000)]
bsdi configure detection fix.
Vadim B. Mikheev [Thu, 5 Jun 1997 09:33:52 +0000 (09:33 +0000)]
allpaths.c:find_join_paths(): compute_rel_size() shouldn't be called
for join-relations. Sizes already computed by
prune_rel_paths():compute_joinrel_size().
joinrels.c:
< if ( _use_right_sided_plans_ )
---
> if ( _use_right_sided_plans_ &&
> length (outer_rel->relids) > 1 )
- r_plans are useful when outer_rel is join-relation... It
decreases the size of search space...
Vadim B. Mikheev [Wed, 4 Jun 1997 09:01:49 +0000 (09:01 +0000)]
Definition for RelationForgetRelation().
Vadim B. Mikheev [Wed, 4 Jun 1997 08:59:22 +0000 (08:59 +0000)]
heap_destroy() now calls RelationForgetRelation() to really flush
the relation from the relcache.
Vadim B. Mikheev [Wed, 4 Jun 1997 08:56:51 +0000 (08:56 +0000)]
New func RelationForgetRelation();
* RelationFlushRelation + if the relation is local then get rid of
* the relation descriptor from the newly created relation list.
Bruce Momjian [Tue, 3 Jun 1997 20:36:48 +0000 (20:36 +0000)]
UPdate TODO/HISTORY again.
Bruce Momjian [Tue, 3 Jun 1997 20:29:57 +0000 (20:29 +0000)]
Update TODO for release
Bruce Momjian [Tue, 3 Jun 1997 20:08:06 +0000 (20:08 +0000)]
Add bsdi to template detection.
Thomas G. Lockhart [Tue, 3 Jun 1997 15:25:45 +0000 (15:25 +0000)]
Update comments for regression testing.
Include paragraph on upgrading old databases containing path or polygon types.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:34:51 +0000 (14:34 +0000)]
Use error message syntax consistant with other messages from the same
reference platform (Linux/gcc-lib/i686).
Thomas G. Lockhart [Tue, 3 Jun 1997 14:31:46 +0000 (14:31 +0000)]
Update to reflect new "drop aggregate" syntax and messages.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:29:51 +0000 (14:29 +0000)]
Update to show new path and polygon syntax.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:24:12 +0000 (14:24 +0000)]
Update path and polygon syntax to new conventions.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:21:36 +0000 (14:21 +0000)]
Update to use new path geometric type syntax.
Order in streets.data changed and is now alphabetical (sorry).
Thomas G. Lockhart [Tue, 3 Jun 1997 14:19:28 +0000 (14:19 +0000)]
Modify banner to suggest using PST8PDT time zone rather than full specifier
string.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:18:38 +0000 (14:18 +0000)]
Update to suggest using PST8PDT time zone rather than full time zone string.
Include section on error message differences.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:11:28 +0000 (14:11 +0000)]
Add upgradepath(), isoldpath(), upgradepoly() and revertpoly() to allow
upgrading from existing pre-v6.1 path and polygon geometric data types.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:07:24 +0000 (14:07 +0000)]
Put parens around macro arguments for safety per D'Arcy's suggestion.
Thomas G. Lockhart [Tue, 3 Jun 1997 14:01:22 +0000 (14:01 +0000)]
Add upgradepath(), isoldpath(), upgradepoly() and revertpoly() to allow
migration from pre-v6.1 geometric data types.
Only allow new input syntax for paths and polygons.
Thomas G. Lockhart [Tue, 3 Jun 1997 13:58:06 +0000 (13:58 +0000)]
Use finite() macro if available to check returns from pow() and exp().
Thomas G. Lockhart [Tue, 3 Jun 1997 13:56:32 +0000 (13:56 +0000)]
Fix a few DATEDEBUG print statements.
Vadim B. Mikheev [Tue, 3 Jun 1997 06:32:56 +0000 (06:32 +0000)]
cc1: warnings being treated as errors
dt.c: In function `timespan2tm':
dt.c:1722: warning: unused variable `funit'
dt.c:1722: warning: unused variable `iunit'
-> got rid of them.
Vadim B. Mikheev [Tue, 3 Jun 1997 06:29:31 +0000 (06:29 +0000)]
SET geqo TO 'on' restores _use_geqo_rels_ to GEQO_RELS, not
to last specified with 'on' #.
What is better ?
Vadim B. Mikheev [Tue, 3 Jun 1997 06:23:24 +0000 (06:23 +0000)]
cc1: warnings being treated as errors
remove.c: In function `RemoveAggregate':
remove.c:413: warning: unused variable `typename'
-> got rid of it.
Vadim B. Mikheev [Tue, 3 Jun 1997 06:19:11 +0000 (06:19 +0000)]
SET var TO '...'
^^ - added
Vadim B. Mikheev [Tue, 3 Jun 1997 06:17:34 +0000 (06:17 +0000)]
cc1: warnings being treated as errors
psql.c: In function `HandleSlashCmds':
psql.c:1141: warning: `optarg3' might be used uninitialized in this function
psql.c:1157: warning: `optarg3' might be used uninitialized in this function
-> char *optarg3 = NULL;
Vadim B. Mikheev [Tue, 3 Jun 1997 04:14:31 +0000 (04:14 +0000)]
Cleanups.
Bruce Momjian [Tue, 3 Jun 1997 03:35:46 +0000 (03:35 +0000)]
Add \dt and \di to psql help.
Vadim B. Mikheev [Tue, 3 Jun 1997 03:19:08 +0000 (03:19 +0000)]
New description of currval.
Vadim B. Mikheev [Tue, 3 Jun 1997 03:15:50 +0000 (03:15 +0000)]
#define GEQO_RELS 6 (not 7)
Vadim B. Mikheev [Tue, 3 Jun 1997 01:29:26 +0000 (01:29 +0000)]
Fix deleted tuples re-incarnation possible when vacuum transaction
start time equal to tuple->t_tmax.
Privent shrinking if there are tuples modifyed by running transactions
(it concerns system relations only, currently).
Edmund Mergl [Mon, 2 Jun 1997 19:42:14 +0000 (19:42 +0000)]
*** empty log message ***
Bruce Momjian [Mon, 2 Jun 1997 14:12:40 +0000 (14:12 +0000)]
Update man and psqlHelp for new SET GEQO=# option.
Bruce Momjian [Mon, 2 Jun 1997 13:55:19 +0000 (13:55 +0000)]
Allow for EOF or \0 as input() return from lex.
Vadim B. Mikheev [Mon, 2 Jun 1997 11:22:52 +0000 (11:22 +0000)]
Oracle like currval behaviour.
Vadim B. Mikheev [Mon, 2 Jun 1997 11:19:33 +0000 (11:19 +0000)]
#define GEQO_RELS 7
moved from geqo.h to internal.h.
Vadim B. Mikheev [Mon, 2 Jun 1997 11:14:40 +0000 (11:14 +0000)]
Use GEQO if _use_geqo_ is TRUE and # of relations is >= _use_geqo_rels_
(both are settable via SET geqo TO ...).
Vadim B. Mikheev [Mon, 2 Jun 1997 11:00:57 +0000 (11:00 +0000)]
SET var TO 'a=b'
^^ is supported by get_token now.
(SET geqo TO 'on=XXX' works now).
Marc G. Fournier [Mon, 2 Jun 1997 03:04:50 +0000 (03:04 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] patch for a memory leak
Well...I screwed up and posted the wrong patch for psql originally..
The patch for that patch wposted below will fix it..
Marc G. Fournier [Mon, 2 Jun 1997 03:02:43 +0000 (03:02 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Subject: [PATCHES] INSTALL patch
This patch makes the following changes to the INSTALL instructions:
- Before step 1, describe disk space requirements.
- Step 1 now defines a "tested" platform.
- Add step 3a on checking for disk space.
- Added new step 27 asking for feedback.
Marc G. Fournier [Mon, 2 Jun 1997 02:53:00 +0000 (02:53 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] Another destroydb patch
This is a patch to my previous destroydb patch cause some people wanted
slightly different behavior. After this patch is applied, destroydb
will destroy a database as usual, but if added -i flag (which could be
aliased like rm -i) would ask for confirmation.
Marc G. Fournier [Mon, 2 Jun 1997 02:52:06 +0000 (02:52 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] pg_dump memory leak patch
This patch fixes a HUGE memory leak problem in pg_dump.
Pretty much anything that was allocated was never freed and Purify
reported about 40% possible memory leak and 6% actual leak. I added
functions to clear out all the allocated structures. After the patch
Purify returns 0 for number of bytes leaked...
Marc G. Fournier [Sun, 1 Jun 1997 16:25:34 +0000 (16:25 +0000)]
Ordering of libraries changed so that -lbsd is *after* -lm
Fixes a problem Darren reports with AIX, and doesn't seem to break either
FreeBSD or Linux(David?)...
Marc G. Fournier [Sun, 1 Jun 1997 15:53:24 +0000 (15:53 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] psql - \dt,\di commands.
I sent this a couple of months ago in re a request by Maxim
Kozin, but I had the patch reversed, creating some confusion
over applying it.
Here's a more complete version.
Adds \dt to list only tables/views and \di to list only
indicies. \d will still work as before.
Marc G. Fournier [Sun, 1 Jun 1997 15:51:10 +0000 (15:51 +0000)]
From: Phil Nelson <phil@cs.wwu.edu>
Subject: [PATCHES] Support for NetBSD/sparc
The following is a patch to allow BSD44_derived to support NetBSD/sparc.
Marc G. Fournier [Sun, 1 Jun 1997 15:50:08 +0000 (15:50 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] aix.h needs POSIX...
Marc G. Fournier [Sun, 1 Jun 1997 15:41:40 +0000 (15:41 +0000)]
From: Robert Bruccoleri <bruc@bms.com>
One more Irix related patch for Dynamic Linking
Marc G. Fournier [Sun, 1 Jun 1997 15:40:08 +0000 (15:40 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] destroydb patch
I am including a patch for destroydb to ask for confirmation before
deleting databases (after I accidentally deleted mine)...destroydb -y
would force delete without any confirmation.
Marc G. Fournier [Sun, 1 Jun 1997 15:39:08 +0000 (15:39 +0000)]
From: Igor <igor@sba.miami.edu>
Subject: [PATCHES] memory leak patches in libpq and psql
A couple of small memory leak patches (detected with Purify) primarily
in libpq.
* Fixed (NULL) border problem in psql (run psql, do \m, then select
something from a table...row separators will be nulls)
* Fixed memory leak with the abovementioned border not being freed
properly.
* Fixed memory leak in freePGconn() not freeing conn->port
* Fixed up PQclear() to free parts of PGresult only if these
parts are not null.
* Fixed a decent memory leak that occured after executing every command
in psql. PGresult *results was not freed most of the time.
There is still a leak being detected (2 bytes) in readline functions, but
I think this is old readline library. I will install new one and test it.
Bruce Momjian [Sun, 1 Jun 1997 04:59:25 +0000 (04:59 +0000)]
Added \n to error message.
Bruce Momjian [Sun, 1 Jun 1997 04:53:44 +0000 (04:53 +0000)]
Add R_PLANS to psql help, and SET cleanup.
Bruce Momjian [Sun, 1 Jun 1997 04:32:41 +0000 (04:32 +0000)]
DROP agg psql help change from Darren.
Bruce Momjian [Sun, 1 Jun 1997 04:23:12 +0000 (04:23 +0000)]
SET R_PLANS added to manual page.
Bruce Momjian [Sun, 1 Jun 1997 04:16:16 +0000 (04:16 +0000)]
Put back old lines.
Bruce Momjian [Sun, 1 Jun 1997 04:05:26 +0000 (04:05 +0000)]
Add bsdi 3.0 to configure.
Bruce Momjian [Sun, 1 Jun 1997 03:39:28 +0000 (03:39 +0000)]
Cleanup for AIX from Darren.
Bruce Momjian [Sun, 1 Jun 1997 03:18:32 +0000 (03:18 +0000)]
Escape newline in select output, from A. Duursma.
Bruce Momjian [Sun, 1 Jun 1997 02:56:00 +0000 (02:56 +0000)]
Enable GEQO for more than six tables, from Martin.
Bruce Momjian [Sun, 1 Jun 1997 02:30:25 +0000 (02:30 +0000)]
Changed 1943 to 1947 to fix, other cleanups.
Bruce Momjian [Sat, 31 May 1997 16:52:19 +0000 (16:52 +0000)]
Fix for SELECT * INTO TABLE for char(), varchar() fields.
Vadim B. Mikheev [Sat, 31 May 1997 07:10:25 +0000 (07:10 +0000)]
If there is no table in RangeTable for colname then
elog (WARN, "attribute %s not found", colname);