OSDN Git Service
Vadim B. Mikheev [Mon, 23 Feb 1998 13:59:34 +0000 (13:59 +0000)]
Second query in select_views.sql is replaced.
Vadim B. Mikheev [Mon, 23 Feb 1998 13:58:04 +0000 (13:58 +0000)]
Fix relation path constraction in mdblindwrt().
Bruce Momjian [Mon, 23 Feb 1998 13:10:53 +0000 (13:10 +0000)]
Remind people of view permissions, and install libpq README.
Vadim B. Mikheev [Mon, 23 Feb 1998 06:28:16 +0000 (06:28 +0000)]
ExecReScan for Unique & Sort nodes.
Bruce Momjian [Mon, 23 Feb 1998 02:54:11 +0000 (02:54 +0000)]
Partial fix for select distinct in subselect.
Bruce Momjian [Sun, 22 Feb 1998 20:02:34 +0000 (20:02 +0000)]
Configure patches from Brook Milligan.
Marc G. Fournier [Sun, 22 Feb 1998 18:03:26 +0000 (18:03 +0000)]
The getColumns() method in DataBaseMetaData.java returns a column size
of -1 for varchar's.
From: CNT systemen BV <cntsys@cistron.nl>
Marc G. Fournier [Sun, 22 Feb 1998 00:02:18 +0000 (00:02 +0000)]
From: Darren King <darrenk@insightdist.com>
Enclosed is the regression.diffs file from running the Feb 21st
snapshot regression tests for inclusion in src/test/regression
as regression.Aix41. Appears to be standard differences to me,
error messages, fp accuracy and times off by an hour due to PST
vs PDT.
Marc G. Fournier [Sat, 21 Feb 1998 19:23:14 +0000 (19:23 +0000)]
Change:
#define TAPETEMP "pg_btsortXXXXXX"
to:
#define TAPETEMP "pg_btsortXXXXXXX"
For some reason, under FreeBSD, it appears that the mktemp() value needs the
extra 'X' to improve/ensure uniqueness
Bruce Momjian [Sat, 21 Feb 1998 18:17:58 +0000 (18:17 +0000)]
Add handling for new RangeTblEntry column name.
Bruce Momjian [Sat, 21 Feb 1998 16:58:49 +0000 (16:58 +0000)]
Constlen can be -1, so make it a signed type.
Marc G. Fournier [Sat, 21 Feb 1998 06:32:15 +0000 (06:32 +0000)]
First step done,
below is the patch to have views to override the permission
checks for the accessed tables. Now we can do the following:
CREATE VIEW db_user AS SELECT
usename,
usesysid,
usecreatedb,
usetrace,
usecatupd,
'**********'::text as passwd,
valuntil
FROM pg_user;
REVOKE ALL ON pg_user FROM public;
REVOKE ALL ON db_user FROM public;
GRANT SELECT ON db_user TO public;
Edmund Mergl [Fri, 20 Feb 1998 21:26:08 +0000 (21:26 +0000)]
1.7.01.7.0
Edmund Mergl [Fri, 20 Feb 1998 21:25:47 +0000 (21:25 +0000)]
1.7.0
Marc G. Fournier [Fri, 20 Feb 1998 14:28:56 +0000 (14:28 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Please remove src/interfaces/ecpg/prproc/y.tab.h from cvs. It is generated
by make anyway.
Marc G. Fournier [Fri, 20 Feb 1998 13:11:26 +0000 (13:11 +0000)]
Missign a comma...
From: AA van Raalte <alvin@camberlo.demon.co.uk>
Marc G. Fournier [Fri, 20 Feb 1998 13:10:03 +0000 (13:10 +0000)]
*** empty log message ***
Marc G. Fournier [Fri, 20 Feb 1998 13:02:14 +0000 (13:02 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Subject: [PATCHES] one small fix for ecpg
Marc G. Fournier [Fri, 20 Feb 1998 02:07:25 +0000 (02:07 +0000)]
Update bugs section of ecpg...
Marc G. Fournier [Fri, 20 Feb 1998 01:44:18 +0000 (01:44 +0000)]
Okay, revert back to non-REVOKED...happy now? :)
Marc G. Fournier [Thu, 19 Feb 1998 17:25:58 +0000 (17:25 +0000)]
From: Andreas.Zeugswetter@telecom.at
Improved fix to pg_user/passwd problem...using rewrite rules
Bruce Momjian [Thu, 19 Feb 1998 17:20:01 +0000 (17:20 +0000)]
Password fix. Now people have to do the REVOKE themselves.
Marc G. Fournier [Thu, 19 Feb 1998 17:08:57 +0000 (17:08 +0000)]
oops, missed one...
Marc G. Fournier [Thu, 19 Feb 1998 17:08:22 +0000 (17:08 +0000)]
Makefile required some cleaning up for install and make
Marc G. Fournier [Thu, 19 Feb 1998 17:02:25 +0000 (17:02 +0000)]
Don't make shared libraries for i386_solaris yet...it doesn't work
Marc G. Fournier [Thu, 19 Feb 1998 16:43:54 +0000 (16:43 +0000)]
Updated from 0.61->0.76
Bruce Momjian [Thu, 19 Feb 1998 15:04:45 +0000 (15:04 +0000)]
FIFO lock wait queue, with readers grouped together.
Marc G. Fournier [Thu, 19 Feb 1998 14:27:33 +0000 (14:27 +0000)]
Various minor modes for i386_solaris
Marc G. Fournier [Thu, 19 Feb 1998 13:59:16 +0000 (13:59 +0000)]
Check for <netinet/in.h>, required by DG/ux
Marc G. Fournier [Thu, 19 Feb 1998 13:52:17 +0000 (13:52 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Here's my next patch. this one should fix some more bugs. ecpg now fully
understands the whenever statement.
Vadim B. Mikheev [Thu, 19 Feb 1998 04:47:07 +0000 (04:47 +0000)]
Fix for InitPlan-s: have to copy subselect' result tuple.
Marc G. Fournier [Thu, 19 Feb 1998 01:44:18 +0000 (01:44 +0000)]
Already moved to the appropriate documentation directories
Bruce Momjian [Wed, 18 Feb 1998 15:56:06 +0000 (15:56 +0000)]
Update FAQ's for release.
Bruce Momjian [Wed, 18 Feb 1998 15:33:37 +0000 (15:33 +0000)]
Fix -t for pg_dump when table is uppercase.
Vadim B. Mikheev [Wed, 18 Feb 1998 13:15:07 +0000 (13:15 +0000)]
Restore 6.2.1 output
Vadim B. Mikheev [Wed, 18 Feb 1998 12:41:36 +0000 (12:41 +0000)]
GroupState changed.
Vadim B. Mikheev [Wed, 18 Feb 1998 12:40:44 +0000 (12:40 +0000)]
New nodeGroup.c code uses own copy of first tuple in a group.
Free memory after comparison in nodeUnique.c
Thomas G. Lockhart [Wed, 18 Feb 1998 07:37:05 +0000 (07:37 +0000)]
Start shipping gram.y products gram.c and parse.h to avoid having to build
them from scratch. gram.y has now grown so that some non-bison yaccs
(including FreeBSDs) run out of room and quit.
Thomas G. Lockhart [Wed, 18 Feb 1998 07:32:17 +0000 (07:32 +0000)]
Add new subselect test.
Thomas G. Lockhart [Wed, 18 Feb 1998 07:29:45 +0000 (07:29 +0000)]
New table from new subselect test.
Thomas G. Lockhart [Wed, 18 Feb 1998 07:28:08 +0000 (07:28 +0000)]
Include products of gram.y to allow systems without bison to build Postgres.
The parser recently grew too big for some yaccs, including FreeBSD.
Thomas G. Lockhart [Wed, 18 Feb 1998 07:25:57 +0000 (07:25 +0000)]
Allow LIKE expression in constraint clause.
Allow USER and VALID as column names and identifiers.
Thomas G. Lockhart [Wed, 18 Feb 1998 07:23:22 +0000 (07:23 +0000)]
Fix parsing for <identifier>-<number> which was mis-identified as a unary
minus. Example is SELECT f1-2 FROM INT4_TBL;
Thomas G. Lockhart [Wed, 18 Feb 1998 07:19:34 +0000 (07:19 +0000)]
Fix from Vadim for simple-minded case SELECT 1 WHERE 1 IN (SELECT 1)
used in regression tests. No longer core dumps.
Thomas G. Lockhart [Wed, 18 Feb 1998 07:16:58 +0000 (07:16 +0000)]
Remove inclusion of the doc make. Looks like all of the man pages are
in the usual man page source directory anyway. Source tree now builds.
Thomas G. Lockhart [Wed, 18 Feb 1998 07:15:23 +0000 (07:15 +0000)]
Cancel last version which introduced unintended flags
for linux-alpha support.
Vadim B. Mikheev [Wed, 18 Feb 1998 03:26:54 +0000 (03:26 +0000)]
Fix useor for (a,b...) Op ANY/ALL
Marc G. Fournier [Wed, 18 Feb 1998 01:30:42 +0000 (01:30 +0000)]
I'm getting a SEGV error when testing ecpg using the perftest,or
any other, example program.
I have tracked this down to a call to PQfinish() in ECPGfinish()
that occurs before any connection is established.
From: Keith Parks <emkxp01@mtcc.demon.co.uk>
Marc G. Fournier [Wed, 18 Feb 1998 01:28:03 +0000 (01:28 +0000)]
Update the preprocessor code
From: Michael Meskes <meskes@topsystem.de>
Marc G. Fournier [Wed, 18 Feb 1998 01:26:02 +0000 (01:26 +0000)]
Check for and include <getopt.h>
Marc G. Fournier [Tue, 17 Feb 1998 02:09:17 +0000 (02:09 +0000)]
Just another missing dummy file
Marc G. Fournier [Tue, 17 Feb 1998 02:00:12 +0000 (02:00 +0000)]
2. IRIX has both HAVE_FPCLASS and HAVE_FP_CLASS, therefore, in
backend/port/isinf.c it tries to compile two versions of
isinf().
From: Andrew Martin <martin@biochemistry.ucl.ac.uk>
Marc G. Fournier [Tue, 17 Feb 1998 01:48:12 +0000 (01:48 +0000)]
Major update of ecpg preprocessor
From: Michael Meskes <meskes@topsystem.de>
Marc G. Fournier [Tue, 17 Feb 1998 01:43:04 +0000 (01:43 +0000)]
Totally forgot to add these files...
Marc G. Fournier [Tue, 17 Feb 1998 01:32:37 +0000 (01:32 +0000)]
The problem is that $ac_cv_prog_gcc is empty, instead of 'no' or
whatsoever. The patch is not a solution, because configure is generated
from configure.in, and I don't know how to patch it to get a working
'configure'.
From: "Pedro J. Lobo" <pjlobo@euitt.upm.es>
Marc G. Fournier [Mon, 16 Feb 1998 14:39:29 +0000 (14:39 +0000)]
Remove all backend/port/${PORTNAME} references from template files, since
they don't exist anymore
Marc G. Fournier [Sat, 14 Feb 1998 19:56:21 +0000 (19:56 +0000)]
From: Brian E Gallew <geek+@cmu.edu>
dgux 5.4R4.11
Missing port-protos.h (not needed, I think). Wants dld.h. Should
really use the system dl stuff (like i386_solaris). Needs to include
<netinet/in.h> before <arpa/inet.h>. Here are some patches...
Marc G. Fournier [Sat, 14 Feb 1998 18:06:20 +0000 (18:06 +0000)]
Apparently there was a
compiler define that should have been enabled, but was not due to
different naming conventions for Linux/Alpha. Attached is the patch he
sent me, that I have not had a chance to test yet.
From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>
Marc G. Fournier [Sat, 14 Feb 1998 18:04:39 +0000 (18:04 +0000)]
From: plh@opim.uconn.edu
Missing = in an update
Marc G. Fournier [Sat, 14 Feb 1998 18:02:43 +0000 (18:02 +0000)]
Remove HBA related switch
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Marc G. Fournier [Sat, 14 Feb 1998 18:00:37 +0000 (18:00 +0000)]
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
The file 'backend/utils/adt/arrayfuncs.c' won't compile with the
February 14th snapshot, because of an inconsistency between the
declaration and implementation of ReadArrayStr(). As far as I can
tell, the predeclaration is wrong. I assume this is what was meant:
Marc G. Fournier [Sat, 14 Feb 1998 17:58:09 +0000 (17:58 +0000)]
I'm including an update to my user defined IP and MAC address type
implementation that's in contrib/ip_and_mac/. This one works right
with 6.3, avoids the problems I ran into earlier with LIKE, and
includes a bit of extra functionality.
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Marc G. Fournier [Fri, 13 Feb 1998 19:49:06 +0000 (19:49 +0000)]
Man page for ecpg.1
Bruce Momjian [Fri, 13 Feb 1998 19:46:22 +0000 (19:46 +0000)]
Atttypmod cleanup.
Marc G. Fournier [Fri, 13 Feb 1998 17:18:25 +0000 (17:18 +0000)]
From: Jan Wieck <jwieck@debis.com>
just a little correction in the pltcl_guide.nr.
Sometimes I changed the name of tuple arguments to numbers
like the other args are. Otherwise it wasn't possible to
create a function as
CREATE FUNCTION f (EMP, EMP) ... LANGUAGE 'pltcl';
The arguments are now accessed in the function as
$1(name) vs. $2(name)
Marc G. Fournier [Fri, 13 Feb 1998 17:12:08 +0000 (17:12 +0000)]
From: Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>
Only occurrs in
src/include/storage/s_lock.h:#if defined(__AIX)
src/include/utils/dt.h:#if defined(__AIX)
src/include/utils/nabstime.h:#if defined(__AIX)
Simply delete one underscore, only occurs once per file, so no patch.
Marc G. Fournier [Fri, 13 Feb 1998 13:23:33 +0000 (13:23 +0000)]
From: Jan Wieck <jwieck@debis.com>
Someone changed the parser to build a TypeName node on CREATE
FUNCTION in any case. As a side effect, ALL! functions
created got the proretset attribute to true. Thus for a
SELECT the parser wrapped an Iter node around the Expr and
since singleton functions set isDone the Iter returns no
tuple up.
Marc G. Fournier [Fri, 13 Feb 1998 13:15:23 +0000 (13:15 +0000)]
Add missing extern.h file
Marc G. Fournier [Fri, 13 Feb 1998 13:15:12 +0000 (13:15 +0000)]
Makefile.in needs to be configured to use PORTNAME variable
Marc G. Fournier [Fri, 13 Feb 1998 13:14:41 +0000 (13:14 +0000)]
Remove interfaces/ecpg/{include,preproc}/Makefile.in from configure
Vadim B. Mikheev [Fri, 13 Feb 1998 08:10:33 +0000 (08:10 +0000)]
gram.y: ALL_SUBLINK type was returned for x Op (subquery).
parse_expr.c: only Op of bool type are supported currently...
Marc G. Fournier [Fri, 13 Feb 1998 05:10:06 +0000 (05:10 +0000)]
From: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Apart from this Makefile hack, all I've done is to make dynamically
loaded code modules fail properly (as was already done for __mips__,
although I think this is too loose: I believe NetBSD for the pmax can
do dynamic linking), and to add test-and-set lock handling. As Bruce
suggested, this is done in a maximally efficient inlined way: I was
not aware that this code was so important, speed-wise.
Marc G. Fournier [Fri, 13 Feb 1998 04:57:23 +0000 (04:57 +0000)]
Remove -m486 option, since it is platform specific...this should technically
be removed everywhere, but so far linux-elf is the only platform that is
being reported a problem with...
Vadim B. Mikheev [Fri, 13 Feb 1998 03:46:56 +0000 (03:46 +0000)]
Subselects...
Vadim B. Mikheev [Fri, 13 Feb 1998 03:45:29 +0000 (03:45 +0000)]
New SubPlan node for subselects.
New PARAM_EXEC type.
Vadim B. Mikheev [Fri, 13 Feb 1998 03:42:32 +0000 (03:42 +0000)]
EState->->es_param_exec_vals = NULL; in CreateExecutorState().
Vadim B. Mikheev [Fri, 13 Feb 1998 03:41:23 +0000 (03:41 +0000)]
Fix for EXISTS.
Vadim B. Mikheev [Fri, 13 Feb 1998 03:40:23 +0000 (03:40 +0000)]
Support for subselects.
Vadim B. Mikheev [Fri, 13 Feb 1998 03:39:26 +0000 (03:39 +0000)]
Call union_planner() instead of planner().
Vadim B. Mikheev [Fri, 13 Feb 1998 03:37:04 +0000 (03:37 +0000)]
Old planner() becomes union_planner(); new planner() makes initialization
of some global variables to support subselects and calls union_planner().
Calls to SS_replace_correlation_vars() and SS_process_sublinks() in
query_planner() before planning.
Get rid of #ifdef INDEXSCAN_PATCH in createplan.c.
Vadim B. Mikheev [Fri, 13 Feb 1998 03:29:39 +0000 (03:29 +0000)]
Quite limited support for subselects in clausesel.c.
Get rid of #ifdef INDEXSCAN_PATCH in indxpath.c.
Vadim B. Mikheev [Fri, 13 Feb 1998 03:27:47 +0000 (03:27 +0000)]
Support for subselects.
(Have to re-visit readfuncs.c)
Vadim B. Mikheev [Fri, 13 Feb 1998 03:26:53 +0000 (03:26 +0000)]
Support for subselects.
ExecReScan for nodeAgg, nodeHash, nodeHashjoin, nodeNestloop and nodeResult.
Fixed ExecReScan for nodeMaterial.
Get rid of #ifdef INDEXSCAN_PATCH.
Get rid of ExecMarkPos and ExecRestrPos in nodeNestloop.
Vadim B. Mikheev [Fri, 13 Feb 1998 03:21:30 +0000 (03:21 +0000)]
Support for subselects.
Marc G. Fournier [Thu, 12 Feb 1998 14:02:10 +0000 (14:02 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Here's the ecpg patch for the local variables bug I reported earlier:
Marc G. Fournier [Thu, 12 Feb 1998 12:38:12 +0000 (12:38 +0000)]
There, fixed
Marc G. Fournier [Thu, 12 Feb 1998 12:37:49 +0000 (12:37 +0000)]
Screwed this up...fixing now
Marc G. Fournier [Thu, 12 Feb 1998 12:35:56 +0000 (12:35 +0000)]
Clean up Makefiles - shouldn't require configure *.in Makefiles, as they should
pull their data/info from Makefile.global
Marc G. Fournier [Thu, 12 Feb 1998 02:14:59 +0000 (02:14 +0000)]
Remove configure code from ecpg, as well as remove the 'for' loop from the
Makefile, as it isn't appropriate for GNUmake
Bruce Momjian [Thu, 12 Feb 1998 01:50:01 +0000 (01:50 +0000)]
MemSet cleanup.
Bruce Momjian [Wed, 11 Feb 1998 21:45:40 +0000 (21:45 +0000)]
Memset cleanup
Bruce Momjian [Wed, 11 Feb 1998 21:38:08 +0000 (21:38 +0000)]
Change to MemSet for Alpha.
Bruce Momjian [Wed, 11 Feb 1998 21:17:44 +0000 (21:17 +0000)]
Change int align.
Bruce Momjian [Wed, 11 Feb 1998 19:14:04 +0000 (19:14 +0000)]
Goodbye register keyword. Compiler knows better.
Marc G. Fournier [Wed, 11 Feb 1998 15:30:00 +0000 (15:30 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Cleanups for ecpg, as well as a missing patch so that its configured in
Marc G. Fournier [Wed, 11 Feb 1998 15:18:05 +0000 (15:18 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Cleanups for ecpg, as well as a missing patch so that its configured in
Marc G. Fournier [Wed, 11 Feb 1998 14:44:02 +0000 (14:44 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Remove "temp" configure files
Marc G. Fournier [Wed, 11 Feb 1998 14:38:31 +0000 (14:38 +0000)]
From: Jan Wieck <jwieck@debis.com>
A few minutes ago I sent down the PL/Tcl directory to this
list. Look at it and reuse anything that might help to build
PL/perl. I really hope that PL/perl and PL/Tcl appear in the
6.3 distribution. I'll do whatever I can to make this happen.
Marc G. Fournier [Wed, 11 Feb 1998 14:14:18 +0000 (14:14 +0000)]
From: Jan Wieck <jwieck@debis.com>
A few minutes ago I sent down the PL/Tcl directory to this
list. Look at it and reuse anything that might help to build
PL/perl. I really hope that PL/perl and PL/Tcl appear in the
6.3 distribution. I'll do whatever I can to make this happen.
Marc G. Fournier [Wed, 11 Feb 1998 14:08:01 +0000 (14:08 +0000)]
From: Jan Wieck <jwieck@debis.com>
A few minutes ago I sent down the PL/Tcl directory to this
list. Look at it and reuse anything that might help to build
PL/perl. I really hope that PL/perl and PL/Tcl appear in the
6.3 distribution. I'll do whatever I can to make this happen.