OSDN Git Service
summary |
shortlog | log |
commit |
commitdiff |
tree
first ⋅ prev ⋅ next
Marc G. Fournier [Sat, 20 Jul 1996 07:40:03 +0000 (07:40 +0000)]
- extend conditional for use of -ltermcap in bsdi/bsdi_2_1 compiles
- submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Sat, 20 Jul 1996 07:33:36 +0000 (07:33 +0000)]
fixed a bug with not commenting out FSYNC= in initdb.sh
Marc G. Fournier [Fri, 19 Jul 1996 07:24:11 +0000 (07:24 +0000)]
Fixes:
I have written some patches which add support for NULLs to Postgres95.
In fact support for NULLs was already present in postgres, but it had been
disabled because not completely debugged, I believe. My patches simply add
some checks here and there. To enable the new code you must add -DNULL_PATCH
to CFLAGS in Makefile.global. After recompiling you can do things like:
insert into a (x, y) values (1, NULL);
update a set x = NULL where x = 0;
You can't still use a "where x=NULL" clause, you must use ISNULL instead.
This could probably be an easy fix to do.
Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Fri, 19 Jul 1996 07:19:56 +0000 (07:19 +0000)]
- improve date/time parsing routines
- submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Fri, 19 Jul 1996 07:14:14 +0000 (07:14 +0000)]
Fixes:
Select queries with an isnull or notnull clause, like "select * where
somefield isnull", crash the backend if the table has at least one index.
If the indices are deleted the queries work again. Also the explain
command fail in the same way.
The is caused by a bug in subroutine of the optimizer which doesn't check
null values in the clauses.
Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Fri, 19 Jul 1996 07:00:56 +0000 (07:00 +0000)]
- libpq calls "fe_getauthname()" two times in "fe-connect.c", but
doesn't free the buffer allocated by this function.
- submitted by: Erich Stamberger <eberger@gewi.kfunigraz.ac.at>
Marc G. Fournier [Fri, 19 Jul 1996 06:53:40 +0000 (06:53 +0000)]
- added -ltermcap to LIBS in bin/psql/Makefile
- submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Fri, 19 Jul 1996 06:47:51 +0000 (06:47 +0000)]
Removed -I${HEADERFILE} from bin/Makefile.global
Marc G. Fournier [Fri, 19 Jul 1996 06:36:38 +0000 (06:36 +0000)]
Fix PAGER bug in createuser/etc scripts
submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Fri, 19 Jul 1996 06:27:59 +0000 (06:27 +0000)]
Fixes:
'select distinct on' causes backend to crash
submitted by: Chris Dunlop chris@onthe.net.au
Marc G. Fournier [Fri, 19 Jul 1996 06:13:58 +0000 (06:13 +0000)]
Fixes:
This is a patch to prevent an endless loop occuring in the Postgres backend
when a 'warning' error condition generates another warning error contition
in the handler code.
Submitted by: Chris Dunlop, <chris@onthe.net.au>
Marc G. Fournier [Fri, 19 Jul 1996 06:08:21 +0000 (06:08 +0000)]
fixes for textcat(), but headers were missing from archive :(
Marc G. Fournier [Fri, 19 Jul 1996 05:54:17 +0000 (05:54 +0000)]
Fixes compile errors with irix5 port
Submitted by: Thomas van Reimersdahl <reimersd@dali.techinfo.rwth-aachen.de>
Marc G. Fournier [Fri, 19 Jul 1996 05:32:42 +0000 (05:32 +0000)]
Fixes:
minor Makefile changes to force setting of SRCDIR and ordering of
include files
Submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Fri, 19 Jul 1996 05:21:28 +0000 (05:21 +0000)]
Fixes:
It is not possible to define attributes as arrays of date or time, the
type _time and _date are not defined.
Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Fri, 19 Jul 1996 05:12:40 +0000 (05:12 +0000)]
Fixes:
The type _char16 (array of char16) is incorrectly defined as array of name
and values longer than 16 chars are stored as names and not truncated to 16
bytes as they should be.
Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Thu, 18 Jul 1996 05:48:57 +0000 (05:48 +0000)]
libpq and psql.c have been modified to do various things they didn't do
before (plus some optimisations/bug fixes et al). I've included a small
demo transcript below. Note that all of of the display
functionality/intelligence you see here, can be had merely by calling
the new LIBPQ PQprint() routine with the appropriate arguments/options,
including the HTML3 output guff.
submitted by: Julian Assange <proff@suburbia.net>
Marc G. Fournier [Thu, 18 Jul 1996 04:59:42 +0000 (04:59 +0000)]
Fixes: In the solaris port the file descriptors are hard coded to 20 (from the
include file sys/param.h
Submitted by: michael.siebenborn@ae3.Hypo.DE (Michael Siebenborn (6929))
Marc G. Fournier [Tue, 16 Jul 1996 07:13:58 +0000 (07:13 +0000)]
fix: BSDi 2.1 requires a port seperate from BSDi 2.0{.1}
submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Tue, 16 Jul 1996 06:58:12 +0000 (06:58 +0000)]
fix: clean up formatting of \d tablename in psql
submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Tue, 16 Jul 1996 06:53:41 +0000 (06:53 +0000)]
fix: During a BSD/OS(BSDI) 2.1 compile, I got errors about undefined
S_LOCK_'s during the postgres link phase.
submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Tue, 16 Jul 1996 06:37:28 +0000 (06:37 +0000)]
applied fixes for psql
- \p produces traditional results
- \r added
submitted by: Bruce Momjian (root@candle.pha.pa.us)
Marc G. Fournier [Mon, 15 Jul 1996 19:32:33 +0000 (19:32 +0000)]
adds: case insensitive regexp for varchar
From: azcb0@sde.uts.amdahl.com
Marc G. Fournier [Mon, 15 Jul 1996 19:22:58 +0000 (19:22 +0000)]
fsync patch from openlink
NOTE: FSYNC needs to be set at top of initdb.sh to enable use of fsync
patches...disabled by default
Marc G. Fournier [Mon, 15 Jul 1996 19:22:17 +0000 (19:22 +0000)]
fsync patch from openlink
Marc G. Fournier [Mon, 15 Jul 1996 19:11:23 +0000 (19:11 +0000)]
Submitted by Openlink, requires -DOPENLINK_PATCHES in Makefile.global
varchar.diff
------------
This patch was necessary for the OpenLink Postgres Database Agent.
I think this fixes a bug anyway.
The following query demonstrates this bug:
create table foo (bar varchar);
insert into foo values (''); -- no problem
select * from foo where bar = ''; -- fails
Marc G. Fournier [Mon, 15 Jul 1996 19:10:32 +0000 (19:10 +0000)]
Makefile.global changes to show option -DOPENLINK_PATCHES
Marc G. Fournier [Sat, 13 Jul 1996 07:37:33 +0000 (07:37 +0000)]
Moved two defines required for FreeBSD into Makefile.global
The idea is that its right beside PORTNAME, so if it doesn't apply to
the OS in question, it can be rememberd to disable it...
Marc G. Fournier [Fri, 12 Jul 1996 05:39:39 +0000 (05:39 +0000)]
Brought in extensions to pg_dump
Submitted by: david bennett <dave@bensoft.com>
marc g. fournier <scrappy@ki.net>
Marc G. Fournier [Fri, 12 Jul 1996 04:53:59 +0000 (04:53 +0000)]
fixes for several potential null pointer dereferences
submitted by: Paul "Shag" Walmsley <ccshag@cclabs.missouri.edu>
Marc G. Fournier [Tue, 9 Jul 1996 06:39:19 +0000 (06:39 +0000)]
Fixes: Using LIKE or ~ operator on text type files which are null valued
causes segmentation fault.
Thanks to: Salvador Ortiz Garcia, Robert Patrick, Paul 'Shag' Walmsley,
and James Cooper for finding and fixing the problem.
Marc G. Fournier [Tue, 9 Jul 1996 06:35:38 +0000 (06:35 +0000)]
Fix: Can't drop tables with names longer than 16 characters.
Marc G. Fournier [Tue, 9 Jul 1996 06:22:35 +0000 (06:22 +0000)]
Postgres95 1.01 Distribution - Virgin Sources