OSDN Git Service
Marc G. Fournier [Fri, 9 Aug 1996 19:06:59 +0000 (19:06 +0000)]
Fix an Inccorect Error Message...
Submitted by: Dan McGuirk <mcguirk@indirect.com>
Julian Assange [Tue, 6 Aug 1996 20:23:14 +0000 (20:23 +0000)]
applied kurt's patch to fix unlikely, but potential, string underflow
problem in psql
Marc G. Fournier [Tue, 6 Aug 1996 16:51:35 +0000 (16:51 +0000)]
Fixes:
Also, I think that an extra source of noise in the diff of regress.out and
expected.out is caused by not substituting the shared library file
extension in the regression.input file (much like the paths and the
usernames are sub'ed). This seems to be fixed with the following patches
to regression.input and the Makefile... If I'm off base here, please tell!
Submitted by: Wayde Nie <niew@phoenix.cis.mcmaster.ca>
Marc G. Fournier [Tue, 6 Aug 1996 16:43:41 +0000 (16:43 +0000)]
Fixes:
I've enclosed two patches. The first affects Solaris compilability. The
bug stems from netdb.h (where MAXHOSTNAMELEN is defined on a stock
system). If the user has installed the header files from BIND 4.9.x,
there will be no definition of MAXHOSTNAMELEN. The patch will, if all
else fails, try to include <arpa/nameser.h> and set MAXHOSTNAMELEN to
MAXDNAME, which is 256 (just like MAXHOSTNAMELEN on a stock system).
The second patch adds aliases for "ISNULL" to "IS NULL" and likewise for
"NOTNULL" to "IS NOT NULL". I have not removed the postgres specific
ISNULL and NOTNULL. I noticed this on the TODO list, and figured it would
be easy to remove.
The full semantics are:
[ expression IS NULL ]
[ expression IS NOT NULL ]
--Jason
Submitted by: Jason Wright <jason@oozoo.vnet.net>
Marc G. Fournier [Tue, 6 Aug 1996 16:38:03 +0000 (16:38 +0000)]
Fixes:
Previously Postgres95 wouldn't accept 'order by' clauses with fields
referred to as '<table>.<field>', e.g.:
select t1.field1, t2.field2 from table1 t1, table2 t2
order by t2.field2;
This syntax is required by the ODBC SQL spec.
Submitted by: Dan McGuirk <mcguirk@indirect.com>
Marc G. Fournier [Tue, 6 Aug 1996 16:27:59 +0000 (16:27 +0000)]
Fixes:
While a normal SELECT statement can contain a GROUP BY clause, a cursor
declaration cannot. This was not the case in PG-1.0. Was there a good
reason why this was changed? Are cursors being phased out? Is there any way
to get data with just a SELECT (and without a DECLARE CURSOR ...)?
The patch below seems to fix things. If anyone can see a problem with it,
please let me know. Thanks.
Submitted by: David Smith <dasmith@perseus.tufts.edu>
Marc G. Fournier [Tue, 6 Aug 1996 16:16:50 +0000 (16:16 +0000)]
Fixes for:
Here are a few minor fixes to Postgres95. Mostly I have added const
to some of the char pointers. There was also a missing header file
and a place where it looks like "==" was used when "=" was meant.
I also changed some variables from Pfin and Pfout tp pfin and pfout
because the latter shadow global variables and that just seems like
an unsafe practice which I like to avoid.
Submitted by: "D'Arcy J.M. Cain" <darcy@druid.druid.com>
Marc G. Fournier [Tue, 6 Aug 1996 16:05:56 +0000 (16:05 +0000)]
Had a space in CFLAGS+= -I ..
Submitted by: Andrew Martin <martin@biochemistry.ucl.ac.uk>
Julian Assange [Tue, 6 Aug 1996 00:40:12 +0000 (00:40 +0000)]
added patch from kurt that fixes memory leak (didn't free line buffer
for slash commands)
Marc G. Fournier [Mon, 5 Aug 1996 00:25:07 +0000 (00:25 +0000)]
Fixes:
Someone asked me if the bpchar type could be extended to do
case-insensitive regular expression searches.
Submitted by: "Alistair G. Crooks" <azcb0@juts.ccc.amdahl.com>
Marc G. Fournier [Sun, 4 Aug 1996 22:00:13 +0000 (22:00 +0000)]
Fix a bug in pg_class
submitted by: "Peter Daum" <gator@cs.tu-berlin.de>
Marc G. Fournier [Sun, 4 Aug 1996 21:03:23 +0000 (21:03 +0000)]
Quick patch for compiling under BSD/OS 2.0 from Bruce
Marc G. Fournier [Fri, 2 Aug 1996 01:24:00 +0000 (01:24 +0000)]
Okay...*last* commit, now to create a release...
README file for regresssion tests from Dr. George
Marc G. Fournier [Fri, 2 Aug 1996 01:18:05 +0000 (01:18 +0000)]
Update to expected.input from Dr. George
Marc G. Fournier [Thu, 1 Aug 1996 19:46:46 +0000 (19:46 +0000)]
Fixes:
make TCL conditinal compilation work
Submitted by: Dr_George_D_Detlefsen <drgeorge@madmax.ilt.com>
Marc G. Fournier [Thu, 1 Aug 1996 05:11:33 +0000 (05:11 +0000)]
Fixes:
Originally, I thought the problem was caused by a function that gets
called as a normal function where we want to return a value, and as a
signal handler where we need to have it accept a parameter (the signal
number) and it returns nothing, I was going to case the function name in
the signal call as (void (*)(int)).
Looking at all the source, it turns out this function only gets used as
a signal handler, so I set an int parameter and return void.
I have removed the Linux defines because they are not needed. BSD let
this sloppiness slide. Linux gave a compile error.
Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>
Marc G. Fournier [Thu, 1 Aug 1996 05:04:29 +0000 (05:04 +0000)]
Change the TEMPDIR to be obj instead of /tmp
Suggested by: Michael Babcock <michael@kanji.com>
Marc G. Fournier [Thu, 1 Aug 1996 04:53:22 +0000 (04:53 +0000)]
An actual README file for the regression tests
Submitted by: Dr. George
Marc G. Fournier [Thu, 1 Aug 1996 04:51:49 +0000 (04:51 +0000)]
A newer expected.input file for the regression tests
Submitted by: Dr. Geoge
Marc G. Fournier [Wed, 31 Jul 1996 18:59:00 +0000 (18:59 +0000)]
Move port includes from bin/pg_dump/Makefile to Makefile.global
Marc G. Fournier [Wed, 31 Jul 1996 18:52:38 +0000 (18:52 +0000)]
Standardize locations of TCL related files
Submitted by: Dr_George_D_Detlefsen <drgeorge@madmax.ilt.com>
Marc G. Fournier [Wed, 31 Jul 1996 18:48:16 +0000 (18:48 +0000)]
This prevent gcc from complaining about casting a short to a char * and
fixes another complaint.
More fixes from Bruce...
Marc G. Fournier [Wed, 31 Jul 1996 18:43:58 +0000 (18:43 +0000)]
More patches for BSDi from Bruce
Marc G. Fournier [Wed, 31 Jul 1996 18:40:12 +0000 (18:40 +0000)]
Row count patch from Bruce
Marc G. Fournier [Wed, 31 Jul 1996 17:35:13 +0000 (17:35 +0000)]
Fix for <machine.h> bug
Submitted by: Bruce
Marc G. Fournier [Wed, 31 Jul 1996 17:19:49 +0000 (17:19 +0000)]
Re-arrange KRBVERS postition
Suggested by: Daniel Kalchev <daniel@digsys.bg>
Marc G. Fournier [Wed, 31 Jul 1996 06:09:46 +0000 (06:09 +0000)]
A "lost in the archives" patch from Chris Dunlop <chris@atlas.onthe.net.au>
Marc G. Fournier [Wed, 31 Jul 1996 06:05:46 +0000 (06:05 +0000)]
Everyone seems to suggestion this is something that should be there...
#include <sys/termios.h>
Submitted by: Dr. George
Marc G. Fournier [Wed, 31 Jul 1996 02:30:10 +0000 (02:30 +0000)]
Moved src/extend to contrib
Marc G. Fournier [Wed, 31 Jul 1996 02:28:22 +0000 (02:28 +0000)]
already exists in the contrib directory
Marc G. Fournier [Wed, 31 Jul 1996 02:20:59 +0000 (02:20 +0000)]
Added <sys/termios.h> for i386_solaris port
Submitted by: Dr_George_D_Detlefsen <drgeorge@ilt.com>
Marc G. Fournier [Wed, 31 Jul 1996 02:19:23 +0000 (02:19 +0000)]
Fixes:
In postgres95/src/backend/nodes/readfuncs, lines 1188 and 1189,
local_node->relname is taken to point to a NameType, while its
defined as a pointer to char. Both the casting to Name and the
call of namestrcpy should, IMHO, be changed appropriately (first
patch).
As far as I could see from the Linux signal header file,
a signal handler is declared as
typedef void (*__sighandler_t)(int);
Few changes to postgres95/src/backend/storage/lmgr/proc.c seem
appropriate to comply with this.
Finally, postgres95/src/bin/pg_version/pg_version.c defines
a function GetDataHome (by default, returning an integer)
and returns NULL in the function, which isn't an integer...
Submitted by: ernst.molitor@uni-bonn.de
Marc G. Fournier [Wed, 31 Jul 1996 02:11:23 +0000 (02:11 +0000)]
Fixes:
updates the psql.1 manual page for \ options
add row count and ties it to the header option
updated manual pages and comment for above change
got \? to display in one screen-full (almost, \? scrolls off top)
moved \r to \E, and \z to \r (for historical reasons with monitor)
small code alignment cleanup
Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>
Marc G. Fournier [Wed, 31 Jul 1996 02:07:25 +0000 (02:07 +0000)]
Style didn't appeal to some...:)
Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>
Marc G. Fournier [Wed, 31 Jul 1996 02:06:00 +0000 (02:06 +0000)]
Fixes: Floating point exception in psql
Submitted by: Dan McGuirk <mcguirk@indirect.com>
Marc G. Fournier [Tue, 30 Jul 1996 07:56:04 +0000 (07:56 +0000)]
Fixes:
> INDEXED searches in some cases DO NOT WORK.
> Although simple search expressions (i.e. with a constant value on
> the right side of an operator) work, performing a join (by putting
> a field of some other table on the right side of an operator) produces
> empty output.
> WITHOUT indices, everything works fine.
>
submitted by: "Vadim B. Mikheev" <root@ais.sable.krasnoyarsk.su>
Marc G. Fournier [Tue, 30 Jul 1996 07:47:58 +0000 (07:47 +0000)]
More cleanups by "Kurt J. Lidl" <lidl@va.pubnix.com>
Marc G. Fournier [Tue, 30 Jul 1996 07:41:38 +0000 (07:41 +0000)]
More cleandups from: "Kurt J. Lidl" <lidl@va.pubnix.com>
Marc G. Fournier [Mon, 29 Jul 1996 20:58:42 +0000 (20:58 +0000)]
The decode function in psql.c doesn't return anything, so its
declaration is incorrect.
-Kurt
Marc G. Fournier [Mon, 29 Jul 1996 20:52:24 +0000 (20:52 +0000)]
clean up /tmp behind itself
submitted by: bruce
Marc G. Fournier [Mon, 29 Jul 1996 20:51:41 +0000 (20:51 +0000)]
Change ordering of "user modified variables" so that they are at
the top of th efile instead of scattered throughout
Turned off default behavior of compiling with -g enabled
submitted by; bruce
Marc G. Fournier [Mon, 29 Jul 1996 20:49:02 +0000 (20:49 +0000)]
fix a redeclaration error
submitted by Kurt
Marc G. Fournier [Mon, 29 Jul 1996 06:54:01 +0000 (06:54 +0000)]
Modifications for bsdi from Kurt(sp?)
Marc G. Fournier [Sun, 28 Jul 1996 07:08:15 +0000 (07:08 +0000)]
cosmetic changes: char* x changed to char *x
submitted by: bruce
Marc G. Fournier [Sun, 28 Jul 1996 06:59:43 +0000 (06:59 +0000)]
reversed bruces patch to getopt() loop about optarg
submitted by: bruce
Marc G. Fournier [Sun, 28 Jul 1996 06:56:28 +0000 (06:56 +0000)]
fixes: It appears several routines use lcons to store integers rather than
pointers.
submitted by: bruce
Marc G. Fournier [Sun, 28 Jul 1996 06:54:15 +0000 (06:54 +0000)]
small port fixes for sparc_solaris
submitted by: jason
Julian Assange [Sun, 28 Jul 1996 06:48:42 +0000 (06:48 +0000)]
bugfix: if NOREADLINE was not defined and input was not from a tty, then
the getopt() was not executed.
Marc G. Fournier [Sat, 27 Jul 1996 04:38:22 +0000 (04:38 +0000)]
Various fixes required for psql
Submitted by: Bruce
Marc G. Fournier [Sat, 27 Jul 1996 02:55:23 +0000 (02:55 +0000)]
and now, the long awaited PAGER patches from Bruce...
Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>
Marc G. Fournier [Sat, 27 Jul 1996 02:40:45 +0000 (02:40 +0000)]
Further modifications for fixing createuser bug...
Submitted by: Rick Weldon <rick@wisetech.com>
Marc G. Fournier [Sat, 27 Jul 1996 02:29:51 +0000 (02:29 +0000)]
This is a patch to pg_dump which fixes varchar and char printing in the
case where the attribute length is variable (stored as -1). Previously,
you'd get output that looked like:
CREATE TABLE foo (bar varchar(-1));
Monitor and psql don't like this at all :). Here is a fix:
Submitted by: Adam Sussman <myddryn@vidya.com>
Marc G. Fournier [Sat, 27 Jul 1996 02:27:55 +0000 (02:27 +0000)]
My patch to fe-connect.c introduced a new bug which is triggered only, if
Kerberos is being used (attempt to free static memory).
The error was caused by a confusing doublespeak of fe_getauthname():
Returns a pointer to static memory, if you authenticate via Kerberos,
a pointer to dynamic memory otherwise.
Submitted by: Erich Stamberger <eberger@gewi.kfunigraz.ac.at>
Marc G. Fournier [Sat, 27 Jul 1996 02:19:18 +0000 (02:19 +0000)]
Fixed these script sonce and for all?
Submitted by: Rick Weldon <rick@wisetech.com>
Marc G. Fournier [Sat, 27 Jul 1996 02:06:10 +0000 (02:06 +0000)]
corrects the output for a 'SELECT DISTINCT ON ...' at line 2900
submitted by: Dr_George_D_Detlefsen <drgeorge@ilt.com>
Marc G. Fournier [Sat, 27 Jul 1996 02:04:12 +0000 (02:04 +0000)]
Fix where 'make clean' wipes out everything if no obj directory
exists...
Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>
Marc G. Fournier [Fri, 26 Jul 1996 20:39:04 +0000 (20:39 +0000)]
Missed a small patch fro mBruce for BSDi
Marc G. Fournier [Fri, 26 Jul 1996 20:15:40 +0000 (20:15 +0000)]
should always take mail headers out of Makefile files befor ecommitting :)
Marc G. Fournier [Fri, 26 Jul 1996 20:03:21 +0000 (20:03 +0000)]
Minor bug fix
Marc G. Fournier [Fri, 26 Jul 1996 19:58:04 +0000 (19:58 +0000)]
regression Makefile, rev 2
Submitted by: Dr. George
Marc G. Fournier [Thu, 25 Jul 1996 20:45:05 +0000 (20:45 +0000)]
Add in port to DG/UX
Submitted by: "Brian E. Gallew" <geek+@cmu.edu>
Marc G. Fournier [Thu, 25 Jul 1996 20:36:46 +0000 (20:36 +0000)]
Fix applied for NESTLOOP bug
submitted by: vadim@sable.krasnoyarsk.su (Vadim B. Mikheev)
Marc G. Fournier [Thu, 25 Jul 1996 20:01:51 +0000 (20:01 +0000)]
fixed usuage of -ltermcap for psql
submitted by: Bruce Momjian <maillist@candle.pha.pa.us>
Marc G. Fournier [Thu, 25 Jul 1996 19:56:59 +0000 (19:56 +0000)]
improvements to regression testing
submitted by: dr. george
Marc G. Fournier [Thu, 25 Jul 1996 19:48:24 +0000 (19:48 +0000)]
modified i386_solaris port
submitted by: dr. george
Marc G. Fournier [Thu, 25 Jul 1996 19:45:31 +0000 (19:45 +0000)]
multiple define of 'union semun' removed
submitted by: dr. george
Marc G. Fournier [Thu, 25 Jul 1996 07:28:12 +0000 (07:28 +0000)]
moved the FLEX stuf from Makefile.global to here
Marc G. Fournier [Thu, 25 Jul 1996 07:27:08 +0000 (07:27 +0000)]
removed tas.s refernce
Marc G. Fournier [Thu, 25 Jul 1996 07:26:37 +0000 (07:26 +0000)]
Dr George suggested removing Makefile.custom altogether, to reduce
any confusion...so its gone...
Marc G. Fournier [Thu, 25 Jul 1996 06:55:49 +0000 (06:55 +0000)]
Switched from using monitor to using psql
Submitted by: Rick Weldon <rick@wisetech.com>
Marc G. Fournier [Thu, 25 Jul 1996 06:54:26 +0000 (06:54 +0000)]
Removed monitor from compile/install (will eventually be removed
completely)
Julian Assange [Thu, 25 Jul 1996 06:46:35 +0000 (06:46 +0000)]
Large re-write/enhancement. In pg-101 Jolly only included a smaller part
of my (proff) patch. This is the rest of it, with a few, mainly aesthetic
changes. I've removed a lot of redundency from the original code,
added support for the new PQprint() routines in libpq, expanded tables,
and a few generally nifty ways of massaging data in and out of the
backend. Still needs some good stress testing.
Julian Assange [Thu, 25 Jul 1996 06:21:11 +0000 (06:21 +0000)]
PQprint() routines. The older code is still there for historical
compatibility. There isn't much difference here against my previous
PQprint() code, except that you can add optional arguments to the
<table args> in html.
Marc G. Fournier [Thu, 25 Jul 1996 01:11:15 +0000 (01:11 +0000)]
Ack, -I$(srcdir)/backend *is* required...
Marc G. Fournier [Thu, 25 Jul 1996 00:30:02 +0000 (00:30 +0000)]
comment out USE_TCL...having USE_TCL=true seems to imply that you
have to have TCL to use postgres95, which you don't
Marc G. Fournier [Thu, 25 Jul 1996 00:26:21 +0000 (00:26 +0000)]
there are no includes files in backend, there should be, so why look
there?
Marc G. Fournier [Thu, 25 Jul 1996 00:22:19 +0000 (00:22 +0000)]
Fix compiler not finding libpgtcl.h header file
Marc G. Fournier [Thu, 25 Jul 1996 00:19:42 +0000 (00:19 +0000)]
Added an empty Makefile.custom file...
Marc G. Fournier [Tue, 23 Jul 1996 05:51:29 +0000 (05:51 +0000)]
Ack, missed two files from the merge...looks like a .11 is goin gto have
to go out after all :(
Marc G. Fournier [Tue, 23 Jul 1996 05:44:10 +0000 (05:44 +0000)]
iBrought in a fix for backend crashes
Submitted by: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Marc G. Fournier [Tue, 23 Jul 1996 05:24:35 +0000 (05:24 +0000)]
comment out inclue of Makefile.custom, as i tbreaks compiling the
bin directory
Marc G. Fournier [Tue, 23 Jul 1996 03:38:44 +0000 (03:38 +0000)]
Last changes to src from Dr. George *wipes brow*
Marc G. Fournier [Tue, 23 Jul 1996 03:35:14 +0000 (03:35 +0000)]
Alot of "changes" from Dr. George's source tree...
Most of the changes in here look to b epurely cosmetic, and don't
affect anything...
...and some stuff is completely questionable...in that I may have reversed
some of the stuf fwe already had :(
Marc G. Fournier [Tue, 23 Jul 1996 03:24:47 +0000 (03:24 +0000)]
More Merge's from Dr' sourec tree
Marc G. Fournier [Tue, 23 Jul 1996 03:19:34 +0000 (03:19 +0000)]
modifications to regressoin tests
Marc G. Fournier [Tue, 23 Jul 1996 03:13:58 +0000 (03:13 +0000)]
More merge's from Dr. George's sourec tree
Marc G. Fournier [Tue, 23 Jul 1996 03:05:23 +0000 (03:05 +0000)]
spelling error...and correction
Marc G. Fournier [Tue, 23 Jul 1996 03:03:43 +0000 (03:03 +0000)]
Put in a new FAQ
Merged in Dr. George's src/bin tree (possibly broke monitor/psql in process)
Marc G. Fournier [Tue, 23 Jul 1996 02:26:41 +0000 (02:26 +0000)]
reversed julian's patch back in again...othere things cause monitor
to not compile now...
Marc G. Fournier [Tue, 23 Jul 1996 02:23:54 +0000 (02:23 +0000)]
Finished merging in src/backend from Dr. George's source tree
Marc G. Fournier [Mon, 22 Jul 1996 23:30:57 +0000 (23:30 +0000)]
More of Dr. George's changes...
- src/backend/catalog/*
- no changes
- src/backend/executor/*
- change how nodeHash.c handles running out of memory
- src/backend/optimizer/*
- mostly cosmetic changes
Marc G. Fournier [Mon, 22 Jul 1996 23:00:26 +0000 (23:00 +0000)]
More merges from Dr. George's tree...
- src/backend/tcop/*
- cosmetic changes to OPENLINK patches
- src/backend/storage/*
- more changes, mostly cosmetic
- src/backend/ports/*
- merge in patches for aix and i386_solaris
Marc G. Fournier [Mon, 22 Jul 1996 21:58:28 +0000 (21:58 +0000)]
- merging in Dr. George's tree with ours
- src/backend/access
- no changes
- src/backend/utils
- mostly cosmetic changes
- ESCAPE_PATCH Added
- src/Makefile.global changes merged
Marc G. Fournier [Mon, 22 Jul 1996 08:37:00 +0000 (08:37 +0000)]
Brought in David Bennett's (dave@bensoft.com) changes to pg_dump
Marc G. Fournier [Mon, 22 Jul 1996 05:59:53 +0000 (05:59 +0000)]
Backed out the changes to monitor.c that seem to be affecting the
ability for createuser to actually create one...
Marc G. Fournier [Mon, 22 Jul 1996 05:13:32 +0000 (05:13 +0000)]
- added LD_ADD+=-ltermcap to postgres.mk.bsdi_2_1
- submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Mon, 22 Jul 1996 04:51:05 +0000 (04:51 +0000)]
quick fix to src/bin/Makefile.global so that compiling doesn't look for a
libpq that is already installed...
submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Sat, 20 Jul 1996 08:44:45 +0000 (08:44 +0000)]
Fix for:
>
> We did some testing and found that if we name the table 'Inv' with
> anything appended to it, the table does not appear in the '\d' table list.
> It appears to be the capital I as a table named 'invItemsL' is created
> and displayed properly.
>
- submitted by: Jason Wright <jason@shiloh.vnet.net>
Marc G. Fournier [Sat, 20 Jul 1996 08:36:33 +0000 (08:36 +0000)]
Brought in NEOSOFT's port to i386_solaris
Submitted by: Randy Kunkee <kunkee@Starbase.NeoSoft.COM>
Marc G. Fournier [Sat, 20 Jul 1996 08:19:13 +0000 (08:19 +0000)]
Fixes:
Hash indices for some data types don't work, for example for time and date.
- submitted by: Massimo Dal Zotto <dz@cs.unitn.it>