OSDN Git Service
Thomas G. Lockhart [Tue, 23 Feb 1999 07:42:41 +0000 (07:42 +0000)]
Modify the outer join placeholder code with something closer to working
code. Works here, but not completely implemented past this point.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:39:40 +0000 (07:39 +0000)]
Bring debugging print statement declarations up to date.
Comment-out the #undef default declarations to allow the parameters to be
set on the compiler command line.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:37:31 +0000 (07:37 +0000)]
Add constants for outer join states in executor.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:36:31 +0000 (07:36 +0000)]
Fix typos in comments.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:35:09 +0000 (07:35 +0000)]
Add first code to help with outer joins.
Enable by defining
CFLAGS+= -DENABLE_OUTER_JOINS -DEXEC_MERGEJOINDEBUG
in your Makefile.custom
Thomas G. Lockhart [Tue, 23 Feb 1999 07:33:09 +0000 (07:33 +0000)]
Fix typo in comment.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:31:02 +0000 (07:31 +0000)]
Update error messages with more consistant format.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:30:05 +0000 (07:30 +0000)]
Add many new test cases.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:29:19 +0000 (07:29 +0000)]
Remove non-portable queries by replacing getpgusername() with a constant
string.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:27:13 +0000 (07:27 +0000)]
First tests using JOIN syntax.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:24:08 +0000 (07:24 +0000)]
Rearrange order of subdirectory creation to help generate parse.h
file early enough to use in nodes/.
Try to be more complete for rules on generating parse.h,
but it still does not work any better than before. Should be able to
make correctly if parser/gram.y is updated even without a "make clean"
but so far not there yet.
Bruce Momjian [Mon, 22 Feb 1999 19:55:44 +0000 (19:55 +0000)]
comments cleanup.
Bruce Momjian [Mon, 22 Feb 1999 19:40:10 +0000 (19:40 +0000)]
comment cleanup.
Bruce Momjian [Mon, 22 Feb 1999 17:29:57 +0000 (17:29 +0000)]
ifdef out append().
Bruce Momjian [Mon, 22 Feb 1999 16:46:43 +0000 (16:46 +0000)]
Ok. I found an align problem in lobj that might not appear other than
Solaris/sparc. Please apply included patches to
src/backend/storage/large_object/inv_api.c and try again. (These are
Tatsuo Ishii
Tom Lane [Mon, 22 Feb 1999 06:16:57 +0000 (06:16 +0000)]
Repair some pretty serious problems in dynahash.c and
shared memory space allocation. It's a wonder we have not seen bug
reports traceable to this area ... it's quite clear that the routine
dir_realloc() has never worked correctly, for example.
Bruce Momjian [Mon, 22 Feb 1999 06:08:48 +0000 (06:08 +0000)]
more cleanup
Bruce Momjian [Mon, 22 Feb 1999 05:26:58 +0000 (05:26 +0000)]
Final optimizer cleanups.
Bruce Momjian [Mon, 22 Feb 1999 02:08:32 +0000 (02:08 +0000)]
rename pgsql to postgres in regression.
Bruce Momjian [Mon, 22 Feb 1999 02:06:38 +0000 (02:06 +0000)]
change pgsql to postgres
Bruce Momjian [Mon, 22 Feb 1999 01:57:50 +0000 (01:57 +0000)]
fix compile problem.
Marc G. Fournier [Sun, 21 Feb 1999 03:49:55 +0000 (03:49 +0000)]
From: Tatsuo Ishii <t-ishii@sra.co.jp>
Ok. I made patches replacing all of "#if FALSE" or "#if 0" to "#ifdef
NOT_USED" for current. I have tested these patches in that the
postgres binaries are identical.
Tom Lane [Sun, 21 Feb 1999 03:17:31 +0000 (03:17 +0000)]
Document postmaster's -N switch.
Tom Lane [Sun, 21 Feb 1999 03:16:29 +0000 (03:16 +0000)]
Document configure's --with-maxbackends switch.
Fix a few small typos.
Marc G. Fournier [Sun, 21 Feb 1999 03:02:35 +0000 (03:02 +0000)]
From: Michael Meskes <Michael_Meskes@topmail.de>
+
+ Fri Feb 19 21:40:14 CET 1999
+
+ - Fixed bug in libecpg that caused it to start transactions only for
+ the first connection.
+ - Set library version to 2.7.1
Bruce Momjian [Sun, 21 Feb 1999 01:55:03 +0000 (01:55 +0000)]
pathkeys.c cleanup.
Tom Lane [Sun, 21 Feb 1999 01:41:55 +0000 (01:41 +0000)]
Rearrange handling of MAXBACKENDS a little bit. The default setting
of MAXBACKENDS is now 1024, since all it's costing is about 32 bytes of memory
per array slot. configure's --with-maxbackends switch now controls DEF_MAXBACKENDS
which is simply the default value of the postmaster's -N switch. Thus,
the out-of-the-box configuration will still limit you to 64 backends,
but you can go up to 1024 backends simply by restarting the postmaster with
a different -N switch --- no rebuild required.
Bruce Momjian [Sat, 20 Feb 1999 19:02:43 +0000 (19:02 +0000)]
pathkeys fixes
Bruce Momjian [Sat, 20 Feb 1999 18:01:02 +0000 (18:01 +0000)]
Update pathkeys comparison function.
Bruce Momjian [Sat, 20 Feb 1999 16:32:35 +0000 (16:32 +0000)]
update pathkey description.
Bruce Momjian [Sat, 20 Feb 1999 16:28:20 +0000 (16:28 +0000)]
add pathkeys description.
Bruce Momjian [Sat, 20 Feb 1999 15:27:42 +0000 (15:27 +0000)]
another rename of optimizer
Marc G. Fournier [Sat, 20 Feb 1999 07:01:08 +0000 (07:01 +0000)]
From: Michael Meskes <Michael_Meskes@topmail.de>
See Changes file...
Tom Lane [Fri, 19 Feb 1999 23:27:17 +0000 (23:27 +0000)]
OOPS ... Perl5 interface to PQsetdbLogin was actually
calling PQsetdb ...
Tom Lane [Fri, 19 Feb 1999 07:10:48 +0000 (07:10 +0000)]
Reorder startup ops so that if preallocation of semas fails,
postmaster will release whatever it did get before dying.
Tom Lane [Fri, 19 Feb 1999 06:06:39 +0000 (06:06 +0000)]
Allow maximum number of backends to be set at configure time
(--with-maxbackends). Add a postmaster switch (-N backends) that allows
the limit to be reduced at postmaster start time. (You can't increase it,
sorry to say, because there are still some fixed-size arrays.)
Grab the number of semaphores indicated by min(MAXBACKENDS, -N) at
postmaster startup, so that this particular form of bogus configuration
is exposed immediately rather than under heavy load.
Bruce Momjian [Fri, 19 Feb 1999 05:18:06 +0000 (05:18 +0000)]
optimizer cleanup
Bruce Momjian [Fri, 19 Feb 1999 02:05:20 +0000 (02:05 +0000)]
optimizer cleanup
Thomas G. Lockhart [Fri, 19 Feb 1999 01:58:52 +0000 (01:58 +0000)]
Fix parens typo reported by wmt@thi.com (Bill Tonkin).
Thomas G. Lockhart [Fri, 19 Feb 1999 01:57:08 +0000 (01:57 +0000)]
Fix SGML markup from last content changes.
Bruce Momjian [Thu, 18 Feb 1999 19:58:53 +0000 (19:58 +0000)]
rename optimizer file name
Bruce Momjian [Thu, 18 Feb 1999 06:01:11 +0000 (06:01 +0000)]
Enable bushy and right-hand queries by default.
Bruce Momjian [Thu, 18 Feb 1999 05:26:34 +0000 (05:26 +0000)]
Enable bushy plans by default.
Bruce Momjian [Thu, 18 Feb 1999 04:55:54 +0000 (04:55 +0000)]
optimizer cleanup
Bruce Momjian [Thu, 18 Feb 1999 04:45:36 +0000 (04:45 +0000)]
more optimizer cleanups
Tom Lane [Thu, 18 Feb 1999 01:13:26 +0000 (01:13 +0000)]
Produce a more specific error message when backend sees EOF on
client connection.
Bruce Momjian [Thu, 18 Feb 1999 00:49:48 +0000 (00:49 +0000)]
Fix bushy plans. Cleanup.
Bruce Momjian [Tue, 16 Feb 1999 00:41:03 +0000 (00:41 +0000)]
Re-enable bushy plans. Vadim want them.
Bruce Momjian [Mon, 15 Feb 1999 22:19:01 +0000 (22:19 +0000)]
Update optimizer readme.
Tom Lane [Mon, 15 Feb 1999 16:29:32 +0000 (16:29 +0000)]
regprocin should accept '-' signifying InvalidOid, for
symmetry with regprocout.
Bruce Momjian [Mon, 15 Feb 1999 05:56:07 +0000 (05:56 +0000)]
rename
Bruce Momjian [Mon, 15 Feb 1999 05:50:02 +0000 (05:50 +0000)]
optimizer rename
Bruce Momjian [Mon, 15 Feb 1999 05:28:10 +0000 (05:28 +0000)]
optimizer rename
Bruce Momjian [Mon, 15 Feb 1999 05:21:12 +0000 (05:21 +0000)]
otherrels is now unjoined_rels
Bruce Momjian [Mon, 15 Feb 1999 03:59:28 +0000 (03:59 +0000)]
optimizer rename
Bruce Momjian [Mon, 15 Feb 1999 03:22:37 +0000 (03:22 +0000)]
Remove duplicate geqo functions, and more optimizer cleanup
Tom Lane [Mon, 15 Feb 1999 02:04:58 +0000 (02:04 +0000)]
Replace non-idiomatic nconc(x, lcons(y, NIL)) with lappend(x, y).
Tom Lane [Mon, 15 Feb 1999 01:06:59 +0000 (01:06 +0000)]
Fix a number of places that made faulty assumptions about
what is_opclause will accept.
Tom Lane [Sun, 14 Feb 1999 22:24:25 +0000 (22:24 +0000)]
Fix optimizer coredump with unary-operator WHERE clauses.
A test case is:
create table linetab (x line);
select * from linetab where ?| x;
which coredumps in 6.4.2 and current sources.
Bruce Momjian [Sun, 14 Feb 1999 05:27:12 +0000 (05:27 +0000)]
optimizer cleanup.
Bruce Momjian [Sun, 14 Feb 1999 05:14:15 +0000 (05:14 +0000)]
optimizer rename.
Bruce Momjian [Sun, 14 Feb 1999 04:57:02 +0000 (04:57 +0000)]
Optimizer rename.
Bruce Momjian [Sat, 13 Feb 1999 23:22:53 +0000 (23:22 +0000)]
Change my-function-name-- to my_function_name, and optimizer renames.
Thomas G. Lockhart [Sat, 13 Feb 1999 05:34:24 +0000 (05:34 +0000)]
Fix offset of one for date_part(timespan) when given arguments of
decade, century, or millenium.
Thomas G. Lockhart [Sat, 13 Feb 1999 05:25:54 +0000 (05:25 +0000)]
Remove equivalence between datetime and float8. Led to nothin' but trouble.
Thomas G. Lockhart [Sat, 13 Feb 1999 04:25:01 +0000 (04:25 +0000)]
Change #if FALSE to #if NOT_USED to avoid port problems.
Fix problem with date_part() for timespan (had an offset of one)
when given decade, century, and millenium as arguments.
Reported by Ricardo J.C.Coelho.
Thomas G. Lockhart [Sat, 13 Feb 1999 04:22:34 +0000 (04:22 +0000)]
Add routines to convert between int8 and text/varchar types.
Change #if FALSE to #if NOT_USED to avoid port problems.
Fix up pg_indent weirdness with function argument declarations.
Thomas G. Lockhart [Sat, 13 Feb 1999 04:19:54 +0000 (04:19 +0000)]
Add routines to convert between int8 and text/varchar types.
Fix output type for int8out, but I don't think it matters.
Thomas G. Lockhart [Sat, 13 Feb 1999 04:15:33 +0000 (04:15 +0000)]
Include some Julian date declarations to share between various date/time
modules. Used to be in dt.c I think.
Thomas G. Lockhart [Sat, 13 Feb 1999 03:54:51 +0000 (03:54 +0000)]
Re-enable arch-dev.sgml now that it has new information from Stefan's
Master's Thesis.
Thomas G. Lockhart [Sat, 13 Feb 1999 03:54:00 +0000 (03:54 +0000)]
Require complete tagging in emacs hints at bottom of file.
Thomas G. Lockhart [Sat, 13 Feb 1999 03:52:46 +0000 (03:52 +0000)]
Include chapter on SQL language elements (keywords, etc).
Should merge with or complement Stefan's Master's Thesis intro to SQL.
Thomas G. Lockhart [Sat, 13 Feb 1999 03:42:10 +0000 (03:42 +0000)]
Describe the date/time parsing rules.
Include specific information on the supported time zones.
It's a really big table, so maybe it should go into an appendix instead.
Thomas G. Lockhart [Sat, 13 Feb 1999 03:38:46 +0000 (03:38 +0000)]
Add Stefan Simkovics' Master's Thesis.
Thomas G. Lockhart [Sat, 13 Feb 1999 03:37:54 +0000 (03:37 +0000)]
Substitute great info from Stefan Simkovics' Master's Thesis.
Still need to add some acknowledgements at the top of the doc;
already have full info in the bibliography but since the original is
being spread across the existing docs we should also mention things
locally.
Thomas G. Lockhart [Sat, 13 Feb 1999 03:33:50 +0000 (03:33 +0000)]
Minor markup changes for the recent TEMP TABLE info.
Docs should build now...
Thomas G. Lockhart [Sat, 13 Feb 1999 03:32:43 +0000 (03:32 +0000)]
More complete info from Oliver Elphick.
Bruce Momjian [Fri, 12 Feb 1999 17:25:05 +0000 (17:25 +0000)]
Optimizer cleanup.
Bruce Momjian [Fri, 12 Feb 1999 06:43:53 +0000 (06:43 +0000)]
JoinPath -> NestPath for nested loop.
Bruce Momjian [Fri, 12 Feb 1999 05:57:08 +0000 (05:57 +0000)]
Fix optimizer and make faster.
Bruce Momjian [Fri, 12 Feb 1999 02:37:52 +0000 (02:37 +0000)]
optimizer update
Tom Lane [Thu, 11 Feb 1999 23:25:16 +0000 (23:25 +0000)]
Remove Perl module's unnecessary dependence on libpq-int.h.
Bruce Momjian [Thu, 11 Feb 1999 21:05:28 +0000 (21:05 +0000)]
Optimizer cleanups.
Bruce Momjian [Thu, 11 Feb 1999 17:21:51 +0000 (17:21 +0000)]
Optimizer cleanup.
Bruce Momjian [Thu, 11 Feb 1999 17:03:17 +0000 (17:03 +0000)]
optimizer cleanup
Bruce Momjian [Thu, 11 Feb 1999 17:00:49 +0000 (17:00 +0000)]
Optimizer cleanup.
Bruce Momjian [Thu, 11 Feb 1999 16:09:41 +0000 (16:09 +0000)]
More optimization.
Bruce Momjian [Thu, 11 Feb 1999 14:59:09 +0000 (14:59 +0000)]
More optimizer speedups.
Bruce Momjian [Thu, 11 Feb 1999 05:29:08 +0000 (05:29 +0000)]
optimizer cleanup
Bruce Momjian [Thu, 11 Feb 1999 04:08:44 +0000 (04:08 +0000)]
Optimizer fix for samekeys() and cost fixes for longer optimizer keys.
Tom Lane [Thu, 11 Feb 1999 01:36:55 +0000 (01:36 +0000)]
Include <varargs.h> on SunOS. (Does any other platform need it??)
Bruce Momjian [Wed, 10 Feb 1999 21:02:50 +0000 (21:02 +0000)]
Optmizer cleanup
Bruce Momjian [Wed, 10 Feb 1999 17:14:32 +0000 (17:14 +0000)]
Update find_typedefs for bsdi 4.0.
Bruce Momjian [Wed, 10 Feb 1999 03:52:54 +0000 (03:52 +0000)]
Rename Path.keys to Path.pathkeys. Too many 'keys' used for other things.
Bruce Momjian [Tue, 9 Feb 1999 17:03:14 +0000 (17:03 +0000)]
Rename Temp to Noname for noname tables.
Bruce Momjian [Tue, 9 Feb 1999 06:30:45 +0000 (06:30 +0000)]
Optimizer fix for samekeys.
Bruce Momjian [Tue, 9 Feb 1999 03:51:42 +0000 (03:51 +0000)]
Major optimizer improvement for joining a large number of tables.
Jan Wieck [Mon, 8 Feb 1999 14:14:32 +0000 (14:14 +0000)]
Added LIMIT/OFFSET functionality including new regression test for it.
Removed CURRENT keyword for rule queries and changed rules regression
accordingly. CURRENT has beed announced to disappear in v6.5.
Jan
Bruce Momjian [Mon, 8 Feb 1999 04:29:25 +0000 (04:29 +0000)]
Optimizer cleanup.
Tom Lane [Mon, 8 Feb 1999 01:46:28 +0000 (01:46 +0000)]
pg_dump -d or -D didn't quote special characters in INSERT data
correctly. -D had problems with tables with inherited fields, also.