OSDN Git Service
Bruce Momjian [Wed, 24 Feb 1999 17:29:06 +0000 (17:29 +0000)]
Fix problem with selectivity error in added columns with ALTER TABLE.
Move files to deadcode.
Bruce Momjian [Wed, 24 Feb 1999 10:20:07 +0000 (10:20 +0000)]
update comments
Bruce Momjian [Wed, 24 Feb 1999 03:17:05 +0000 (03:17 +0000)]
Thank you for the advice. I concluded that current inet code has a
portability problem. Included patches should be applied to both
current and 6.4 tree. I have tested on LinuxPPC, FreeBSD and Solaris
2.6. Now the inet regression tests on these platforms are all happy.
---
Tatsuo Ishii
Marc G. Fournier [Tue, 23 Feb 1999 12:57:03 +0000 (12:57 +0000)]
From: Michael Meskes <Michael_Meskes@topmail.de>
+
+ Son Feb 21 14:10:47 CET 1999
+
+ - Fixed variable detection in libecpg.
+
+ Mon Feb 22 19:47:45 CET 1999
+
+ - Added 'at <db_connection>' option to all commands it is apllicable
+ to. Due to changing the API of some libecpg functions this
+ requires me to increase the major version number.
+ - Synced pgc.l with scan.l.
+ - Added support for unions.
+ - Set library version to 3.0.0
+ - Set ecpg version to 3.0.0
Thomas G. Lockhart [Tue, 23 Feb 1999 08:05:27 +0000 (08:05 +0000)]
Add parameters to function calls to pass back table qualifications.
Thomas G. Lockhart [Tue, 23 Feb 1999 08:01:47 +0000 (08:01 +0000)]
Add a few other parser-only nodes for debugging help.
Define the JoinExpr node.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:55:24 +0000 (07:55 +0000)]
Define JoinExpr structure for outer join syntax.
Clean up comments in execnodes.h.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:54:03 +0000 (07:54 +0000)]
Clean up error messages.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:51:53 +0000 (07:51 +0000)]
Do a better job of selecting candidates among functions
when no exact match.
Clean up elog error messages.
Thomas G. Lockhart [Tue, 23 Feb 1999 07:46:42 +0000 (07:46 +0000)]
Include some new code for outer joins. Disabled by default, but enable by
including the following in your Makefile.custom:
CFLAGS+= -DENABLE_OUTER_JOINS -DEXEC_MERGEJOINDEBUG
Thomas G. Lockhart [Tue, 23 Feb 1999 07:44:44 +0000 (07:44 +0000)]
Put in explicit checks for implicit index name lengths.
Put in hooks for outer joins by passing a few parameters back and forth
in function calls. May not be close to working yet.
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