OSDN Git Service
Bruce Momjian [Fri, 6 Feb 1998 20:18:01 +0000 (20:18 +0000)]
Update now that attcacheoff initial value is -1 always.
Bruce Momjian [Fri, 6 Feb 1998 19:18:06 +0000 (19:18 +0000)]
Set attcacheoff value to -1 for all tables.
Bruce Momjian [Fri, 6 Feb 1998 17:46:31 +0000 (17:46 +0000)]
Fix for \d on long table names.
Bruce Momjian [Fri, 6 Feb 1998 16:46:29 +0000 (16:46 +0000)]
FIx hasSubLinks for Vadim.
Marc G. Fournier [Fri, 6 Feb 1998 13:32:34 +0000 (13:32 +0000)]
From: Michael Meskes <meskes@topsystem.de>
I have implemented a better user interface (well part of) so you can use it
as expected. As usual there are some bug fixes. :-)
Bruce Momjian [Thu, 5 Feb 1998 22:48:44 +0000 (22:48 +0000)]
FIx for varchar(), char() and INSERT .. SELECT.
Bruce Momjian [Thu, 5 Feb 1998 21:19:21 +0000 (21:19 +0000)]
Vadim fix for vacuum analyze.
Bruce Momjian [Thu, 5 Feb 1998 19:50:55 +0000 (19:50 +0000)]
FIx for atttypmod on system tables.
Bruce Momjian [Thu, 5 Feb 1998 19:02:44 +0000 (19:02 +0000)]
FIx for atttypmod in system catalogs.
Bruce Momjian [Thu, 5 Feb 1998 17:22:41 +0000 (17:22 +0000)]
Fix for varchar functions, and indextyple j-1 fix.
Marc G. Fournier [Thu, 5 Feb 1998 15:46:43 +0000 (15:46 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Well this is not really a patch. But I mananged to get Linus' old Postgres95
precompiler to compile and work with PostgreSQL. The next step would be to
collect bug/missing feature reports and to put it into the distribution so
that it is made with the standard make procedure.
Warning! So far it is not tested much and it does not install correctly. But
I was able to create a small binary with it.
Marc G. Fournier [Thu, 5 Feb 1998 15:08:49 +0000 (15:08 +0000)]
Symptom:
select from a table with attrs (a int, b char(20))
crashed in bpcharout() (palloc of -1 bytes). But a table
with attrs (a int, b varchar(20)) worked.
From: Jan Wieck <jwieck@debis.com>
Marc G. Fournier [Thu, 5 Feb 1998 04:21:56 +0000 (04:21 +0000)]
init_fixup_addr() function removed, so port-protos.h no longer required
Marc G. Fournier [Thu, 5 Feb 1998 04:08:44 +0000 (04:08 +0000)]
func_error() changed so that if caller is passed with NULL value, its
output at least doesn't appear that its missing something.
wasn't particularly confident with removing 'caller' altogether :(
Marc G. Fournier [Thu, 5 Feb 1998 04:00:55 +0000 (04:00 +0000)]
Build in a 'dummy' tas file...nothing in it, just used for the link process
of configure
Bruce Momjian [Thu, 5 Feb 1998 03:47:08 +0000 (03:47 +0000)]
char() cleanup and more cacheoff improvements.
Marc G. Fournier [Thu, 5 Feb 1998 03:40:10 +0000 (03:40 +0000)]
Fix up this so that it also doesn't use a caller variable...
Marc G. Fournier [Thu, 5 Feb 1998 03:35:48 +0000 (03:35 +0000)]
Clean up func_error() function completely removing caller variable as
"more info then user requires"
Marc G. Fournier [Thu, 5 Feb 1998 03:31:01 +0000 (03:31 +0000)]
Port specific, compiler specfied for SGI/Irix5
From: Andrew Martin <martin@biochemistry.ucl.ac.uk>
Bruce Momjian [Wed, 4 Feb 1998 21:32:12 +0000 (21:32 +0000)]
Cleanup getattr code. Make CHAR() use attcacheoff.
Marc G. Fournier [Wed, 4 Feb 1998 13:19:32 +0000 (13:19 +0000)]
Try this fix for the tas.s code...
Thomas G. Lockhart [Wed, 4 Feb 1998 06:11:48 +0000 (06:11 +0000)]
Allow most expressions in BETWEEN clause. Allow all expressions if
surrounded by parentheses (but not all are meaningful).
Remove unused keywords ACL, APPEND, MERGE.
Requires a "make clean" to recompile all code since keyword numeric
assignments have changed with keyword removal.
Bruce Momjian [Tue, 3 Feb 1998 21:57:27 +0000 (21:57 +0000)]
Vacuum parameter fix.
Marc G. Fournier [Tue, 3 Feb 1998 20:30:43 +0000 (20:30 +0000)]
Strange, this should be required, but initialize need_tas to no
Marc G. Fournier [Tue, 3 Feb 1998 19:40:15 +0000 (19:40 +0000)]
I tried to match up the if/test stuff...fixed now, I think
Bruce Momjian [Tue, 3 Feb 1998 19:27:30 +0000 (19:27 +0000)]
Subselects with =, >, etc.
Cleanup for vacuum help, manual page, and error message
Marc G. Fournier [Tue, 3 Feb 1998 18:06:37 +0000 (18:06 +0000)]
various i386_solaris cleanups that should fix sparc_solaris and hpux
Marc G. Fournier [Tue, 3 Feb 1998 16:58:46 +0000 (16:58 +0000)]
Learning a little more about autoconf each day...
Fix inclusion of 'tas.s' for various ports
Thomas G. Lockhart [Tue, 3 Feb 1998 16:06:49 +0000 (16:06 +0000)]
Supress call to tzset() in reset_timezone() if a new time zone has never
been set in the session.
General cleanup of timezone support code.
Thomas G. Lockhart [Tue, 3 Feb 1998 16:04:05 +0000 (16:04 +0000)]
Remove unused keyword CHANGE.
Thomas G. Lockhart [Tue, 3 Feb 1998 16:01:59 +0000 (16:01 +0000)]
Define boolean functions and operators for lseg <, <=, <>, >=, >.
Define functions and operators for closest point to lseg on box,
to line on lseg, to lseg on lseg.
Define function and operator for length of lseg.
Change length operator from '??' to '@-@'
(currently defined for path and lseg).
Thomas G. Lockhart [Tue, 3 Feb 1998 15:55:58 +0000 (15:55 +0000)]
Define boolean functions for lseg <, <=, <>, >=, >
Define close_ls(), close_lseg(), lseg_length().
Write real code for close_sb(), close_pb(), inter_sb(), inter_lb().
Repair lseg_perp() which determines if two lsegs are perpendicular.
Repair lseg_dt() distance between two lsegs.
Note: close_sl() is clearly broken but will repair later
(calculating point on lseg rather than point on line).
Marc G. Fournier [Tue, 3 Feb 1998 12:42:52 +0000 (12:42 +0000)]
Use proper symbol for hpux
Marc G. Fournier [Tue, 3 Feb 1998 12:41:24 +0000 (12:41 +0000)]
Just another dummy file
Marc G. Fournier [Tue, 3 Feb 1998 02:09:08 +0000 (02:09 +0000)]
Fix for various aix related 'mis-defines'
From: Darren King <darrenk@insightdist.com>
Marc G. Fournier [Tue, 3 Feb 1998 02:07:15 +0000 (02:07 +0000)]
Fix for missing tas.s under sparc_solaris
Reported by: Shiby Thomas <sthomas@cise.ufl.edu>
Bruce Momjian [Tue, 3 Feb 1998 01:53:24 +0000 (01:53 +0000)]
Parser cleanup for expr and subqueries.
Marc G. Fournier [Tue, 3 Feb 1998 01:25:47 +0000 (01:25 +0000)]
Clean up the alpha port, remove the backend/port/alpha subdirectory
structure, and move the init_address_fixup() code directly into
backend/main/main.c with appropriate #ifdefs around it...
Marc G. Fournier [Tue, 3 Feb 1998 01:00:50 +0000 (01:00 +0000)]
Fixes for linux-elf-sparc related template file
From: "Thomas A. Szybist" <szybist@boxhill.com>
Marc G. Fournier [Tue, 3 Feb 1998 00:57:42 +0000 (00:57 +0000)]
From: teunis <teunis@mauve.computersupportcentre.com>
Slight cleanups for glibc2.0
Marc G. Fournier [Mon, 2 Feb 1998 15:54:15 +0000 (15:54 +0000)]
Make sure Irix/Linux FAQs are updated
Marc G. Fournier [Mon, 2 Feb 1998 15:24:47 +0000 (15:24 +0000)]
Add an irix5.c dummy file for irix5 port
Marc G. Fournier [Mon, 2 Feb 1998 13:17:01 +0000 (13:17 +0000)]
From: Peter T Mount <patches@maidast.demon.co.uk>
[This is a repost - it supercedes the previous one. It fixes the patch so
it doesn't bread aix port, plus there's a file missing out of the
original post because difforig doesn't pick up new files. It's now
attached. peter]
This patch brings the JDBC driver up to the current protocol spec.
Basically, the backend now tells the driver what authentication scheme to
use.
The patch also fixes a performance problem with large objects. In the
buffer manager, each fastpath call was sending multiple Notifications to
the backend (sometimes more data in the form of notifications were being
sent than blob data!).
Marc G. Fournier [Mon, 2 Feb 1998 03:49:11 +0000 (03:49 +0000)]
Fix up the alpha port/dynloader for configure
Marc G. Fournier [Mon, 2 Feb 1998 03:11:37 +0000 (03:11 +0000)]
Fix for ltoa() problem pointed out by Stan Brown <stanb@awod.com>
Marc G. Fournier [Mon, 2 Feb 1998 02:12:34 +0000 (02:12 +0000)]
set "caller" value in parse_func.h to func_get_detail instead of just ""
Marc G. Fournier [Mon, 2 Feb 1998 01:48:25 +0000 (01:48 +0000)]
Current output for FreeBSD (2/1/98)
Bruce Momjian [Mon, 2 Feb 1998 01:28:12 +0000 (01:28 +0000)]
No datedebug printing of date debug is not defined.
Bruce Momjian [Mon, 2 Feb 1998 01:20:04 +0000 (01:20 +0000)]
TODO cleanup
Bruce Momjian [Mon, 2 Feb 1998 00:41:55 +0000 (00:41 +0000)]
Install migration file and IP contrib/ stuff.
Marc G. Fournier [Mon, 2 Feb 1998 00:13:41 +0000 (00:13 +0000)]
Fix HP/ux port for tas.s
Marc G. Fournier [Mon, 2 Feb 1998 00:10:10 +0000 (00:10 +0000)]
Fixes:
dynloader.c:25: port-protos.h: No such file or directory
In HPUX port
Marc G. Fournier [Mon, 2 Feb 1998 00:05:03 +0000 (00:05 +0000)]
#if aix changed to #if HAVE_SYS_SELECT_H
Marc G. Fournier [Mon, 2 Feb 1998 00:04:08 +0000 (00:04 +0000)]
Move all the isinf() stuff from float.c to isinf.c, and build it according to
configure vs port specific #ifdef's...
Bruce Momjian [Sun, 1 Feb 1998 22:20:47 +0000 (22:20 +0000)]
Fix for psort. fixes regression tests.
Bruce Momjian [Sun, 1 Feb 1998 21:20:26 +0000 (21:20 +0000)]
Upgrade doc stuff to 6.3.
Bruce Momjian [Sun, 1 Feb 1998 19:43:54 +0000 (19:43 +0000)]
AIX patch from Darren King and Univel patch from Billy Allie, mostly
related to grammar and parser issues, with one postmaster fix.
Marc G. Fournier [Sun, 1 Feb 1998 11:46:10 +0000 (11:46 +0000)]
minor change so that it outputs to regression.diffs ...
Marc G. Fournier [Sun, 1 Feb 1998 11:43:17 +0000 (11:43 +0000)]
Make changes so that when the diff is done between 'expected' and 'results',
if an operating specific expected file exists, use that for the comparison.
This allows for "legit" differences between results, like the "Result too
large" message vs "Math result not representable" ...
Also, have the failed diffs get output to regression.diffs so that its easy to
view those tests that failed
Marc G. Fournier [Sun, 1 Feb 1998 07:46:43 +0000 (07:46 +0000)]
Missed adding new univel files and removing univel subdirectory
Marc G. Fournier [Sun, 1 Feb 1998 07:44:00 +0000 (07:44 +0000)]
From: "Billy G. Allie" <Bill.Allie@mug.org>
The following patches will bring the UNIVEL port in line with the new porting
model used in postgreSQL 6.3
Bruce Momjian [Sun, 1 Feb 1998 05:38:40 +0000 (05:38 +0000)]
Reduce size of inlining.
Marc G. Fournier [Sun, 1 Feb 1998 00:02:59 +0000 (00:02 +0000)]
1. "#ifdef 0" is bad C. ifdef is for checking a macro and 0 is
an illegal macro name. Correct syntax is "#if 0". This is in...
From: Darren King <darrenk@insightdist.com>
Marc G. Fournier [Sat, 31 Jan 1998 21:27:28 +0000 (21:27 +0000)]
From: Phil Thompson <phil@river-bank.demon.co.uk>
I haven't had final confirmation from Peter yet, but the attached patch
needs to be applied for the Beta otherwise password and crypt
authentication just won't work.
It puts back the loop in libpq and also fixes a couple of problems with
maintaining compatability with pre-6.3 drivers.
Marc G. Fournier [Sat, 31 Jan 1998 20:14:15 +0000 (20:14 +0000)]
From: Phil Thompson <phil@river-bank.demon.co.uk>
I haven't had final confirmation from Peter yet, but the attached patch
needs to be applied for the Beta otherwise password and crypt
authentication just won't work.
It puts back the loop in libpq and also fixes a couple of problems with
maintaining compatability with pre-6.3 drivers.
Bruce Momjian [Sat, 31 Jan 1998 05:54:57 +0000 (05:54 +0000)]
fmgr_faddr cleanup
Bruce Momjian [Sat, 31 Jan 1998 05:31:03 +0000 (05:31 +0000)]
fmgr_faddr cleanup
Bruce Momjian [Sat, 31 Jan 1998 05:22:43 +0000 (05:22 +0000)]
Inline fmgr_faddr() for speed.
Bruce Momjian [Sat, 31 Jan 1998 04:39:26 +0000 (04:39 +0000)]
Inline fastgetattr and others so data access does not use function
calls.
Marc G. Fournier [Fri, 30 Jan 1998 15:03:35 +0000 (15:03 +0000)]
From: PostgreSQL DataBase <postgres@scuba.pcpipeline.com>
This again fixes the problem
with the default permissions for PUBLIC and the preventing of
statements like "GRANT null on test to test_user;".
Marc G. Fournier [Thu, 29 Jan 1998 17:16:02 +0000 (17:16 +0000)]
don't forget to 'template' i386_solaris
Marc G. Fournier [Thu, 29 Jan 1998 03:24:36 +0000 (03:24 +0000)]
From: Phil Thompson <phil@river-bank.demon.co.uk>
Attached is the patch to fix the warning messages from my code. I also
fixed one which wasn't my code. Apart from the usual warnings about the
bison/yacc generated code I only have one other warning message. This
is in gramm.y around line 2234. I wasn't sure of the fix.
I've also replaced all the calls to free() in gramm.y to calls to
pfree(). Without these I was getting backend crashes with GRANT. This
might already have been fixed.
Marc G. Fournier [Thu, 29 Jan 1998 02:26:47 +0000 (02:26 +0000)]
From: "Pedro J. Lobo" <pjlobo@euitt.upm.es>
I've patched pg_dump.c and createdb to add support for password
authentication, using the '-u' switch as in psql. I have updated also the
man pages.
Bruce Momjian [Wed, 28 Jan 1998 20:44:42 +0000 (20:44 +0000)]
psql \df cleanup and lock manual page cleanup.
Marc G. Fournier [Wed, 28 Jan 1998 12:45:44 +0000 (12:45 +0000)]
Someone wants to try a Cynus port....
Bruce Momjian [Wed, 28 Jan 1998 06:52:58 +0000 (06:52 +0000)]
Lock cleanup
Marc G. Fournier [Wed, 28 Jan 1998 03:42:27 +0000 (03:42 +0000)]
From: Peter T Mount <patches@maidast.demon.co.uk>
This has a problem when using any authentication other than trust or
ident.
Anything using libpq will hang, because the client will go into a loop
while connecting. The following patch simply comments out two lines (a do
and a while), removing the loop. Going through the new scheme, I can't see
why this do..while loop is in there.
Bruce Momjian [Wed, 28 Jan 1998 02:29:40 +0000 (02:29 +0000)]
More deadlock code to check for escallation locks.
offsetof() addition to local socket size.
Bruce Momjian [Tue, 27 Jan 1998 15:57:41 +0000 (15:57 +0000)]
dummyret cleanup
Bruce Momjian [Tue, 27 Jan 1998 15:41:32 +0000 (15:41 +0000)]
Reversed out group by patch.
Bruce Momjian [Tue, 27 Jan 1998 15:35:30 +0000 (15:35 +0000)]
Deadlock ceallnup.
(void) change for aix and hp compilers.
protocol cleanup.
Marc G. Fournier [Tue, 27 Jan 1998 05:04:35 +0000 (05:04 +0000)]
This should fix Stan's USE_POSIX_SIGNALS problem as well
Marc G. Fournier [Tue, 27 Jan 1998 05:03:15 +0000 (05:03 +0000)]
From what I can tell, -DNOFIXADE does absolutely nothing under HP/ux
Marc G. Fournier [Tue, 27 Jan 1998 05:02:11 +0000 (05:02 +0000)]
add CC:cc so that configure uses cc on non-gcc machine
From: Stan Brown <stanb@awod.com>
Bruce Momjian [Tue, 27 Jan 1998 04:08:28 +0000 (04:08 +0000)]
Fix local domain structure size computation.
Marc G. Fournier [Tue, 27 Jan 1998 03:25:14 +0000 (03:25 +0000)]
From: Phil Thompson <phil@river-bank.demon.co.uk>
Cleanup patches for previous protocol changes patch
Bruce Momjian [Tue, 27 Jan 1998 03:11:46 +0000 (03:11 +0000)]
Protocol cleanup from Phil.
Bruce Momjian [Tue, 27 Jan 1998 03:00:43 +0000 (03:00 +0000)]
Real deadlock detection.
Marc G. Fournier [Mon, 26 Jan 1998 02:48:36 +0000 (02:48 +0000)]
Try this to fix HP/UX port compile
Marc G. Fournier [Mon, 26 Jan 1998 01:55:05 +0000 (01:55 +0000)]
#include <sys/types.h> required for u_long in <netinet/in.h>
Marc G. Fournier [Mon, 26 Jan 1998 01:49:19 +0000 (01:49 +0000)]
#include <sys/types.h> required for u_long
Marc G. Fournier [Mon, 26 Jan 1998 01:42:53 +0000 (01:42 +0000)]
From: Phil Thompson <phil@river-bank.demon.co.uk>
I've completed the patch to fix the protocol and authentication issues I
was discussing a couple of weeks ago. The particular changes are:
- the protocol has a version number
- network byte order is used throughout
- the pg_hba.conf file is used to specify what method is used to
authenticate a frontend (either password, ident, trust, reject, krb4
or krb5)
- support for multiplexed backends is removed
- appropriate changes to man pages
- the -a switch to many programs to specify an authentication service
no longer has any effect
- the libpq.so version number has changed to 1.1
The new backend still supports the old protocol so old interfaces won't
break.
Bruce Momjian [Mon, 26 Jan 1998 01:01:37 +0000 (01:01 +0000)]
cash_words_out fix
Marc G. Fournier [Mon, 26 Jan 1998 00:21:02 +0000 (00:21 +0000)]
From: Darren King <darrenk@insightdist.com>
I have always been under the impression that NULL is not equal to
NULL and that NULL is not equal to anything else either. If this
is the case, then this patch is correct.
If NULL _is_ equal to NULL, then I think there are other problems
in the Group By logic.
Bruce Momjian [Sun, 25 Jan 1998 20:23:40 +0000 (20:23 +0000)]
Add cash_words_out and fix \df width.
Marc G. Fournier [Sun, 25 Jan 1998 07:42:02 +0000 (07:42 +0000)]
From: todd brandys <brandys@eng3.hep.uiuc.edu>
o The manual (really text) pages for create/alter/drop user.
Marc G. Fournier [Sun, 25 Jan 1998 07:11:07 +0000 (07:11 +0000)]
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
PostgreSQL type extensions for IP and MAC addresses.
I needed to record IP and MAC level ethernet addresses in a data
base, and I really didn't want to store them as plain strings, with
no enforced error checking, so I put together the accompanying code
as my first experiment with adding a data type to PostgreSQL. I
then thought that this might be useful to others, both directly and
as a very simple example of how to do this sort of thing, so here
it is, in the hope that it will be useful.
Marc G. Fournier [Sun, 25 Jan 1998 07:08:31 +0000 (07:08 +0000)]
this is to help someone that wants an AUX port get started...
Marc G. Fournier [Sun, 25 Jan 1998 06:12:52 +0000 (06:12 +0000)]
Patch to document the /etc/psqlrc / ~/.psqlrc config files
From: <Dr. Andrew C.R. Martin> martin@biochem.ucl.ac.uk
Marc G. Fournier [Sun, 25 Jan 1998 06:09:40 +0000 (06:09 +0000)]
Merge in D'Arcy Cain's python interface (PyGreSQL 2.0)