Marc G. Fournier [Sun, 26 Jan 1997 17:28:48 +0000 (17:28 +0000)]
|From: Keith Parks <emkxp01@mtcc.demon.co.uk>
|Subject: [PATCH] adding SYS_TIME just for fun.
|
|Hi,
|
|Whilst I was playing round with the European dates patch I noticed the sysfunc()
|that allows you to do :-
|
|create table test ( da date);
|insert into test values (SYS_DATE);
|
|and have the current system date inserted.
|
|So I thought it would be nice to have the SYS_TIME facility too.
|
|I've cloned the function and changed a few things and there you have it,
|you can now do:
|
|create table test2 ( ti time);
|insert into test2 values (SYS_TIME);
Marc G. Fournier [Sat, 25 Jan 1997 23:54:08 +0000 (23:54 +0000)]
Remove rlstubs.[ch], since they weren't actually doing anything that couldn't
be #ifdef'd into psql.c itself
From what I can tell, if USE_READLINE is true or false, psql works under
FreeBSD, without configure. Now to test it *again* under sparc_solaris
with configure and see if it works...
Marc G. Fournier [Sat, 25 Jan 1997 21:58:08 +0000 (21:58 +0000)]
Modifications to handle the situation where readline.h exists, but
history.h doesn't...previously, it was assumed that both existed, or
didn't exist...but this assumption fails on the one sparc_solaris box
that I have access to, and could exist in other circumstances
Bruce Momjian [Sat, 25 Jan 1997 21:09:20 +0000 (21:09 +0000)]
would you mind committing the following changes for me? (the first
bug causes compilation to fail on alpha, the second causes a compiler
in this environment
libpq/fe-exec.c modified so that location of termios.h is determined
by whether HAVE_TERMIOS_H is defined or not, in preparation for switch
to configure
Marc G. Fournier [Thu, 23 Jan 1997 22:50:14 +0000 (22:50 +0000)]
Bring in Nat' preliminary work at autoconf'ng PostgreSQL...I imagine
it still needs lots of work, but, hey, at least this way there are more
ppl working off the same "Source"...
Marc G. Fournier [Thu, 23 Jan 1997 19:47:18 +0000 (19:47 +0000)]
The last patch fixes some incongruences in the #define used to compile the
Tcl arrays support. Here are the correct values to be defined in config.h
and pgtclCmds.c.
Marc G. Fournier [Thu, 23 Jan 1997 19:33:31 +0000 (19:33 +0000)]
Patch from Massimo Dal Zotto <dz@cs.unitn.it>
The first patch changes the behavior of aclcheck for groups. Currently an user
can access a table only if he has the required permission for ALL the groups
defined for that table. With my patch he can access a table if he has the
permission for ONE of the groups, which seems to me a more useful thing.
If you think this should be the correct behavior of the acl group check feel
free to remove the #ifdef, if not please add a commented line to config.h.
Marc G. Fournier [Thu, 23 Jan 1997 16:04:25 +0000 (16:04 +0000)]
Fix from Andrew for compiling libpgtcl...basically, switch off -Werror,
which probably isn't needed, since we are going to take off -Werror
anyway, right?
Vadim B. Mikheev [Wed, 22 Jan 1997 06:25:42 +0000 (06:25 +0000)]
1. INDEXSCAN_PATCH changes: (op Param Var) should work too
2. IndexScanableOperand now uses match_indexkey_operand
instead of equal_indexkey_var (if we have some index on attribute X
then we shouldn't use it for 'where some_func(X) OP CONST').
Vadim B. Mikheev [Wed, 22 Jan 1997 05:26:50 +0000 (05:26 +0000)]
Fixing bug in INDEXSCAN_PATCH:
ExecInitIndexScan now works with operands of Param type and
(!!!) postquel_execute() now substitutes param values
before calling postquel_start().
Marc G. Fournier [Wed, 22 Jan 1997 04:41:45 +0000 (04:41 +0000)]
Taking a chance here. Under both Solaris and FreeBSD, there is a
/usr/include/limits.h (which quiets the costsize.c warnings)...under
FreeBSD, /usr/include/limits.h *includes* machine/limits.h, while under
Solaris, there is no such things as /usr/include/machine...
Vadim B. Mikheev [Mon, 20 Jan 1997 04:36:48 +0000 (04:36 +0000)]
Fixing possible losing data changes:
1. New flag - BM_JUST_DIRTIED - added for BufferDesc;
2. All data "dirtiers" (WriteBuffer and WriteNoReleaseBuffer)
set this flag (and BM_DIRTY too);
3. All data "flushers" (FlushBuffer, BufferSync and BufferReplace)
turn this flag off just before calling smgr[blind]write/smgrflush
and check this flag after flushing buffer: if it turned ON then
BM_DIRTY will stay ON.
Vadim B. Mikheev [Mon, 20 Jan 1997 04:01:50 +0000 (04:01 +0000)]
1. Setting rdesc->rd_tmpunlinked to FALSE in heap_creatr () just after
smgrcreate ().
2. Checking rdesc->rd_tmpunlinked in heap_destroy () & heap_destroyr ()
before calling smgrunlink ().
Vadim B. Mikheev [Thu, 16 Jan 1997 08:11:41 +0000 (08:11 +0000)]
No more LateWrite, but there is WriteMode;
SetBufferWriteMode () added;
FlushBuffer () fixed: now directly calls smgrflush () and
releases buffer only if required by caller.