OSDN Git Service
Marc G. Fournier [Thu, 3 Apr 1997 21:31:57 +0000 (21:31 +0000)]
Remove code associated with !ACLGROUP_PATCH, and appropriate #ifdef's
Marc G. Fournier [Thu, 3 Apr 1997 21:26:36 +0000 (21:26 +0000)]
Various improvements to reduce questions :)
Remove USE_LOCALE from Makefile.global.in
Add USE_LOCALE to build/configure/config.h
Add check for BUILDRUN in configure to make sure that build is run before
configure
Marc G. Fournier [Thu, 3 Apr 1997 19:58:11 +0000 (19:58 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [HACKERS] timestamp.c changes
I sent in changes previously and they were rejected because they didn't
follow ANSI spec. Here is the input part of the changes again. Even
though it allows more flexibility for inputting different formats, it
is also backwards compatible with the standard version. I have also
not changed the output format so it will still output the ANSI forms.
Is this acceptable to everyone?
Marc G. Fournier [Thu, 3 Apr 1997 19:56:47 +0000 (19:56 +0000)]
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Subject: [HACKERS] Aggregate function patches
Here are the aggregate function patches I originally sent in last December.
They fix sum() and avg() behavior for ints and floats when NULL values are
involved.
I was waiting to resubmit these until I had a chance to write a v6.0->v6.1
database upgrade script to ensure that existing v6.0 databases which have
not been reloaded for v6.1 do no break with the new aggregate behavior.
These scripts are included below. It's OK with me if someone wants to do
something different with the upgrade strategy, but something like this
was discussed a few weeks ago.
Also, there were a couple of small items which cropped up in doing a clean
install of 970403 (actually 970402 + 970403 changes since the full 970403
tar file appears to be damaged or at least suspect). They are the first
two patches below and can be omitted if desired (although I think they
aren't dangerous :).
Marc G. Fournier [Wed, 2 Apr 1997 18:49:24 +0000 (18:49 +0000)]
removed as already installed as part of system headers on NetBSD/FreeBSD
Marc G. Fournier [Wed, 2 Apr 1997 18:36:24 +0000 (18:36 +0000)]
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Subject: [HACKERS] More date time functions
Here are some additional patches mostly related to the date and time
data types. It includes some type conversion routines to move between
the different date types and some other date manipulation routines such
as date_part(units,datetime).
I noticed Edmund Mergl et al's neat trick for getting function overloading
for builtin functions, so started to use that for the date and time stuff.
Later, if someone figures out how to get function overloading directly
for internal C code, then we can move to that technique.
These patches include documentation updates (don't faint!) for the built-in
man page. Doesn't yet include mention of timestamp, since I don't know
much about it and since it may change a bit to become a _real_ ANSI timestamp
which would include parser support for the declaration syntax (what do you
think, Dan?).
The patches were developed on the 970330 release, but have been rebuilt
off of the 970402 release. The first patch below is to get libpq to compile,
on my Linux box, but is not related to the rest of the patches and you can
choose not to apply that one at this time. Thanks in advance, scrappy!
Marc G. Fournier [Wed, 2 Apr 1997 18:26:25 +0000 (18:26 +0000)]
From: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at>
Subject: [HACKERS] libpq variable set patch
Just a small change, so the automatic variable setting on
connection startup actually works...
Marc G. Fournier [Wed, 2 Apr 1997 18:24:52 +0000 (18:24 +0000)]
From: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at>
Subject: [HACKERS] Patch: SET var TO 'val'
Here is a patch that adds a "SET variable TO 'somevalue'" capability
to the parser, and then calls the SetPGVariable() function (which does
just issue a elog(NOTICE) to see whether it works).
That's the framework for adding timezone/date format/language/...
stuff.
Marc G. Fournier [Wed, 2 Apr 1997 18:16:49 +0000 (18:16 +0000)]
From: Anton de Wet <adw@obsidian.co.za>
Subject: [HACKERS] Small patch to pgtclCmds.c
Hi I have made the following small change to the extensions I made to
pgtclCmds.c quite a while ago.
At the moment there is a -assignbyidx option to pg_result assigning the
returned tuples to an array by using the 1st field of the select statement
as the key to the array.
eg "select name,age from vitalstatistics" will result in an array with
myarray(peter) = 32
myarray(paul) = 45
Often I need to have a pseudo-multi dimentional
array eg. "select name,age from vitalstatistics where occupation='plummer'
I would like to be able to generate an array
newarray(peter,overpaid) = 32
So to add a arbitrary string to the key value I have extended
pg_result $res -assignbyidx $arrayname
to have an optional argument
pg_result $res -assignbyidx $arrayname $appendstr
So that that string is appended to the key value.
Marc G. Fournier [Wed, 2 Apr 1997 18:13:47 +0000 (18:13 +0000)]
From: Oleg Bartunov <oleg@sai.msu.su>
Subject: [HACKERS] locale patches !
Hi there,
here are little patches to get Postgres 6.1 works with locale stuff.
This is a patch against 970402.tar.gz, there are no problem to apply them
by hand to 6.0 release. Collate stuff tested about 1-2 months in real
working database but I'm sure there must be no problem. US hackers
could vote against locale implementation ( locale for sure will affect to
speed of postgres ), so I introduce variable USE_LOCALE which
controls locale stuff. Non-US users now could use ~* operator
for searching and <order by> for strings with nation alphabet.
Please, don't forget, as I did first time, to set environment variable
LC_CTYPE and LC_COLLATE because backend get locale information from them.
I start postmaster from a little script, assuming that shell is Bash shell
it looks like:
#!/bin/sh
export LC_CTYPE=koi8-r
export LC_COLLATE=koi8-r
postmaster -B 1024 -S -D/usr/local/pgsql/data/ -o '-Fe'
Vadim B. Mikheev [Wed, 2 Apr 1997 04:49:13 +0000 (04:49 +0000)]
New keyword: SEQUENCE.
Vadim B. Mikheev [Wed, 2 Apr 1997 04:20:00 +0000 (04:20 +0000)]
Manuals for SEQUENCEs.
Vadim B. Mikheev [Wed, 2 Apr 1997 04:18:26 +0000 (04:18 +0000)]
\h create/drop sequence.
Vadim B. Mikheev [Wed, 2 Apr 1997 04:17:27 +0000 (04:17 +0000)]
Dumping sequence relations as 'CREATE SEQUENCE ...'.
Vadim B. Mikheev [Wed, 2 Apr 1997 04:06:32 +0000 (04:06 +0000)]
Call DefineSequence () for T_CreateSeqStmt node.
Vadim B. Mikheev [Wed, 2 Apr 1997 04:04:11 +0000 (04:04 +0000)]
Can't INSERT/UPDATE/DELETE sequence relation.
Vadim B. Mikheev [Wed, 2 Apr 1997 04:01:03 +0000 (04:01 +0000)]
CREATE/DROP SEQUENCE ...
Check nextval/currval permission in analyze.c.
Vadim B. Mikheev [Wed, 2 Apr 1997 03:57:06 +0000 (03:57 +0000)]
Can't COPY TO sequence relation.
Can't inherits from ...
Vadim B. Mikheev [Wed, 2 Apr 1997 03:51:23 +0000 (03:51 +0000)]
Sequence numbers generators code.
Vadim B. Mikheev [Wed, 2 Apr 1997 03:48:01 +0000 (03:48 +0000)]
vc_getrels(p, VacRelP) returns NIL for special relations (indices,
sequences,...) and vc_delhilowstats(NULL->vrl_relid) ...
Vadim B. Mikheev [Wed, 2 Apr 1997 03:41:16 +0000 (03:41 +0000)]
Hack for heap_creat to enable relkind to be 'S' for sequences.
Vadim B. Mikheev [Wed, 2 Apr 1997 03:38:02 +0000 (03:38 +0000)]
CloseSequences () at xact commit/abort.
Vadim B. Mikheev [Wed, 2 Apr 1997 03:34:46 +0000 (03:34 +0000)]
New node T_CreateSeqStmt.
Vadim B. Mikheev [Wed, 2 Apr 1997 03:29:37 +0000 (03:29 +0000)]
New relkind ('S') for sequence relations.
New funcs (nextval & currval) in pg_proc.h
Vadim B. Mikheev [Wed, 2 Apr 1997 03:23:38 +0000 (03:23 +0000)]
Prototypes for sequence.c
Marc G. Fournier [Wed, 2 Apr 1997 00:34:23 +0000 (00:34 +0000)]
Use $(CC), not gcc, to compile
Pointed out by: igor@cs.cs.miami.edu
Marc G. Fournier [Tue, 1 Apr 1997 09:27:11 +0000 (09:27 +0000)]
Misc port related issues
Marc G. Fournier [Fri, 28 Mar 1997 09:43:53 +0000 (09:43 +0000)]
Slight Linux related bug pointed out by Gabriel Akos <gabriel@rocker.sch.bme.hu>
Marc G. Fournier [Fri, 28 Mar 1997 07:18:06 +0000 (07:18 +0000)]
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Subject: [HACKERS] Small date patches (resubmitted)
Here a some small patches for the date/time code. They set the default
output format for the datetime type to the traditional Postgres
style, and fix a date debugging declaration. I submitted these
a couple of days ago, but they might have gotten lost...
NOTE: the second patch to dt.c is what I believe D'Arcy submitted as well,
that I claimed was taken out...sorry D'Arcy, my fault :(
Marc G. Fournier [Fri, 28 Mar 1997 07:13:21 +0000 (07:13 +0000)]
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Subject: Re: [HACKERS] abstime "now" broken
Yes, I broke 'now' :( with an attempt at a bug fix involving
servers running in the UTC/GMT timezone. These patches fix
the problem, and have been tested in GMT (+00 hours),
PST (-08), and NZT (+12) timezones which exercized the code for
various cases including across day boundaries. btw, this code
fixes the same type of problem for 'today', 'yesterday', 'tomorrow',
for DATETIME, ABSTIME, DATE and TIME types.
The bugfix itself is quite small, but I have accumulated other
changes in the datetime data type and include them here also.
One set of changes involves printing ISO-formatted dates and
is in response to the helpful information from Kurt Lidl regarding
ANSI SQL dates. I'll send another e-mail sometime soon discussing
more issues he has raised...
Marc G. Fournier [Fri, 28 Mar 1997 07:06:53 +0000 (07:06 +0000)]
From: Dan McGuirk <mcguirk@indirect.com>
Reply-To: hackers@hub.org, Dan McGuirk <mcguirk@indirect.com>
To: hackers@hub.org
Subject: [HACKERS] tmin writeback optimization
I was doing some profiling of the backend, and noticed that during a certain
benchmark I was running somewhere between 30% and 75% of the backend's CPU
time was being spent in calls to TransactionIdDidCommit() from
HeapTupleSatisfiesNow() or HeapTupleSatisfiesItself() to determine that
changed rows' transactions had in fact been committed even though the rows'
tmin values had not yet been set.
When a query looks at a given row, it needs to figure out whether the
transaction that changed the row has been committed and hence it should pay
attention to the row, or whether on the other hand the transaction is still
in progress or has been aborted and hence the row should be ignored. If
a tmin value is set, it is known definitively that the row's transaction
has been committed. However, if tmin is not set, the transaction
referred to in xmin must be looked up in pg_log, and this is what the
backend was spending a lot of time doing during my benchmark.
So, implementing a method suggested by Vadim, I created the following
patch that, the first time a query finds a committed row whose tmin value
is not set, sets it, and marks the buffer where the row is stored as
dirty. (It works for tmax, too.) This doesn't result in the boost in
real time performance I was hoping for, however it does decrease backend
CPU usage by up to two-thirds in certain situations, so it could be
rather beneficial in high-concurrency settings.
Marc G. Fournier [Fri, 28 Mar 1997 06:55:58 +0000 (06:55 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
#ifdef is looking for the wrong value.
Marc G. Fournier [Fri, 28 Mar 1997 06:54:51 +0000 (06:54 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Some systems require limits.h to define DBL_MIN.
Marc G. Fournier [Fri, 28 Mar 1997 06:53:50 +0000 (06:53 +0000)]
On some systems limits.h is needed to define DBL_MIN.
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Vadim B. Mikheev [Thu, 27 Mar 1997 04:13:44 +0000 (04:13 +0000)]
Added call to heap_endscan in IndexIsUniqueNoCache - to release
our READ lock on pg_index and let others to create indices too !
Marc G. Fournier [Thu, 27 Mar 1997 01:00:41 +0000 (01:00 +0000)]
turn GEQO code on by default
Marc G. Fournier [Wed, 26 Mar 1997 07:10:03 +0000 (07:10 +0000)]
Remove customize in favor of 'build'
Marc G. Fournier [Wed, 26 Mar 1997 06:54:01 +0000 (06:54 +0000)]
Add ability to change installation directory in build, prior to configure
Marc G. Fournier [Wed, 26 Mar 1997 03:27:04 +0000 (03:27 +0000)]
Add string.h for strerror() prototype
Marc G. Fournier [Wed, 26 Mar 1997 03:14:37 +0000 (03:14 +0000)]
include float.h *after* postgres.h :(
Vadim B. Mikheev [Wed, 26 Mar 1997 03:05:28 +0000 (03:05 +0000)]
Disallow to create multi-column indices using non-btree.
Marc G. Fournier [Wed, 26 Mar 1997 03:02:15 +0000 (03:02 +0000)]
need float.h under FreeBSD for DBL_MIN
Vadim B. Mikheev [Wed, 26 Mar 1997 03:01:29 +0000 (03:01 +0000)]
'\h create index' shows that multi-column indices are available now.
Vadim B. Mikheev [Wed, 26 Mar 1997 02:52:49 +0000 (02:52 +0000)]
Added syntax for multi-column indices.
Vadim B. Mikheev [Wed, 26 Mar 1997 02:24:38 +0000 (02:24 +0000)]
Someone forgot about 'case sizeof(int32)' for
tupleDesc->attrs[i]->attlen in fastgetiattr.
Marc G. Fournier [Tue, 25 Mar 1997 20:02:42 +0000 (20:02 +0000)]
Add checs for float.h
Remove 'unused variable' from dt.c
Marc G. Fournier [Tue, 25 Mar 1997 20:00:52 +0000 (20:00 +0000)]
Add float.h for DBL_{MIN,MAX} under FreeBSD
Marc G. Fournier [Tue, 25 Mar 1997 09:44:33 +0000 (09:44 +0000)]
another one missed
Marc G. Fournier [Tue, 25 Mar 1997 09:44:00 +0000 (09:44 +0000)]
MIssed adding a file to the repository
Marc G. Fournier [Tue, 25 Mar 1997 09:25:33 +0000 (09:25 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [HACKERS] backend/utils/adt/timestamp.c
Back to this timezone stuff. The struct tm has a field (tm_gmtoff) which
is the offset from UTC (GMT is archaic BTW) in seconds. Is this the
value you are looking for when you use timezone? Note that this applies
to NetBSD but it does not appear to be in either ANSI C or POSIX. This
looks like one of those things that is just going to have to be hand
coded for each platform.
Why not just store the values in UTC and use localtime instead of
gmtime when retrieving the value?
Also, you assume the time is returned as a 4 byte integer. In fact,
there is not even any requirement that time be an integral value. You
should use time_t here.
The input function seems unduly restrictive. Somewhere in the sources
there is an input function that allows words for months. Can't we do
the same here?
There is a standard function, difftime, for subtracting two times. It
deals with cases where time_t is not integral. There is, however, a
small performance hit since it returns a double and I don't believe
there is any system currently which uses anything but an integral for
time_t. Still, this is technically the correct and portable thing to do.
The returns from the various comparisons should probably be a bool.
Marc G. Fournier [Tue, 25 Mar 1997 09:21:59 +0000 (09:21 +0000)]
Various patches for shared libraries under i386-solaris by:
Christoph Kaesling <ck@dog.pfalz.sub.de>
Marc G. Fournier [Tue, 25 Mar 1997 09:08:06 +0000 (09:08 +0000)]
Here's two more diffs...
The first fixes a warning from gcc about the assignment within the condition.
The extra set of parens should not make a difference, but with -Werror, they
are necessary.
The second fixes an "ln -s" invocation that assumes the current directory is
implicitly the target if not specified. Not true in all cases, and again, it
should not make a difference except to those implementation that it does.
From: "Michael P. Snyder" <msnyder@hawkeye.huntersmoon.com>
Marc G. Fournier [Tue, 25 Mar 1997 08:25:47 +0000 (08:25 +0000)]
Rather than make this a Linux test, we should just test for the existence
of endian.h. I figure that if it exists it's pretty sure that it has
the byte order information and we may catch some other ports without
any further testing.
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Marc G. Fournier [Tue, 25 Mar 1997 08:14:25 +0000 (08:14 +0000)]
Use $(LD_ADD) from Makefile.global instead of $(LDADD), which doesn't exist...
Pointed out indirectly by D'Arcy
Marc G. Fournier [Tue, 25 Mar 1997 08:11:24 +0000 (08:11 +0000)]
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Subject: [HACKERS] More patches for date/time
I have accumulated several patches to add functionality to the datetime
and timespan data types as well as to fix reported porting bugs on non-BSD
machines. These patches are:
dt.c.patch - add datetime_part(), fix bugs
dt.h.patch - add quarter and timezone support, add prototypes
globals.c.patch - add time and timezone variables
miscadmin.h.patch - add time and timezone variables
nabstime.c.patch - add datetime conversion routine
nabstime.h.patch - add prototypes
pg_operator.h.patch - add datetime operators, clean up formatting
pg_proc.h.patch - add datetime functions, reassign conflicting date OIDs
pg_type.h.patch - add datetime and timespan data types
The dt.c and pg_proc.h patches are fairly large; the latter mostly because I tried
to get some columns for existing entries to line up.
Marc G. Fournier [Tue, 25 Mar 1997 07:54:53 +0000 (07:54 +0000)]
MOre univel port patches/files from:
"Michael P. Snyder" <msnyder@hawkeye.huntersmoon.com>
Marc G. Fournier [Tue, 25 Mar 1997 07:16:36 +0000 (07:16 +0000)]
Start of a univel port by "Michael P. Snyder" <msnyder@hawkeye.huntersmoon.com>
Vadim B. Mikheev [Tue, 25 Mar 1997 04:10:21 +0000 (04:10 +0000)]
Free memory allocated by command in the BlankPortal' HeapMemory context
(#ifdef-ed).
Marc G. Fournier [Tue, 25 Mar 1997 02:37:21 +0000 (02:37 +0000)]
- Renamed the variable names to something shorter, and I hope
nicer. Also, I grabbed my copy of the Informix manual, and
added a couple of variables that make sense (formats for
money, time, a language setting, a timezone).
- New functions SetPGVariable() and GetPGVariable() in tcop/*.
These don't actually do anything for the moment, but should
be enough to implement the SET var_name TO var_val in the
parser?
SetPGVariable() expects just two strings, the var_name and
the var_value from above, and is expected to do the right thing.
Returns TRUE if everything okay.
From: "Martin J. Laubach" <mjl@wwx.vip.at>
Marc G. Fournier [Tue, 25 Mar 1997 02:29:08 +0000 (02:29 +0000)]
Add in alpha port
Marc G. Fournier [Tue, 25 Mar 1997 00:54:15 +0000 (00:54 +0000)]
I don't know whether this breaks what the previous person tried to
fix, but figure I"ll know soon enough, eh?
Patch submitted by Dan McGuirk
Marc G. Fournier [Tue, 25 Mar 1997 00:52:12 +0000 (00:52 +0000)]
Needs USE_POSIX_SIGNALS
Pointed out by Dan McGuirk
Vadim B. Mikheev [Mon, 24 Mar 1997 08:48:16 +0000 (08:48 +0000)]
+ NULLs handling
Actually required by multi-column indices support.
We still don't use btree for 'A is (not) null', but
now btree keep items with NULL attrs using single rule
for placing/finding items on pages:
NULLs greater NOT_NULLs and NULL = NULL.
+ Bulkload code (nbtsort.c) support for multi-column indices
building and NULLs.
+ Fix for btendscan()->pfree(scanopaque) from Chris Dunlop.
Vadim B. Mikheev [Mon, 24 Mar 1997 08:04:51 +0000 (08:04 +0000)]
New func _bt_checkkeys() added to let caller know number of keys
for which checking was TRUE.
Vadim B. Mikheev [Mon, 24 Mar 1997 07:39:47 +0000 (07:39 +0000)]
Setting index' attributes attcacheoff to -1 in index_create().
Vadim B. Mikheev [Mon, 24 Mar 1997 07:32:38 +0000 (07:32 +0000)]
Added #define NullValueRegProcedure and #define NonNullValueRegProcedure -
is in use by btree now.
Marc G. Fournier [Fri, 21 Mar 1997 18:58:23 +0000 (18:58 +0000)]
Forgot to add an AC_SUBST(STRERROR) to configure.in for the strerror() test
Thanks to D'Arcy for pointing this one out
Marc G. Fournier [Fri, 21 Mar 1997 18:53:28 +0000 (18:53 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [HACKERS] backend/utils/adt/nabstime.c
There is a problem with some of the calls to strftime. The second arg is
missing. In all cases the buffer is CTZName which, according to the
file init/globals.c, is char CTZName[8] so I have added this value.
I know there should be a #define set up for this but I wasn't sure
which header to put it in.
Marc G. Fournier [Thu, 20 Mar 1997 18:31:49 +0000 (18:31 +0000)]
change strtok(0.. to strtok(NULL..
From: Keith Parks <emkxp01@mtcc.demon.co.uk>
Marc G. Fournier [Thu, 20 Mar 1997 18:23:33 +0000 (18:23 +0000)]
From: "D'Arcy J.M. Cain" <darcy@druid.net>
Subject: [HACKERS] libpq/pqcomm stuff and Solaris byte order
I decided to go ahead with the required changes since no one else seems
to. I don't guarantee that it is perfect but with these changes the
package actually compiles. While I was at it I added to the Sparc
Solaris header to define the byte order. Note that NetBSD sets this
in the system headers so it wasn't required there.
In particular, someone may want to check whether I removed the correct
84 lines from backend/libpq/pqcomprim.c.
Marc G. Fournier [Thu, 20 Mar 1997 18:04:32 +0000 (18:04 +0000)]
Check for and set HAVE_CRYPT_H if <crypt.h> exists
include crypt.h in password.c if crypt.h does exist
Marc G. Fournier [Thu, 20 Mar 1997 07:30:26 +0000 (07:30 +0000)]
use autoconf 2.12 instead of 2.10 to gernate configure script...
*hopefully* will fix the linux configuration problem..?
Vadim B. Mikheev [Wed, 19 Mar 1997 07:52:03 +0000 (07:52 +0000)]
Fix call to index_create in DefineIndex.
Vadim B. Mikheev [Wed, 19 Mar 1997 07:44:45 +0000 (07:44 +0000)]
Fix index_create for multi-column indices
Vadim B. Mikheev [Wed, 19 Mar 1997 07:36:35 +0000 (07:36 +0000)]
Fix index_create for multi-column indices
Marc G. Fournier [Wed, 19 Mar 1997 03:56:50 +0000 (03:56 +0000)]
remove a double declaration/prototype
Marc G. Fournier [Wed, 19 Mar 1997 03:01:32 +0000 (03:01 +0000)]
Remove port.c since it is redundant (well, empty, at least)
Change Makefile to refl removal of portc
Change dynloader.c so that its only used if PRE_BSDI_2_1 is defined
Marc G. Fournier [Wed, 19 Mar 1997 02:37:42 +0000 (02:37 +0000)]
Add a check for strerr, and add in D'Arcy's strerror() code in case not
found
Marc G. Fournier [Wed, 19 Mar 1997 02:13:27 +0000 (02:13 +0000)]
there, that's fixed
Marc G. Fournier [Wed, 19 Mar 1997 02:12:15 +0000 (02:12 +0000)]
Fixing a screw up
Marc G. Fournier [Tue, 18 Mar 1997 21:46:31 +0000 (21:46 +0000)]
From: Jun Kuwamura <juk@rccm.co.jp>
Subject: [HACKERS] auth.c for kerberos.
I made pgsql with eBones(international version of Kerberos4). The
following modification was needed. And I added read permition for
group to srvtab instead of running postmaster as root.
Marc G. Fournier [Tue, 18 Mar 1997 21:43:06 +0000 (21:43 +0000)]
Replace strsep() by strtok()
By: Dan McGuirk <mcguirk@indirect.com>
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)