OSDN Git Service
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
Marc G. Fournier [Tue, 13 Jan 1998 05:28:21 +0000 (05:28 +0000)]
Updated Regression output
Marc G. Fournier [Tue, 13 Jan 1998 04:43:22 +0000 (04:43 +0000)]
Have clean clean out the test directory also, as well as the Makefiles in
interfaces/{libpq,libpgtcl}
Marc G. Fournier [Tue, 13 Jan 1998 04:38:30 +0000 (04:38 +0000)]
A minor patch for HP/UX 10 vs 9
Marc G. Fournier [Tue, 13 Jan 1998 04:24:10 +0000 (04:24 +0000)]
From: Goran Thyni <goran@bildbasen.se>
OK, here comes a patch, DBD::Pg (and possibly other 3rd party clients)
can connect to unix sockets.
Patch is against current source tree.
Background:
libpq set some policy for client, which it should not
IMHO. It prevent some 3rd party clients to connect with
unix domain sockets etc.
Marc G. Fournier [Tue, 13 Jan 1998 04:20:51 +0000 (04:20 +0000)]
One more src/interfaces/libpq/Makefile problem: there's an explicit
reference to the name of the shared library, instead of dereferencing
the definition from the top of the file.
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Marc G. Fournier [Tue, 13 Jan 1998 04:18:22 +0000 (04:18 +0000)]
Various fixes resulting from removing the PORTNAME defines
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Marc G. Fournier [Tue, 13 Jan 1998 04:05:12 +0000 (04:05 +0000)]
Some *very* major changes by darrenk@insightdist.com (Darren King)
==========================================
What follows is a set of diffs that cleans up the usage of BLCKSZ.
As a side effect, the person compiling the code can change the
value of BLCKSZ _at_their_own_risk_. By that, I mean that I've
tried it here at 4096 and 16384 with no ill-effects. A value
of 4096 _shouldn't_ affect much as far as the kernel/file system
goes, but making it bigger than 8192 can have severe consequences
if you don't know what you're doing. 16394 worked for me, _BUT_
when I went to 32768 and did an initdb, the SCSI driver broke and
the partition that I was running under went to hell in a hand
basket. Had to reboot and do a good bit of fsck'ing to fix things up.
The patch can be safely applied though. Just leave BLCKSZ = 8192
and everything is as before. It basically only cleans up all of the
references to BLCKSZ in the code.
If this patch is applied, a comment in the config.h file though above
the BLCKSZ define with warning about monkeying around with it would
be a good idea.
Darren darrenk@insightdist.com
(Also cleans up some of the #includes in files referencing BLCKSZ.)
==========================================
Marc G. Fournier [Tue, 13 Jan 1998 03:49:51 +0000 (03:49 +0000)]
> It seems there is a mistake in substr function:
> then you try get substr, which consists only of last char in string
> you get all string
>
> For example:
> userbase=> select substr('123456', 6,1) ;
> substr
> ------
> 123456
> (1 row)
>
From Edmund Mergl <E.Mergl@bawue.de>
Marc G. Fournier [Tue, 13 Jan 1998 02:23:09 +0000 (02:23 +0000)]
Should fix it all, Peter?
Marc G. Fournier [Tue, 13 Jan 1998 02:19:56 +0000 (02:19 +0000)]
Oops...missed over half the patch :(
Marc G. Fournier [Mon, 12 Jan 1998 18:10:28 +0000 (18:10 +0000)]
Upgrade to 0.76
Bruce Momjian [Mon, 12 Jan 1998 14:41:38 +0000 (14:41 +0000)]
Html backend_dir cleanup
Bruce Momjian [Sun, 11 Jan 1998 22:18:01 +0000 (22:18 +0000)]
Manual page dash cleanup.
Marc G. Fournier [Sun, 11 Jan 1998 21:16:01 +0000 (21:16 +0000)]
Fix from Peter for BLOBs
Marc G. Fournier [Sun, 11 Jan 1998 21:14:56 +0000 (21:14 +0000)]
Peter's Mega-Patch for JDBC...
see README_6.3 for list of changes
Bruce Momjian [Sun, 11 Jan 1998 21:03:10 +0000 (21:03 +0000)]
Fix SCO and change index name.