OSDN Git Service
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.
Thomas G. Lockhart [Wed, 11 Feb 1998 04:24:20 +0000 (04:24 +0000)]
Remove some definitions which could not work; conversions from datetime
to integer unix system time conflict on the input types.
Leave in the conversions from integer unix system time to datetime.
Thomas G. Lockhart [Wed, 11 Feb 1998 04:13:33 +0000 (04:13 +0000)]
Update test for newly implemented "<=" operator.
Thomas G. Lockhart [Wed, 11 Feb 1998 04:11:19 +0000 (04:11 +0000)]
Try bumping to version two...
Thomas G. Lockhart [Wed, 11 Feb 1998 04:09:54 +0000 (04:09 +0000)]
Define ROW and STATEMENT as parser tokens.
Use explicit tokens to decode CREATE TRIGGER clauses.
Allow ROW and STATEMENT as column identifiers.
Fix CAST syntax to require parens per SQL92 spec.
Define TypeId to allow correct translation of type names in CREATE FUNCTION
and other statements. Need to do this without looking up defined type
names because CREATE FUNCTION can specify undefined (new) types.
Define UserId to complete removal of "Id" generic entity.
Define xlateSqlFunc() to convert SQL92 CHARACTER_LENGTH() and CHAR_LENGTH()
functions to calls to length().
Define func_name parser entity for contexts requiring a function name.
Have xlateSqlType() translate "float" to "float8".
Thomas G. Lockhart [Wed, 11 Feb 1998 03:56:08 +0000 (03:56 +0000)]
Automatically promote out of range integers to floats.
Throw elog(NOTICE) to flag promotion.
Thomas G. Lockhart [Wed, 11 Feb 1998 03:51:38 +0000 (03:51 +0000)]
Fix typos in SQL statement terminators.
Marc G. Fournier [Tue, 10 Feb 1998 17:42:54 +0000 (17:42 +0000)]
regression test based off of Solaris/Sparc v2.6
Marc G. Fournier [Tue, 10 Feb 1998 16:44:17 +0000 (16:44 +0000)]
Erk, the whole directory structure changed on us here...
Marc G. Fournier [Tue, 10 Feb 1998 16:37:01 +0000 (16:37 +0000)]
Updated ECPG From: Michael Meskes <meskes@topsystem.de>