OSDN Git Service
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)
Marc G. Fournier [Sun, 25 Jan 1998 05:23:59 +0000 (05:23 +0000)]
From: Keith Parks <emkxp01@mtcc.demon.co.uk>
Small patch for sparc solaris/tas()
Marc G. Fournier [Sun, 25 Jan 1998 05:18:34 +0000 (05:18 +0000)]
From: Jeroen van Vianen <jeroenv@design.nl>
This patch solves the problem with multiple order by columns, with the
first one having NULL values.
Bruce Momjian [Sun, 25 Jan 1998 05:15:15 +0000 (05:15 +0000)]
getpid/pid cleanup
Marc G. Fournier [Sun, 25 Jan 1998 05:04:21 +0000 (05:04 +0000)]
Somehow the 'comment' here got messed up
Marc G. Fournier [Sun, 25 Jan 1998 04:14:36 +0000 (04:14 +0000)]
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Hi -- a couple of small items concerning the January 23rd snapshot:
the inclusion of the Kerberos stuff in one Makefile, a "leading tab"
cleanup in another, and a fix for a typo in the configure script.
Marc G. Fournier [Sun, 25 Jan 1998 04:12:28 +0000 (04:12 +0000)]
Wish ppl would make up their mnd :)
Marc G. Fournier [Sun, 25 Jan 1998 04:10:32 +0000 (04:10 +0000)]
OOps...missed the second patch of patch two that uses pfree() instead of
free()
From: James Hughes <jamesh@interpath.com>
Marc G. Fournier [Sun, 25 Jan 1998 04:08:54 +0000 (04:08 +0000)]
This is the second of two patches required to fix the the grant and
revoke statements.
From: James Hughes <jamesh@interpath.com>
Marc G. Fournier [Sun, 25 Jan 1998 04:07:52 +0000 (04:07 +0000)]
Patch against src/backend/nodes/outfuncs.c.orig fixes backend crashes
when creating unique indexes.
From: James Hughes <jamesh@interpath.com>
Marc G. Fournier [Sun, 25 Jan 1998 04:07:00 +0000 (04:07 +0000)]
This patch fixes one of two problems with grant/revoke statements on the
Linux platform.
From: James Hughes <jamesh@interpath.com>
Bruce Momjian [Sat, 24 Jan 1998 22:50:57 +0000 (22:50 +0000)]
Fix prototypes so they don't look like function definitions.
Marc G. Fournier [Sat, 24 Jan 1998 19:40:56 +0000 (19:40 +0000)]
More up to date scan.c
Bruce Momjian [Fri, 23 Jan 1998 22:16:48 +0000 (22:16 +0000)]
Fix a variety of locking problems like newer lock waiters getting
lock before older waiters, and having readlock people not share
locks if a writer is waiting for a lock, and waiting writers not
getting priority over waiting readers.
Marc G. Fournier [Fri, 23 Jan 1998 19:53:44 +0000 (19:53 +0000)]
LOCK_LEVEL is defined in an i386_solaris system file, causing the compile
to break. renaming to PG_LOCK_LEVEL
Marc G. Fournier [Fri, 23 Jan 1998 19:22:24 +0000 (19:22 +0000)]
From: James Hughes <jamesh@interpath.com>
This is a patch to fix crashes in psql when executing queries from
an external file. The code also adds error checking to verify that
memory for "query" was allocated. The conditional for the block of
code was changed from "query == NULL" to "query_alloced == false".
The conditional, "query == NULL", was never true. This prevented
the memory being allocated for "query". A few lines later, an attempt
to write to an un-allocated memory area generated a SIGSEGV causing
the frontend to crash.
Marc G. Fournier [Fri, 23 Jan 1998 19:21:11 +0000 (19:21 +0000)]
From: Andrew Martin <martin@biochemistry.ucl.ac.uk>
psql .psqlrc file startup(Andrew)
Marc G. Fournier [Fri, 23 Jan 1998 19:13:22 +0000 (19:13 +0000)]
Minor cleanups for i386_solaris port
Marc G. Fournier [Fri, 23 Jan 1998 18:58:00 +0000 (18:58 +0000)]
A dummy file so that configure under solaris works
Bruce Momjian [Fri, 23 Jan 1998 06:01:36 +0000 (06:01 +0000)]
Cleanup deadlock message.
Marc G. Fournier [Fri, 23 Jan 1998 02:31:18 +0000 (02:31 +0000)]
Fixes a free() problem under FreeBSD
Fixed pointed out by: jwieck@debis.com (Jan Wieck)
Bruce Momjian [Thu, 22 Jan 1998 23:05:18 +0000 (23:05 +0000)]
Add LOCK command as DELETE FROM ... WHERE false.
Bruce Momjian [Thu, 22 Jan 1998 18:50:22 +0000 (18:50 +0000)]
Allow \z to show sequences.
Bruce Momjian [Wed, 21 Jan 1998 23:42:15 +0000 (23:42 +0000)]
Small varlena cleanup.
Bruce Momjian [Wed, 21 Jan 1998 04:24:46 +0000 (04:24 +0000)]
Make subqueries rewrite properly.
Bruce Momjian [Tue, 20 Jan 1998 22:55:25 +0000 (22:55 +0000)]
FIx for regression-test found bug.
Bruce Momjian [Tue, 20 Jan 1998 22:12:17 +0000 (22:12 +0000)]
Add Var.varlevelup to code. More parser cleanup.
Bruce Momjian [Tue, 20 Jan 1998 05:05:08 +0000 (05:05 +0000)]
Parser cleanup.
Add lock to i386 asm.
Marc G. Fournier [Tue, 20 Jan 1998 03:11:11 +0000 (03:11 +0000)]
Start an openbsd port
Bruce Momjian [Mon, 19 Jan 1998 18:11:10 +0000 (18:11 +0000)]
Fix problem with nodes handling.
Bruce Momjian [Mon, 19 Jan 1998 05:48:55 +0000 (05:48 +0000)]
Added code so SubLinks make it to optimizer.
Bruce Momjian [Mon, 19 Jan 1998 05:06:41 +0000 (05:06 +0000)]
Create SubLink nodes in parser for Vadim.
Bruce Momjian [Mon, 19 Jan 1998 02:37:51 +0000 (02:37 +0000)]
Fix for SELECT INTO TABLE for varchar().
Marc G. Fournier [Sat, 17 Jan 1998 23:39:35 +0000 (23:39 +0000)]
From: "Michael J. Maravillo" <mmj@philonline.com>
This patch makes it possible to do a "real" make distclean (back to its
fresh state) on the distribution after compilation, regression testing,
etc.
Marc G. Fournier [Sat, 17 Jan 1998 23:36:44 +0000 (23:36 +0000)]
From: "Michael J. Maravillo" <mmj@philonline.com>
Also, I think the existence of pgsql/src/bin/initlocation/initlocation
isn't necessary as it's generated by Makefile from initlocation.sh.
Marc G. Fournier [Sat, 17 Jan 1998 23:35:24 +0000 (23:35 +0000)]
Must commit configure changes after patch to configure.in
Marc G. Fournier [Sat, 17 Jan 1998 23:33:58 +0000 (23:33 +0000)]
From: "Billy G. Allie" <Bill.Allie@mug.org>
The attached patches will allow postgreSQL to compile successfully on SCO
UNIXWARE 2.1.x. The patches fix the following problems:
1. Configure did not properly recognize the UNIXWARE system as needing the
univel port. It used the sys4 port.
2. Configure did not properly process the CC flag in the template file.
3. There was no working test and set locking implementation for the native
UNIXWARE compiler.
4. The test and set locking used for Intel X86 that was selected by defining
NEED_I386_TAS_ASM could fail in a multi-processor environment.
5. The makefiles for libpq and libpgtcl did not make a shared library for
the univel port.
Marc G. Fournier [Sat, 17 Jan 1998 23:17:46 +0000 (23:17 +0000)]
From: Jan Wilhelm <Jan_Wilhelm@Physik.TU-Muenchen.DE>
a) psql dumps core when using -a password and PGUSER is set but PGPASSWORD
not set.
Bruce Momjian [Sat, 17 Jan 1998 05:01:34 +0000 (05:01 +0000)]
Gram.y cleanup.
Bruce Momjian [Sat, 17 Jan 1998 04:53:46 +0000 (04:53 +0000)]
Creates the SubLink structure, and the Query->hasSubLink field,
with supporting code.
Creates SubLink node in gram.y.
psql.c patch for newatttypmod field.
Bruce Momjian [Fri, 16 Jan 1998 23:21:07 +0000 (23:21 +0000)]
New pg_attribute.atttypmod for type-specific information like
varchar length.
Cleans up code so attlen is always length.
Removed varchar() hack added earlier.
Will fix bug in selecting varchar() fields, and varchar() can be
variable length.
Bruce Momjian [Fri, 16 Jan 1998 05:03:45 +0000 (05:03 +0000)]
Temporary varchar patch.
Bruce Momjian [Thu, 15 Jan 1998 22:31:33 +0000 (22:31 +0000)]
Fix for aggreg problem and fmgr.c compile problems.
Marc G. Fournier [Thu, 15 Jan 1998 20:54:52 +0000 (20:54 +0000)]
Fix:
nodeAgg.c: WARN -> NOTICE for elog
parse_oper.c: was created after patch for fmgr_info, so function call wrong
scan.c: regenerated for i386_solaris using flex 2.5.4
gethostname.c: required prototype for gethostname() function
config.h.in: create prototype for isinfo() function
isinf.c: "fake" isinf() under i386_solaris using fpclass() call...
PostgreSQL Daemon [Thu, 15 Jan 1998 19:46:37 +0000 (19:46 +0000)]
Thank god for searchable mail archives.
Patch by: wieck@sapserv.debis.de (Jan Wieck)
One of the design rules of PostgreSQL is extensibility. And
to follow this rule means (at least for me) that there should
not only be a builtin PL. Instead I would prefer a defined
interface for PL implemetations.
Bruce Momjian [Thu, 15 Jan 1998 19:00:16 +0000 (19:00 +0000)]
Remove Query->qry_aggs and qry_numaggs and replace with Query->hasAggs.
Pass List* of Aggregs into executor, and create needed array there.
No longer need to double-processs Aggregs with second copy in Query.
Fix crash when doing:
select sum(x+1) from test where 1 > 0;
Bruce Momjian [Wed, 14 Jan 1998 19:55:53 +0000 (19:55 +0000)]
Function cleanupo for List* when it should be Node *.
Bruce Momjian [Wed, 14 Jan 1998 15:48:51 +0000 (15:48 +0000)]
Cleanup of prototypes. FIx for PQtrace start/stop several times.
Marc G. Fournier [Tue, 13 Jan 1998 20:13:19 +0000 (20:13 +0000)]
this should pretty much clean up the i386_solaris port, with regression
tests running "as expected"...
Marc G. Fournier [Tue, 13 Jan 1998 19:28:39 +0000 (19:28 +0000)]
Various cleanups for the i386_solaris environment
Marc G. Fournier [Tue, 13 Jan 1998 19:22:29 +0000 (19:22 +0000)]
isinf() doesn't exist under i386_solaris, so code it such that
it is (!isnan() && !finite()) instead
Marc G. Fournier [Tue, 13 Jan 1998 19:04:39 +0000 (19:04 +0000)]
Oops, should be 'tas.o', not 'tas.s'
Marc G. Fournier [Tue, 13 Jan 1998 15:53:02 +0000 (15:53 +0000)]
MIssed a semi-colon in AC_LINK_FILES for i386_solaris port...
Marc G. Fournier [Tue, 13 Jan 1998 15:31:24 +0000 (15:31 +0000)]
Further clean up "auto-configuration" for ports
Marc G. Fournier [Tue, 13 Jan 1998 15:00:22 +0000 (15:00 +0000)]
Work on getting the i386_solaris compile to work ...
Vadim B. Mikheev [Tue, 13 Jan 1998 14:57:25 +0000 (14:57 +0000)]
Remove unused "option" from PQconnectdb().
Vadim B. Mikheev [Tue, 13 Jan 1998 14:56:15 +0000 (14:56 +0000)]
Remove PageSizeIsValid from BufferGetPageSize.
Vadim B. Mikheev [Tue, 13 Jan 1998 14:53:36 +0000 (14:53 +0000)]
extern char* crypt_getpwdreloadfilename(void);
^^^^
Marc G. Fournier [Tue, 13 Jan 1998 13:33:12 +0000 (13:33 +0000)]
Add a 'dummy' file for i386_solaris.c for configure