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);
Vadim B. Mikheev [Sat, 31 May 1997 06:35:56 +0000 (06:35 +0000)]
If we have to split leaf page in the chain of duplicates
then we try to look at our right sibling first, but not farther,
as it was in yesterday fix.
Vadim B. Mikheev [Fri, 30 May 1997 18:40:02 +0000 (18:40 +0000)]
Added: new BTP_CHAIN flag (if hikey == firstkey then it's not
last page in chain of duplicates).
Vadim B. Mikheev [Fri, 30 May 1997 18:35:40 +0000 (18:35 +0000)]
Fix duplicates handling.
Thomas G. Lockhart [Fri, 30 May 1997 15:02:51 +0000 (15:02 +0000)]
Clean up support for USE_POSIX_TIME, ! HAVE_INT_TIMEZONE machines.
Remove references to modf() which is buggy on some platforms (Sparc/Linux).
Thomas G. Lockhart [Mon, 26 May 1997 16:55:23 +0000 (16:55 +0000)]
Ensure double alignment for time and arrays of circles.
Marc G. Fournier [Mon, 26 May 1997 00:43:41 +0000 (00:43 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Subject: [PATCHES] INSTALL changes
This patch modifies the INSTALL file. The changes are:
- SPARC/Linux-ELF was added to the list of supported platforms.
The special notes for it at the bottom of the file were removed.
- Changed "database server" to "RDBMS database server".
- Modified step 6 so that when you restore your database the
tables will be owned by the original owners instead of the
postgresql superuser.
- Modified step 19 on diagnosing the regression tests for the
SPARC Linux platform with a beta release.
- Other minor changes.
Marc G. Fournier [Mon, 26 May 1997 00:26:56 +0000 (00:26 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Subject: [PATCHES] pqcomprim.c patch
This is the patch by Robert Bruccoleri to fix the endian problem.
(Actually, it's the reverse of his patch. He must have gotten the
order wrong.)
Marc G. Fournier [Sun, 25 May 1997 15:37:15 +0000 (15:37 +0000)]
-m <arg> -M weren't setup properly in getopts()...
These are undocumented in the man pages though...should they be removed?
Reported by: "A. Duursma" <it@portsite.nl>
Bruce Momjian [Sat, 24 May 1997 14:38:05 +0000 (14:38 +0000)]
Fix core dump on \c.
Bruce Momjian [Sat, 24 May 1997 01:45:17 +0000 (01:45 +0000)]
Fix \c option after breaking it.
Thomas G. Lockhart [Fri, 23 May 1997 05:24:53 +0000 (05:24 +0000)]
Clean up redundant tests for valid pointers in geometric types.
Fix up decoder field masks for timespan and reltime.
Thomas G. Lockhart [Fri, 23 May 1997 05:10:03 +0000 (05:10 +0000)]
Enable new date and time definitions to allow Solaris and Irix -O2 compilation.
Move date and time field type labels to less than 32 to allow use as masks.
Vadim B. Mikheev [Fri, 23 May 1997 02:56:48 +0000 (02:56 +0000)]
AllocateFile():
fdleft = pg_nofile() - allocatedFiles - nfile;
looks more realistic, but too noisy -
fdleft = pg_nofile() - allocatedFiles;
restored.
Bruce Momjian [Fri, 23 May 1997 01:53:42 +0000 (01:53 +0000)]
Only free memory if environment value is replaced.
Bruce Momjian [Fri, 23 May 1997 00:20:20 +0000 (00:20 +0000)]
Comment on fix added.
Bruce Momjian [Thu, 22 May 1997 23:57:27 +0000 (23:57 +0000)]
Preserve putenv() memory in psql \connect user fix.
Bruce Momjian [Thu, 22 May 1997 18:55:40 +0000 (18:55 +0000)]
Fix backslash commands broken when \connect user added.
Vadim B. Mikheev [Thu, 22 May 1997 17:24:20 +0000 (17:24 +0000)]
RelationPurgeLocalRelation():
/*
* RelationFlushRelation () below will flush relation information
* from the cache. We must call smgrclose to flush relation
* information from SMGR & FMGR, too. We assume that for temp
* relations smgrunlink is already called by heap_destroyr
* and we skip smgrclose for them. - vadim 05/22/97
*/
smgrclose(reln->rd_rel->relsmgr, reln);
- it avoids memory leaks in SMGR & VFD.
RelationFlushRelation():
there is no more call FileInvalidate(RelationGetSystemPort(relation));
- invalid (FileInvalidate() expects File, not SMGR' fd)
- unuseful anyway.
Vadim B. Mikheev [Thu, 22 May 1997 17:08:35 +0000 (17:08 +0000)]
1. Fix md memory leak:
mdunlink() and mdclose() (too !!!) now free MdfdVec for relation
and add it to free list, so it may be re-used for another relation
later.
2. Fix VFD-manager memory leak (found by Massimo ... and me):
mdunlink() has to call FileUnlink() to free allocation for fileName
and add the Vfd slot to the free list.
Vadim B. Mikheev [Thu, 22 May 1997 16:51:19 +0000 (16:51 +0000)]
1. Cleanup (no more FreeFd - unuseful; others).
2. FreeFile() has to do nothing with nfile (# of files opened
by VFD manager).
Vadim B. Mikheev [Thu, 22 May 1997 16:09:57 +0000 (16:09 +0000)]
gist.h:
/*
** You can have as many strategies as you please in GiSTs, as
** long as your consistent method can handle them
*/
#define GISTNStrategies 100
^^^
- too big number:
strat.h->StrategyEvaluationData->StrategyExpression expression[12]
^^
- so 12 is real max # of strategies, or StrategyEvaluationIsValid
crashes backend (called if CASSER defined).
Vadim B. Mikheev [Thu, 22 May 1997 16:01:33 +0000 (16:01 +0000)]
1. Pass GISTENTRYs to giststate->penaltyFn by pointers, not by vals.
2. Re-initialize keys in gistrescan (if gist used in inner scan).
Marc G. Fournier [Thu, 22 May 1997 00:24:07 +0000 (00:24 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
To: pgsql-patches@postgreSQL.org
Subject: [PATCHES] DROP AGGREGATE gram.y typo...
Somehow I dropped a comma in the gram.y part (line 129) of my
patch for drop aggregate. Here's a correct patch for gram.y.
PS. I hope I got the right comma, manually applied :) (scrappy)
Marc G. Fournier [Thu, 22 May 1997 00:17:24 +0000 (00:17 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] DROP AGGREGATE patch/fix.
Here's a patch that fixes the DROP AGGREGATE command to delete
the desired aggregate for a specific type.
Marc G. Fournier [Thu, 22 May 1997 00:12:03 +0000 (00:12 +0000)]
Oops, missed the commit on this one by Darren King also...new Makefile.aix
Marc G. Fournier [Thu, 22 May 1997 00:11:29 +0000 (00:11 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] AIX make patch resubmitted.
Misc patches for AIX from Darren:
1) New src/makefiles/Makefile.aix This patch should only be
applied if the following patch (4) is applied to backend/Makefile!
Still looking into having configure determine the last line to do
the shared link. The 325 code will work for 41, so I put that in
as the default. Included a commented out 41 line for completeness.
*and*
4) Patch the backend Makefile. I've reviewed this patch with respect to the
other ports that use MAKE_EXPORTS (svr4 and univel) as closely as I could
and I don't see where it will break them. If it does, please let me know
and I'll rework it somehow.
Marc G. Fournier [Thu, 22 May 1997 00:07:30 +0000 (00:07 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] Re: [PORTS] AIX 6.1 fixes...
Here are the patches for the two things that wouldn't make it thru the AIX
compiler. The geo_ops.c change is harmless I believe. The nbtcompare.c patch
fixes me, but I don't know about any other ports. Maybe wait on that one
until Vadim decides what to do about the unsigned vs signed chars varlena
issue.
Bruce Momjian [Wed, 21 May 1997 03:12:23 +0000 (03:12 +0000)]
Updated pg_dumpall and psql to preserve database owners.
Bruce Momjian [Wed, 21 May 1997 00:45:24 +0000 (00:45 +0000)]
Add SRCDIR to lextest
Bruce Momjian [Tue, 20 May 1997 21:35:16 +0000 (21:35 +0000)]
Fix for lextest return value.
Vadim B. Mikheev [Tue, 20 May 1997 11:41:38 +0000 (11:41 +0000)]
Little memmory leak in RelationFlushRelation() in freeing
relation->rd_att (relation' TupleDesc).
Vadim B. Mikheev [Tue, 20 May 1997 11:37:33 +0000 (11:37 +0000)]
Define FREE(x) as pfree.
Vadim B. Mikheev [Tue, 20 May 1997 11:35:50 +0000 (11:35 +0000)]
Shouldn't we use palloc instead of malloc ?
Because of
* resetpsort - resets (frees) malloc'd memory for an aborted Xaction
*
* Not implemented yet.
Vadim B. Mikheev [Tue, 20 May 1997 11:30:32 +0000 (11:30 +0000)]
1. LocalBufferSync(): set nextFreeLocalBuf to 0 - we're freeing
all local buffers @ xact commit, so accordingly nextFreeLocalBuf
is first local buffer now.
It helps to avoid unnecessary local buffer allocations in LocalBufferAlloc()
latter ("memmory leaks" in 'order by').
2. ResetLocalBufferPool() lost allocated local buffers:
memset(LocalBufferDescriptors, 0, sizeof(BufferDesc) * NLocBuffer);
(local buffers leak @ xact aborts).
Vadim B. Mikheev [Tue, 20 May 1997 10:37:26 +0000 (10:37 +0000)]
Consider right-sided plans if _use_right_sided_plans_ is true.
Vadim B. Mikheev [Tue, 20 May 1997 10:31:42 +0000 (10:31 +0000)]
New VAR r_plans added to enable turn ON/OFF
using right-sided plans.
Vadim B. Mikheev [Tue, 20 May 1997 10:29:30 +0000 (10:29 +0000)]
Initialize internal keys if rtree used in inner scan.
Bruce Momjian [Tue, 20 May 1997 03:39:02 +0000 (03:39 +0000)]
Added fcvt() prot for bsdi.
Made PQsetdb() and PQfnumber() case-insensitive.
Removed attempt to set table ownership via pg_dumpall.
Marc G. Fournier [Tue, 20 May 1997 03:00:17 +0000 (03:00 +0000)]
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] AIX 6.2 make patch.
New template files to replace the old AIX template
Bruce Momjian [Mon, 19 May 1997 14:23:08 +0000 (14:23 +0000)]
Remove create_database interactive prohibition from manual.
Bruce Momjian [Mon, 19 May 1997 14:19:13 +0000 (14:19 +0000)]
Add Makefile.global to lextest makefile.
Vadim B. Mikheev [Mon, 19 May 1997 04:31:18 +0000 (04:31 +0000)]
Multi-column indices creation is now supported in normal way
(CREATE INDEX ...)
Marc G. Fournier [Mon, 19 May 1997 03:49:39 +0000 (03:49 +0000)]
From: Olaf Mittelstaedt <MSTAEDT@va-sigi.va.fh-ulm.de>
Minor patches to geo_ops.c to clean up compile under AIX 4.1.3
Marc G. Fournier [Mon, 19 May 1997 03:21:55 +0000 (03:21 +0000)]
These two files got reversed somehow... -K PIC is a cc'ism and -fPIC is a
gcc'ism
Edmund Mergl [Sat, 17 May 1997 16:25:57 +0000 (16:25 +0000)]
added const declaration in form() E.Mergl
Edmund Mergl [Sat, 17 May 1997 16:23:06 +0000 (16:23 +0000)]
added const declaration E.Mergl
Thomas G. Lockhart [Sat, 17 May 1997 15:17:30 +0000 (15:17 +0000)]
Add comments to assist with installation.
Thomas G. Lockhart [Sat, 17 May 1997 15:08:32 +0000 (15:08 +0000)]
Linux-specific (RedHat variant) postgres system startup routine.
Initial version.
Thomas G. Lockhart [Sat, 17 May 1997 14:26:30 +0000 (14:26 +0000)]
Add information on regression testing and Linux ports.
Fix typos in TZ setting for regression testing and in gmake redirection.
Thomas G. Lockhart [Sat, 17 May 1997 14:24:09 +0000 (14:24 +0000)]
Initial 64-bit integer package.
Thomas G. Lockhart [Sat, 17 May 1997 06:20:34 +0000 (06:20 +0000)]
Remove troublesome type coersions from the char8 return statements.
Noted in trying to port to AIX.
Thomas G. Lockhart [Sat, 17 May 1997 06:17:45 +0000 (06:17 +0000)]
Spiff up description of the regression tests and outcomes.
Thomas G. Lockhart [Sat, 17 May 1997 06:16:34 +0000 (06:16 +0000)]
Include information for reset, set, and show commands.
Marc G. Fournier [Sat, 17 May 1997 03:02:04 +0000 (03:02 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Add an entry for the Sparc/Linux port in .similar
Marc G. Fournier [Sat, 17 May 1997 03:00:24 +0000 (03:00 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Here are the latest changes to the INSTALL instructions.
The main changes are:
- Step 5, on flex
- Steps 18 and 19, on regression tests
- Step 22 c) on starting postmaster on bootup on FreeBSD
- Added porting notes for SPARC/Linux at end.
If there is time, Thomas should review step 19.
Thomas G. Lockhart [Fri, 16 May 1997 07:24:13 +0000 (07:24 +0000)]
Improve informational messages for "show" command responses.
Thomas G. Lockhart [Fri, 16 May 1997 07:22:28 +0000 (07:22 +0000)]
Fix expected output for datetime and abstime to/from date conversions.
This results from improvements in datetime.c which ensures that the
conversions are done in local time rather than GMT.
Thomas G. Lockhart [Fri, 16 May 1997 07:19:50 +0000 (07:19 +0000)]
Fix datetime and abstime conversions to and from date.
Bring optional new-storage date and time up to date and test.
This new storage format should fix the "Sparc gcc -O2 bug".
(Enable new code with USE_NEW_DATE and USE_NEW_TIME in dt.h)
Thomas G. Lockhart [Fri, 16 May 1997 07:13:54 +0000 (07:13 +0000)]
Add documentation for reset, set, and show, and cross-reference in built-in.
Marc G. Fournier [Fri, 16 May 1997 02:00:03 +0000 (02:00 +0000)]
Modify lextest and GNUmakefile so that if the test does fail, the
make doesn't proceed
Marc G. Fournier [Fri, 16 May 1997 01:09:39 +0000 (01:09 +0000)]
Have Make process exit if lextest fails
Marc G. Fournier [Thu, 15 May 1997 22:55:35 +0000 (22:55 +0000)]
From: Robert E. Bruccoleri <bruc@bms.com>
Fixes:
Shared objects are not linked correctly
Marc G. Fournier [Thu, 15 May 1997 22:16:45 +0000 (22:16 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Subject: [PATCHES] Patch for INSTALL
The following patch makes a number of modifications to file INSTALL.
Among other things, it restores some platform specific notes I deleted.
It also no longer requires a separate compile for the regression tests.
Please note that this patch already incorporates the patch Hal Snyder
submitted on Monday. Do not apply Hal's patch.
Bruce Momjian [Wed, 14 May 1997 21:56:13 +0000 (21:56 +0000)]
More TODO/HISTORY updates
Bruce Momjian [Wed, 14 May 1997 20:18:53 +0000 (20:18 +0000)]
UPdate TODO and HIstory for new release.
Bruce Momjian [Wed, 14 May 1997 19:49:34 +0000 (19:49 +0000)]
Allow pg_dumpall to preserve database ownership.
Bruce Momjian [Wed, 14 May 1997 17:12:30 +0000 (17:12 +0000)]
Remove README.flex and make lextest point to INSTALL.
Bruce Momjian [Wed, 14 May 1997 04:46:47 +0000 (04:46 +0000)]
lextest Makefile cleanup
Thomas G. Lockhart [Wed, 14 May 1997 04:35:10 +0000 (04:35 +0000)]
Rename new float and int conversion routines to avoid conflicts with
system calls on AIX (and probably other machines too).
Bruce Momjian [Wed, 14 May 1997 03:32:40 +0000 (03:32 +0000)]
Add test for flex bug as part of make, and point them to README.flex.
Bruce Momjian [Wed, 14 May 1997 03:20:26 +0000 (03:20 +0000)]
Update FAQ and TODO
Vadim B. Mikheev [Wed, 14 May 1997 01:38:34 +0000 (01:38 +0000)]
Added:
Note: currently, only btree access method supports multi-
attribute indices. Up to 7 keys may be specified.
Marc G. Fournier [Tue, 13 May 1997 22:13:33 +0000 (22:13 +0000)]
From: "Brian E. Gallew" <geek+@cmu.edu>
Subject: [PORTS] minor fix for DGUX port
src/include/port/dgux.h needs the following three lines appended:
#ifndef BYTE_ORDER
#define BYTE_ORDER BIG_ENDIAN
#endif
I believe this to be correct for DG/UX on M88k processors. I don't have one of
the new Intel-based boxes to check on.
Bruce Momjian [Tue, 13 May 1997 04:41:54 +0000 (04:41 +0000)]
Update manual pages for vacuum and create index for Vadim.
Thomas G. Lockhart [Tue, 13 May 1997 04:26:07 +0000 (04:26 +0000)]
Fix return value for tm2datetime to properly indicate failure.
Bruce Momjian [Tue, 13 May 1997 01:46:00 +0000 (01:46 +0000)]
fix for sizeof pointed out by Ed Buddington
Vadim B. Mikheev [Mon, 12 May 1997 07:17:23 +0000 (07:17 +0000)]
Added _readAggreg() to work with T_Aggreg type.
Thomas G. Lockhart [Sun, 11 May 1997 15:46:19 +0000 (15:46 +0000)]
Update to current information for upcoming v6.1 production release.
Thomas G. Lockhart [Sun, 11 May 1997 15:45:10 +0000 (15:45 +0000)]
More tables are listed in the user-defined relations from other regression
tests, including new tests.
Thomas G. Lockhart [Sun, 11 May 1997 15:42:09 +0000 (15:42 +0000)]
Add inter-type regression tests for geometry, date/time, and numbers.
Add regression tests for circles, line segments, and paths.
Modify regression tests to allow GEQ optimizer (order results).
Thomas G. Lockhart [Sun, 11 May 1997 15:19:33 +0000 (15:19 +0000)]
Add type conversion functions between floats and integers.
Include some additional path functions which were coded but omitted here.
Add translation and rotation/scaling operators for some geometric types.
Fix bugs in some geometry comparison operator declarations.
Thomas G. Lockhart [Sun, 11 May 1997 15:13:49 +0000 (15:13 +0000)]
Add a few type conversion functions.
Pass an additional argument for date/time formatting to better handle timezones.
Thomas G. Lockhart [Sun, 11 May 1997 15:11:47 +0000 (15:11 +0000)]
Fix timezone manipulation code to avoid crashes on some machines.
Add type conversion functions for floating point numbers.
Check for zero in unary minus floating point code (IEEE allows an
explicit negative zero which looks ugly in a query result!).
Ensure circle type has non-negative radius.
Marc G. Fournier [Sun, 11 May 1997 06:27:07 +0000 (06:27 +0000)]
Oops, one of DAvid's patches didn't quite make it in cleanly, so a little
manual intervention required :)
Marc G. Fournier [Sun, 11 May 1997 06:18:33 +0000 (06:18 +0000)]
From: David Friend <dfriend@atlsci.atlsci.com>
Subject: [PATCHES] Documentation update
This patch updates some of the documentation that comes with the
distribution. The following files are updated:
COPYRIGHT
README
doc/README.flex
doc/README.support
doc/bug.template
Marc G. Fournier [Fri, 9 May 1997 03:28:54 +0000 (03:28 +0000)]
From: Edmund Mergl <E.Mergl@bawue.de>
Subject: [PATCHES] libpq patch
Hi,
here is a small patch which fixes two problems:
1. libpq/libpq-fe.h:
somehow disappeared the line
#define DefaultOption ""
now compilation stops with an error complainig an
unknown DefaultOption (970508).
2. Same patch as I sent already twice, but it never made it
into the source tree: there is no default value for
AuthType and Password. This way any libpq-application
(i.e. perl-scripts) which use the function PQconnectdb
will break with PostgreSQL-6.1. The patch simply uses
an empty string as default value.
Marc G. Fournier [Fri, 9 May 1997 03:26:56 +0000 (03:26 +0000)]
From: Keith Parks <emkxp01@mtcc.demon.co.uk>
Subject: [PATCHES] Patches for boolean, timespan and reltime regression tests.
Hi All,
Here are a couple of patches to the regression tests to introduce
some specific ordering to the results.
I've only made changes to the queries that were exhibiting differences
on my regression runs.
This will also have the side effect of testing the ordering code for
the boolean and some of the time types.
Bruce Momjian [Thu, 8 May 1997 02:45:53 +0000 (02:45 +0000)]
Fix typechecking problem pointed out by Thomas.