OSDN Git Service
Marc G. Fournier [Tue, 18 Mar 1997 21:40:41 +0000 (21:40 +0000)]
This is an attempt to get rid of some cruft...
According to man page under FreeBSD for sys_errlist[], strerror() should be
used instead...not sure if this will break other systems, so only changing
two files for now, and we'll see what "errors" it turns up
Marc G. Fournier [Tue, 18 Mar 1997 21:30:41 +0000 (21:30 +0000)]
Patch from Sven Verdoolaege <skimo@breughel.ufsia.ac.be> for large_objects
Marc G. Fournier [Tue, 18 Mar 1997 20:15:39 +0000 (20:15 +0000)]
- Move most of the I/O in both libpq and the backend to a set
of common routines in pqcomprim.c (pq communication primitives).
Not all adapted to it yet, but it's a start.
- Rewritten some of those routines, to write/read bigger chunks of
data, precomputing stuff in buffers instead of sending out byte
by byte.
- As a consequence, I need to know the endianness of the machine.
Currently I rely on getting it from machine/endian.h, but this
may not be available everywhere? (Who the hell thought it was
a good idea to pass integers to the backend the other way around
than the normal network byte order? *argl*)
- Libpq looks in the environment for magic variables, and upon
establishing a connection to the backend, sends it queries
of the form "SET var_name TO 'var_value'". This needs a change
in the backend parser (Mr. Parser, are you there? :)
- Currently it looks for two Env-Vars, namely PG_DATEFORMAT
and PG_FLOATFORMAT. What else makes sense? PG_TIMEFORMAT?
PG_TIMEZONE?
From: "Martin J. Laubach" <mjl@wwx.vip.at>
Marc G. Fournier [Tue, 18 Mar 1997 18:41:37 +0000 (18:41 +0000)]
Patches for Vadim's multikey indexing...
Marc G. Fournier [Tue, 18 Mar 1997 18:31:43 +0000 (18:31 +0000)]
Add in Vadim's multikey functions/examples as part of contrib
Marc G. Fournier [Tue, 18 Mar 1997 16:36:50 +0000 (16:36 +0000)]
Resync the source tree, commit some things that were missing (pqcomprim.c) and
bring in Thomas's updates for the date/time code...
Marc G. Fournier [Mon, 17 Mar 1997 22:05:08 +0000 (22:05 +0000)]
Fixes for libpgtcl from Massimo
Marc G. Fournier [Mon, 17 Mar 1997 19:03:05 +0000 (19:03 +0000)]
Add in a check for libcrypt.a
Pointed out by Martin
Marc G. Fournier [Sun, 16 Mar 1997 20:40:52 +0000 (20:40 +0000)]
oracle_compat.c fixed for function overloading...
By: From: Edmund Mergl <mergl@nadia.s.bawue.de>
Marc G. Fournier [Sun, 16 Mar 1997 19:06:04 +0000 (19:06 +0000)]
Don't forget the fe-connect.h include file
Marc G. Fournier [Sun, 16 Mar 1997 19:05:00 +0000 (19:05 +0000)]
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Subject: [HACKERS] Patches for 970316 compilation
I made a small pre-emptive change in the new datetime code to eliminate
calls to infnan(). Hopefully this will make Solaris (and probably other
non-GNUlib) systems happier. Didn't find fe-connect.h in the 970316
distribution, so made one up. Also, one of the test routines needs an
update for the geo-decls.h -> geo_decls.h name change.
Patches appear below...
Marc G. Fournier [Sun, 16 Mar 1997 18:51:29 +0000 (18:51 +0000)]
om: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at>
Subject: [HACKERS] Patch for io routines
I am currently trying to improve on the front-backend communication
routines; and noticed that lots of code are duplicated for libpq and
the backend. This is a first patch that tries to share code between
the two, more to follow.
mjl
Marc G. Fournier [Sun, 16 Mar 1997 05:32:03 +0000 (05:32 +0000)]
Header file fixes for MINDOUBLE
Marc G. Fournier [Sun, 16 Mar 1997 05:12:08 +0000 (05:12 +0000)]
Add a conditional for <values.h> vs <limits.h>
Marc G. Fournier [Sun, 16 Mar 1997 01:17:49 +0000 (01:17 +0000)]
Remove extra functions temporarily while a proper fix is found...
Marc G. Fournier [Sun, 16 Mar 1997 01:16:31 +0000 (01:16 +0000)]
Remove overloaded functions until we can figure out how to get them to work
properly...
Marc G. Fournier [Sat, 15 Mar 1997 19:17:03 +0000 (19:17 +0000)]
NetBSD Shared Library Patch from Martin J. Laubach
Marc G. Fournier [Sat, 15 Mar 1997 06:13:12 +0000 (06:13 +0000)]
Re-oid the oracle_compat functions
Add new "overloaded" oracle_compat functions (see man oracle_compat)
Marc G. Fournier [Sat, 15 Mar 1997 06:03:08 +0000 (06:03 +0000)]
A couple of development scripts by Dan to detect unused and duplicate
oids
Marc G. Fournier [Sat, 15 Mar 1997 06:00:19 +0000 (06:00 +0000)]
Update oracle_compat.c
Marc G. Fournier [Sat, 15 Mar 1997 01:23:58 +0000 (01:23 +0000)]
From: Massimo Dal Zotto <dz@cs.unitn.it>
Subject: [HACKERS] lock debug trace
This is an update to my previous patches for lock debugging, already applied
to the current sources. It adds some improvements in the output messages and
some more output in WaitOnLock(). I have used with success to trace a nasty
deadlock condition on pg_listener.
Marc G. Fournier [Sat, 15 Mar 1997 01:11:54 +0000 (01:11 +0000)]
From: Andrew Martin <martin@biochemistry.ucl.ac.uk>
Just noticed that the psql man page is missing the -T option for specifying
HTML table options.
Marc G. Fournier [Fri, 14 Mar 1997 23:34:16 +0000 (23:34 +0000)]
Date/Time updates from Thomas...
Marc G. Fournier [Fri, 14 Mar 1997 23:21:12 +0000 (23:21 +0000)]
Date/Time updates from Thomas...
Marc G. Fournier [Fri, 14 Mar 1997 16:03:02 +0000 (16:03 +0000)]
> There are some minor fixes to the GEQO.
> Please apply them to the direcory "backend/optimizer/geqo".
> Two new files with different crossover techniques are included.
> Standard procedure is optimization by means of "geqo_erx.c"
> (Edge Recombination Crossover).
From: "Martin S. Utesch" <utesch@aut.tu-freiberg.de>
Marc G. Fournier [Fri, 14 Mar 1997 06:01:40 +0000 (06:01 +0000)]
Last of Dan's hidden tar balls :)
Marc G. Fournier [Fri, 14 Mar 1997 05:58:13 +0000 (05:58 +0000)]
Missed another tar file... :(
Marc G. Fournier [Fri, 14 Mar 1997 05:56:27 +0000 (05:56 +0000)]
Missing bits from Dan's patches...sorry :(
Marc G. Fournier [Wed, 12 Mar 1997 21:28:14 +0000 (21:28 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] timestamp type
OK, last one. This patch adds an ANSI SQL 'timestamp' type.
Marc G. Fournier [Wed, 12 Mar 1997 21:23:16 +0000 (21:23 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] password authentication
This patch adds support for plaintext password authentication. To use
it, you add a line like
host all 0.0.0.0 0.0.0.0 password pg_pwd.conf
to your pg_hba.conf, where 'pg_pwd.conf' is the name of a file containing
the usernames and password hashes in the format of the first two fields
of a Unix /etc/passwd file. (Of course, you can use a specific database
name or IP instead.)
Then, to connect with a password through libpq, you use the PQconnectdb()
function, specifying the "password=" tag in the connect string and also
adding the tag "authtype=password".
I also added a command-line switch '-u' to psql that tells it to prompt
for a username and password and use password authentication.
Marc G. Fournier [Wed, 12 Mar 1997 21:13:19 +0000 (21:13 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] linux/alpha patches
These patches lay the groundwork for a Linux/Alpha port. The port doesn't
actually work unless you tweak the linker to put all the pointers in the
first 32 bits of the address space, but it's at least a start. It
implements the test-and-set instruction in Alpha assembly, and also fixes
a lot of pointer-to-integer conversions, which is probably good anyway.
Marc G. Fournier [Wed, 12 Mar 1997 21:00:17 +0000 (21:00 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] linux/alpha patches
These patches lay the groundwork for a Linux/Alpha port. The port doesn't
actually work unless you tweak the linker to put all the pointers in the
first 32 bits of the address space, but it's at least a start. It
implements the test-and-set instruction in Alpha assembly, and also fixes
a lot of pointer-to-integer conversions, which is probably good anyway.
Marc G. Fournier [Wed, 12 Mar 1997 20:51:33 +0000 (20:51 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] equal column and table name patch
This fixes a bug where selects fail when there is a column with the same
name as the table it's a part of.
Marc G. Fournier [Wed, 12 Mar 1997 20:48:48 +0000 (20:48 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] better access control error messages
This patch replaces the 'no such class or insufficient privilege' with
distinct error messages that tell you whether the table really doesn't
exist or whether access was denied.
Marc G. Fournier [Wed, 12 Mar 1997 20:44:57 +0000 (20:44 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] backend Makefile patch
This patch cleans up backend/Makefile a little bit, and prevents it from
relinking the backend binary when no changes have been made.
Marc G. Fournier [Wed, 12 Mar 1997 20:41:14 +0000 (20:41 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] abort failed transaction patch
This patch allows you to end a transaction that has failed on an error
using the 'ABORT' statement without generating another error message.
(By default you get an error unless you use 'END' to terminate the
transaction, which has already been aborted anyway.)
Marc G. Fournier [Tue, 11 Mar 1997 02:12:17 +0000 (02:12 +0000)]
Add in the sunos4 portname to configure detection
Bruce Momjian [Mon, 10 Mar 1997 15:08:57 +0000 (15:08 +0000)]
Add missing paren.
Marc G. Fournier [Mon, 10 Mar 1997 00:18:09 +0000 (00:18 +0000)]
Massimo's Deadlock patches w/o the #ifdefs
Bruce Momjian [Sun, 9 Mar 1997 23:29:15 +0000 (23:29 +0000)]
Vacuum cleanups from Massimo.
Bruce Momjian [Sun, 9 Mar 1997 20:41:02 +0000 (20:41 +0000)]
Add prototypes for oracle-compat functions. Rename geo-*.c adt to geo_*.c
Bruce Momjian [Sun, 9 Mar 1997 07:12:36 +0000 (07:12 +0000)]
Fix vacuum crash Vadim found.
Bruce Momjian [Fri, 7 Mar 1997 00:59:05 +0000 (00:59 +0000)]
Reverse patch for Vadims problem.
Marc G. Fournier [Fri, 7 Mar 1997 00:47:41 +0000 (00:47 +0000)]
Add man page for oracle compatibility functions
By Edmund
Bruce Momjian [Thu, 6 Mar 1997 22:59:47 +0000 (22:59 +0000)]
Move nextstep into problem/bug section.
Bruce Momjian [Thu, 6 Mar 1997 18:38:35 +0000 (18:38 +0000)]
Fix vacuum bug Vadim found with text fields.
Vadim B. Mikheev [Thu, 6 Mar 1997 11:41:09 +0000 (11:41 +0000)]
Not understandable fix of strange bug in vacuum statistic functions.
Marc G. Fournier [Tue, 4 Mar 1997 05:32:26 +0000 (05:32 +0000)]
This is a set of single row character functions, defined for the datatype
text, which are supposed to behave exactly as their Oracle counterparts.
From: Edmund Mergl <E.Mergl@bawue.de>
Marc G. Fournier [Mon, 3 Mar 1997 23:34:27 +0000 (23:34 +0000)]
Fix the prototype for on_exitpg()
Marc G. Fournier [Mon, 3 Mar 1997 23:26:45 +0000 (23:26 +0000)]
Patch from Martin due to changes in joinrels.c
Bruce Momjian [Sun, 2 Mar 1997 02:40:01 +0000 (02:40 +0000)]
New TODO.
Bruce Momjian [Sun, 2 Mar 1997 02:17:32 +0000 (02:17 +0000)]
Prevent SIGPIPE from crashing server, by Dan McGuirk.
Bruce Momjian [Sun, 2 Mar 1997 02:12:49 +0000 (02:12 +0000)]
Change debug to pretty-print tree, recommended by Darren King.
Bruce Momjian [Sun, 2 Mar 1997 02:09:19 +0000 (02:09 +0000)]
flex 2.5.3 warning from Andrew Martin.
Bruce Momjian [Sun, 2 Mar 1997 02:05:33 +0000 (02:05 +0000)]
Apply date patch from tiemann@cygnus.com,Michael Tiemann.
Bruce Momjian [Sun, 2 Mar 1997 01:34:50 +0000 (01:34 +0000)]
Remove _PAGE_SIZE_ as recommended by Darren King.
Bruce Momjian [Sun, 2 Mar 1997 01:03:44 +0000 (01:03 +0000)]
Remove case-sensitive identifiers. Thanks for Dan McGuirk for a reversal patch.
Bruce Momjian [Sat, 1 Mar 1997 22:22:21 +0000 (22:22 +0000)]
Change machine/limits.h to limits.h.
Bruce Momjian [Sat, 1 Mar 1997 16:44:43 +0000 (16:44 +0000)]
Small regress cleanup.
Bruce Momjian [Sat, 1 Mar 1997 15:26:42 +0000 (15:26 +0000)]
Fix example so it works.
Bruce Momjian [Sat, 1 Mar 1997 15:24:51 +0000 (15:24 +0000)]
Substitute defines for numeric constants in type ids.
Use INT4OID instead of 23.
Marc G. Fournier [Fri, 28 Feb 1997 18:45:17 +0000 (18:45 +0000)]
Make sure anything configure related is removed on a distclean
Marc G. Fournier [Fri, 28 Feb 1997 18:34:58 +0000 (18:34 +0000)]
Create a distclean make directive to handle cleaning out configure
generated files, that shouldn't be removed on a make clean
Pointed out by half the hackers mailing list :)
Marc G. Fournier [Fri, 28 Feb 1997 15:35:50 +0000 (15:35 +0000)]
Remove second 'all' directive
Pointed out by Bruce
Bruce Momjian [Fri, 28 Feb 1997 13:25:16 +0000 (13:25 +0000)]
Allow update x =-3, not just x = -3.
Bruce Momjian [Fri, 28 Feb 1997 11:58:04 +0000 (11:58 +0000)]
Remove old READMEs.
Bruce Momjian [Fri, 28 Feb 1997 10:57:47 +0000 (10:57 +0000)]
Remove SUBSYS.o in port/ on clean.
Bruce Momjian [Fri, 28 Feb 1997 10:30:29 +0000 (10:30 +0000)]
Remove win32 port directory. Forgot to do it earlier.
Bruce Momjian [Thu, 27 Feb 1997 15:05:21 +0000 (15:05 +0000)]
Updated FAQ
Marc G. Fournier [Tue, 25 Feb 1997 18:14:43 +0000 (18:14 +0000)]
Fix, I think, the stdup.o problem reported on those systems without
it.
Marc G. Fournier [Tue, 25 Feb 1997 03:38:23 +0000 (03:38 +0000)]
Change "WARN" message generated if a unique index is attempted on a table/key
containing non-unique data
Vadim B. Mikheev [Sat, 22 Feb 1997 10:08:27 +0000 (10:08 +0000)]
Added: UNIQUE feature to bulkload code.
Marc G. Fournier [Thu, 20 Feb 1997 22:54:18 +0000 (22:54 +0000)]
Make the error message output by AllocateFile() if failes to
open Nulldev a *bit* more user friendly...or, at least, admin
friendly...have it print strerror(errno) as well
Marc G. Fournier [Thu, 20 Feb 1997 18:29:45 +0000 (18:29 +0000)]
Add in port hpux to configure
Pointed out by: Mark Hollomon <mhh@nortel.ca>
Vadim B. Mikheev [Thu, 20 Feb 1997 02:54:09 +0000 (02:54 +0000)]
Fix for queries with 3 or more relations participating in
one clause.
Bruce Momjian [Wed, 19 Feb 1997 20:11:05 +0000 (20:11 +0000)]
Prevent under/over flow of float8 constants in parser. Small regression fix.
Marc G. Fournier [Wed, 19 Feb 1997 19:25:42 +0000 (19:25 +0000)]
Disable GEQO...it seems to be broken as shown by the message to
bugs@postgresql.org concerning updates
Marc G. Fournier [Wed, 19 Feb 1997 14:52:06 +0000 (14:52 +0000)]
Various cleanups to satisfy -Werror, but there are some errors that I'm
not certain how to fix, so left them there and enabled -Wno-error for
this directory for now
Marc G. Fournier [Wed, 19 Feb 1997 14:29:22 +0000 (14:29 +0000)]
rearrange ordering of headers os that postgres.h is first
Marc G. Fournier [Wed, 19 Feb 1997 14:26:42 +0000 (14:26 +0000)]
Remove WIN32 stuff, and improve conformance to configure
Marc G. Fournier [Wed, 19 Feb 1997 14:14:40 +0000 (14:14 +0000)]
Didn't *quite* work the way I thought it would...default'd to clean,
not make all :( Fixed...
Marc G. Fournier [Wed, 19 Feb 1997 14:03:28 +0000 (14:03 +0000)]
Add a clean target so that the root directory gets cleared of all
the "configure" related files on a make clean
Marc G. Fournier [Wed, 19 Feb 1997 13:55:13 +0000 (13:55 +0000)]
Removed a ',' that didn't belong in the timezone test case
Pointed out by: afc@teri.superlink.net
Marc G. Fournier [Wed, 19 Feb 1997 13:18:48 +0000 (13:18 +0000)]
Add v6.1/Enhancements Section...or at least start it
Marc G. Fournier [Wed, 19 Feb 1997 13:11:58 +0000 (13:11 +0000)]
And, make sure that initdb.sh copies the pg_geqo.sample file to
${DATADIR}. The file is left as pg_geqo.sample, since, unlike
pg_hba.conf, it isn't a required file...but this way ppl know that
its there, and that its where it is required, if they choose to
use it
Marc G. Fournier [Wed, 19 Feb 1997 13:09:34 +0000 (13:09 +0000)]
Add and install the pg_geqo.sample file
Marc G. Fournier [Wed, 19 Feb 1997 13:04:24 +0000 (13:04 +0000)]
Add the GEQO Todo file too
Marc G. Fournier [Wed, 19 Feb 1997 13:03:23 +0000 (13:03 +0000)]
Add the GEQO README file to the docs distribution
Marc G. Fournier [Wed, 19 Feb 1997 12:59:07 +0000 (12:59 +0000)]
Merge in GEQO Optimizer
From: "Martin S. Utesch" <utesch@aut.tu-freiberg.de>
Bruce Momjian [Wed, 19 Feb 1997 01:31:30 +0000 (01:31 +0000)]
Delete -e option to postmaster, keep postgres -e option.
Bruce Momjian [Tue, 18 Feb 1997 17:14:25 +0000 (17:14 +0000)]
Update btree patches that were missed.
Bruce Momjian [Tue, 18 Feb 1997 04:13:57 +0000 (04:13 +0000)]
Clarify clearing of attribute stats memory.
Bruce Momjian [Fri, 14 Feb 1997 23:02:29 +0000 (23:02 +0000)]
Oper_right added, broken with const. conversion.
Bruce Momjian [Fri, 14 Feb 1997 22:47:36 +0000 (22:47 +0000)]
Add prototypes and remove unused variables from btree Fastbuild patch.
Bruce Momjian [Fri, 14 Feb 1997 04:52:59 +0000 (04:52 +0000)]
Remove hardcoded 20000 and change to BootstrapObjectIdData.
Bruce Momjian [Fri, 14 Feb 1997 04:19:07 +0000 (04:19 +0000)]
Remove WIN32 defines. They never worked.
Bruce Momjian [Thu, 13 Feb 1997 15:55:01 +0000 (15:55 +0000)]
Fix naming from proc to prio to fix previous patch.
Bruce Momjian [Thu, 13 Feb 1997 15:40:03 +0000 (15:40 +0000)]
Only allow NULL in the prpoer places.
Marc G. Fournier [Thu, 13 Feb 1997 10:01:05 +0000 (10:01 +0000)]
Bring in Leo's <lsh@lubrizol.com> massive changes to libpq++
Marc G. Fournier [Thu, 13 Feb 1997 09:54:14 +0000 (09:54 +0000)]
Improvements to the ultrix port, in particular a bunch of compiler
quieting prototyping in port/ultrix4.h
Submitted by: Erik Bertelsen <erik@sockdev.uni-c.dk>