]> granicus.if.org Git - postgresql/log
postgresql
25 years agoNothing changed, just testing cvslog ...
Marc G. Fournier [Fri, 30 Jul 1999 03:42:59 +0000 (03:42 +0000)]
Nothing changed, just testing cvslog ...

25 years agoFix description of psql flags -t and -q.
Bruce Momjian [Fri, 30 Jul 1999 00:59:50 +0000 (00:59 +0000)]
Fix description of psql flags -t and -q.

25 years agoFix coredump seen when doing mergejoin between indexed tables,
Tom Lane [Fri, 30 Jul 1999 00:56:17 +0000 (00:56 +0000)]
Fix coredump seen when doing mergejoin between indexed tables,
for example in the regression test database, try
select * from tenk1 t1, tenk1 t2 where t1.unique1 = t2.unique2;
6.5 has this same bug ...

25 years agoUpdate comments for create_indexscan_node().
Tom Lane [Fri, 30 Jul 1999 00:44:23 +0000 (00:44 +0000)]
Update comments for create_indexscan_node().

25 years agoRemove comment after optimization flag.
Bruce Momjian [Thu, 29 Jul 1999 15:39:05 +0000 (15:39 +0000)]
Remove comment after optimization flag.

25 years agoAdd support for Case exprs to fix_indxqual_references,
Tom Lane [Thu, 29 Jul 1999 02:48:05 +0000 (02:48 +0000)]
Add support for Case exprs to fix_indxqual_references,
so that Case works in WHERE join clauses.  Temporary patch --- this routine
is one of many that ought to be changed to use centralized expression-tree-
walking logic.

25 years agoAdd equal() funcs for Case nodes ... amazing we had not
Tom Lane [Thu, 29 Jul 1999 02:45:36 +0000 (02:45 +0000)]
Add equal() funcs for Case nodes ... amazing we had not
detected this omission before.  Miscellaneous other cleanups.

25 years agoUpdate TODO list.
Bruce Momjian [Wed, 28 Jul 1999 17:52:31 +0000 (17:52 +0000)]
Update TODO list.

25 years agoUpdate TODO list.
Bruce Momjian [Wed, 28 Jul 1999 17:51:41 +0000 (17:51 +0000)]
Update TODO list.

25 years agoAllow a_expr not just AexprConst in the right-hand list of
Tom Lane [Wed, 28 Jul 1999 17:39:38 +0000 (17:39 +0000)]
Allow a_expr not just AexprConst in the right-hand list of
IN and NOT IN operators.  Rewrite grotty implementation of IN-list
parsing ... look Ma, no global variable ...

25 years agoUpdate TODO list.
Bruce Momjian [Wed, 28 Jul 1999 00:09:49 +0000 (00:09 +0000)]
Update TODO list.

25 years agoCorrect bug in best_innerjoin(): it should check all the
Tom Lane [Tue, 27 Jul 1999 06:23:12 +0000 (06:23 +0000)]
Correct bug in best_innerjoin(): it should check all the
rels that the inner path needs to join to, but it was only checking for
the first one.  Failure could only have been observed with an OR-clause
that mentions 3 or more tables, and then only if the bogus path was
actually selected as cheapest ...

25 years agoMy recent optimizer changes caused a different plan to
Tom Lane [Tue, 27 Jul 1999 03:53:54 +0000 (03:53 +0000)]
My recent optimizer changes caused a different plan to
be picked for one of the complex joins in rules test ... leading to
a different output ordering ...

25 years agoFirst cut at doing LIKE/regex indexing optimization in
Tom Lane [Tue, 27 Jul 1999 03:51:11 +0000 (03:51 +0000)]
First cut at doing LIKE/regex indexing optimization in
optimizer rather than parser.  This has many advantages, such as not
getting fooled by chance uses of operator names ~ and ~~ (the operators
are identified by OID now), and not creating useless comparison operations
in contexts where the comparisons will not actually be used as indexquals.
The new code also recognizes exact-match LIKE and regex patterns, and
produces an = indexqual instead of >= and <=.

This change does NOT fix the problem with non-ASCII locales: the code
still doesn't know how to generate an upper bound indexqual for non-ASCII
collation order.  But it's no worse than before, just the same deficiency
in a different place...

Also, dike out loc_restrictinfo fields in Plan nodes.  These were doing
nothing useful in the absence of 'expensive functions' optimization,
and they took a considerable amount of processing to fill in.

25 years agoUpdate TODO list.
Bruce Momjian [Mon, 26 Jul 1999 20:12:33 +0000 (20:12 +0000)]
Update TODO list.

25 years agoUpdate TODO list.
Bruce Momjian [Mon, 26 Jul 1999 15:28:32 +0000 (15:28 +0000)]
Update TODO list.

25 years agoFurther work on planning of indexscans. Cleaned up interfaces
Tom Lane [Sun, 25 Jul 1999 23:07:26 +0000 (23:07 +0000)]
Further work on planning of indexscans.  Cleaned up interfaces
to index_selectivity so that it can be handed an indexqual clause list
rather than a bunch of assorted derivative data.

25 years agoRemove 'restrictinfojoinid' field from RestrictInfo nodes.
Tom Lane [Sun, 25 Jul 1999 17:53:27 +0000 (17:53 +0000)]
Remove 'restrictinfojoinid' field from RestrictInfo nodes.
The only place it was being used was as temporary storage in indxpath.c,
and the logic was wrong: the same restrictinfo node could get chosen to
carry the info for two different joins.  Right fix is to return a second
list of unjoined-relids parallel to the list of clause groups.

25 years agoClean up messy clause-selectivity code in clausesel.c; repair bug
Tom Lane [Sat, 24 Jul 1999 23:21:14 +0000 (23:21 +0000)]
Clean up messy clause-selectivity code in clausesel.c; repair bug
identified by Hiroshi (incorrect cost attributed to OR clauses
after multiple passes through set_rest_selec()).  I think the code
was trying to allow selectivities of OR subclauses to be passed in
from outside, but noplace was actually passing any useful data, and
set_rest_selec() was passing wrong data.

Restructure representation of "indexqual" in IndexPath nodes so that
it is the same as for indxqual in completed IndexScan nodes: namely,
a toplevel list with an entry for each pass of the index scan, having
sublists that are implicitly-ANDed index qual conditions for that pass.
You don't want to know what the old representation was :-(

Improve documentation of OR-clause indexscan functions.

Remove useless 'notclause' field from RestrictInfo nodes.  (This might
force an initdb for anyone who has stored rules containing RestrictInfos,
but I do not think that RestrictInfo ever appears in completed plans.)

25 years agoMinor code beautification, extensive improvement of
Tom Lane [Fri, 23 Jul 1999 03:34:49 +0000 (03:34 +0000)]
Minor code beautification, extensive improvement of
comments.  This file was full of obsolete and just plain wrong
commentary...

25 years agoExit cleanups I made yesterday caused pq_close() to be
Tom Lane [Fri, 23 Jul 1999 03:00:10 +0000 (03:00 +0000)]
Exit cleanups I made yesterday caused pq_close() to be
invoked during exit from a standalone backend, leading to core dump.
This is the cause of the recently reported initdb-time crash :-(.
Sorry folks...

25 years agoAlpha spinlock fix from Uncle George <gatgul@voicenet.com>
Bruce Momjian [Thu, 22 Jul 1999 18:30:08 +0000 (18:30 +0000)]
Alpha spinlock fix from Uncle George <gatgul@voicenet.com>

25 years agoComplete merge of all old man page information.
Thomas G. Lockhart [Thu, 22 Jul 1999 15:11:05 +0000 (15:11 +0000)]
Complete merge of all old man page information.
lisp.sgml is a placeholder for Eric Marsden's upcoming contribution.
catalogs.sgml is not yet marked up or integrated.
 It should perhaps become an appendix.

25 years agoComplete merge of all old man page information.
Thomas G. Lockhart [Thu, 22 Jul 1999 15:09:15 +0000 (15:09 +0000)]
Complete merge of all old man page information.
ecpg reference page still needs formatting.

25 years agoPlug several holes in backend's ability to cope with
Tom Lane [Thu, 22 Jul 1999 02:40:07 +0000 (02:40 +0000)]
Plug several holes in backend's ability to cope with
unexpected loss of connection to frontend.

25 years agoUpdate TODO list.
Bruce Momjian [Tue, 20 Jul 1999 23:05:50 +0000 (23:05 +0000)]
Update TODO list.

25 years agoUpdate TODO list.
Bruce Momjian [Tue, 20 Jul 1999 21:43:18 +0000 (21:43 +0000)]
Update TODO list.

25 years agoUpdate TODO list.
Bruce Momjian [Tue, 20 Jul 1999 17:24:36 +0000 (17:24 +0000)]
Update TODO list.

25 years agoWhile I was running some tests in psql, trying to figure out how to change
Bruce Momjian [Tue, 20 Jul 1999 17:20:43 +0000 (17:20 +0000)]
While I was running some tests in psql, trying to figure out how to change
the query string to handle any length, I discovered that under certain
conditions, psql will core dump when handling long strings.  Thus, the
patch.  It was caused by a buffer overrun, probably not noticeable in a lot
of cases, but pretty noticeable in mine.

Problem was caused by the fact that the length check is only performed after
the check for a ; to get the end of the query and execute.

Cheers...

MikeA

25 years agoUpdate TODO list.
Bruce Momjian [Tue, 20 Jul 1999 17:16:25 +0000 (17:16 +0000)]
Update TODO list.

25 years agoReverse out cache changes that are not ready yet.
Bruce Momjian [Tue, 20 Jul 1999 17:14:08 +0000 (17:14 +0000)]
Reverse out cache changes that are not ready yet.

25 years agoUse -ieee alpha flag for gcc and egcs only.
Bruce Momjian [Tue, 20 Jul 1999 16:48:58 +0000 (16:48 +0000)]
Use -ieee alpha flag for gcc and egcs only.

25 years agoautoconf
Bruce Momjian [Tue, 20 Jul 1999 02:45:44 +0000 (02:45 +0000)]
autoconf

25 years agoRe-add Makefile.
Bruce Momjian [Tue, 20 Jul 1999 02:44:09 +0000 (02:44 +0000)]
Re-add Makefile.

25 years agoMove -ieee to adt Makefile, and add CPU Makefile variable.
Bruce Momjian [Tue, 20 Jul 1999 02:42:20 +0000 (02:42 +0000)]
Move -ieee to adt Makefile, and add CPU Makefile variable.

25 years agoComplain about INSERT ... SELECT ... ORDER BY, which we do not
Tom Lane [Tue, 20 Jul 1999 00:18:01 +0000 (00:18 +0000)]
Complain about INSERT ... SELECT ... ORDER BY, which we do not
support, but which the grammar was accepting.  Also, fix several bugs
having to do with failure to copy fields up from a subselect to a select
or insert node.

25 years agopsql fix.
Bruce Momjian [Mon, 19 Jul 1999 21:06:19 +0000 (21:06 +0000)]
psql fix.

25 years agolinux/sparc cleanup
Bruce Momjian [Mon, 19 Jul 1999 18:19:40 +0000 (18:19 +0000)]
linux/sparc cleanup

25 years agoFix for linux/sparc.
Bruce Momjian [Mon, 19 Jul 1999 18:07:36 +0000 (18:07 +0000)]
Fix for linux/sparc.

25 years agoCleanup of patch just applied.
Bruce Momjian [Mon, 19 Jul 1999 16:49:17 +0000 (16:49 +0000)]
Cleanup of  patch just applied.

25 years agoSet the application name, used for parsing readline's .inputrc -- dz
Bruce Momjian [Mon, 19 Jul 1999 16:46:53 +0000 (16:46 +0000)]
Set the application name, used for parsing readline's .inputrc -- dz

Massimo

25 years agoFix #if if.
Bruce Momjian [Mon, 19 Jul 1999 14:30:52 +0000 (14:30 +0000)]
Fix #if if.

25 years ago*** empty log message ***
Michael Meskes [Mon, 19 Jul 1999 12:37:48 +0000 (12:37 +0000)]
*** empty log message ***

25 years agoInstall new alignment code to use MAXALIGN rather than DOUBLEALIGN where
Bruce Momjian [Mon, 19 Jul 1999 07:07:29 +0000 (07:07 +0000)]
Install new alignment code to use MAXALIGN rather than DOUBLEALIGN where
approproate.

25 years agoEnable WIN32 compilation of libpq.
Bruce Momjian [Mon, 19 Jul 1999 06:25:40 +0000 (06:25 +0000)]
Enable WIN32 compilation of libpq.

25 years agoWin32 cleanup
Bruce Momjian [Mon, 19 Jul 1999 02:45:43 +0000 (02:45 +0000)]
Win32 cleanup

25 years agoautoconf
Bruce Momjian [Mon, 19 Jul 1999 02:32:55 +0000 (02:32 +0000)]
autoconf

25 years agoRe-add getopt.h check, remove NT-specific tests for it.
Bruce Momjian [Mon, 19 Jul 1999 02:27:16 +0000 (02:27 +0000)]
Re-add getopt.h check, remove NT-specific tests for it.

25 years agoClean up gcc warning about unused static decl.
Tom Lane [Mon, 19 Jul 1999 02:06:15 +0000 (02:06 +0000)]
Clean up gcc warning about unused static decl.

25 years agoautoconf
Bruce Momjian [Mon, 19 Jul 1999 01:20:00 +0000 (01:20 +0000)]
autoconf

25 years agoRemove getopt configure check.
Bruce Momjian [Mon, 19 Jul 1999 01:18:05 +0000 (01:18 +0000)]
Remove getopt configure check.

25 years agoPut back mistakenly removed configure test for HAVE_NETINET_IN_H.
Tom Lane [Mon, 19 Jul 1999 00:55:59 +0000 (00:55 +0000)]
Put back mistakenly removed configure test for HAVE_NETINET_IN_H.

25 years agoUpdate TODO list.
Bruce Momjian [Mon, 19 Jul 1999 00:50:43 +0000 (00:50 +0000)]
Update TODO list.

25 years agoParser no longer considers
Tom Lane [Mon, 19 Jul 1999 00:29:07 +0000 (00:29 +0000)]
Parser no longer considers
SELECT a/2, a/2 FROM test_missing_target GROUP BY a/2;
to be ambiguous ... which I think is correct behavior.

25 years agoRewrite parser's handling of INSERT ... SELECT so that processing
Tom Lane [Mon, 19 Jul 1999 00:26:20 +0000 (00:26 +0000)]
Rewrite parser's handling of INSERT ... SELECT so that processing
of the SELECT part of the statement is just like a plain SELECT.  All
INSERT-specific processing happens after the SELECT parsing is done.
This eliminates many problems, e.g. INSERT ... SELECT ... GROUP BY using
the wrong column labels.  Ensure that DEFAULT clauses are coerced to
the target column type, whether or not stored clause produces the right
type.  Substantial cleanup of parser's array support.

25 years agoUpdate ecpg compile.
Bruce Momjian [Sun, 18 Jul 1999 21:07:02 +0000 (21:07 +0000)]
Update ecpg compile.

25 years agoautoconf
Bruce Momjian [Sun, 18 Jul 1999 21:05:17 +0000 (21:05 +0000)]
autoconf

25 years agoAdd getopt test.
Bruce Momjian [Sun, 18 Jul 1999 21:02:56 +0000 (21:02 +0000)]
Add getopt test.

25 years agoautoconf
Bruce Momjian [Sun, 18 Jul 1999 20:46:25 +0000 (20:46 +0000)]
autoconf

25 years agocleanup
Bruce Momjian [Sun, 18 Jul 1999 20:43:33 +0000 (20:43 +0000)]
cleanup

25 years agoFix configure problem.
Bruce Momjian [Sun, 18 Jul 1999 20:43:13 +0000 (20:43 +0000)]
Fix configure problem.

25 years agoautoconf
Bruce Momjian [Sun, 18 Jul 1999 20:13:40 +0000 (20:13 +0000)]
autoconf

25 years agoFix typo in _outArrayRef().
Tom Lane [Sun, 18 Jul 1999 19:02:49 +0000 (19:02 +0000)]
Fix typo in _outArrayRef().

25 years agoupdate
Bruce Momjian [Sun, 18 Jul 1999 18:27:05 +0000 (18:27 +0000)]
update

25 years agoUpdate for 6.6.
Bruce Momjian [Sun, 18 Jul 1999 18:06:42 +0000 (18:06 +0000)]
Update for 6.6.

25 years agoconfigure cleanup
Bruce Momjian [Sun, 18 Jul 1999 18:03:50 +0000 (18:03 +0000)]
configure cleanup

25 years agoconfigure cleanup
Bruce Momjian [Sun, 18 Jul 1999 17:38:25 +0000 (17:38 +0000)]
configure cleanup

25 years agoautoconf
Bruce Momjian [Sun, 18 Jul 1999 16:44:31 +0000 (16:44 +0000)]
autoconf

25 years agoUpdate configure include checks.
Bruce Momjian [Sun, 18 Jul 1999 16:42:16 +0000 (16:42 +0000)]
Update configure include checks.

25 years agoautoconf
Bruce Momjian [Sun, 18 Jul 1999 14:54:46 +0000 (14:54 +0000)]
autoconf

25 years agoUpdate includes from configure
Bruce Momjian [Sun, 18 Jul 1999 14:48:30 +0000 (14:48 +0000)]
Update includes from configure

25 years agoautoconf
Bruce Momjian [Sun, 18 Jul 1999 14:38:47 +0000 (14:38 +0000)]
autoconf

25 years agoNo check for string/strings.h.
Bruce Momjian [Sun, 18 Jul 1999 14:34:38 +0000 (14:34 +0000)]
No check for string/strings.h.

25 years agoImprove commentary about ArrayRef and ResTarget nodes.
Tom Lane [Sun, 18 Jul 1999 03:45:01 +0000 (03:45 +0000)]
Improve commentary about ArrayRef and ResTarget nodes.

25 years ago Move some system includes into c.h, and remove duplicates.
Bruce Momjian [Sat, 17 Jul 1999 20:18:55 +0000 (20:18 +0000)]
 Move some system includes into c.h, and remove duplicates.

25 years agoFix incorrect declaration of rtentry as 'ResTarget' where it
Tom Lane [Sat, 17 Jul 1999 19:01:21 +0000 (19:01 +0000)]
Fix incorrect declaration of rtentry as 'ResTarget' where it
should be 'RangeTblEntry' ; explain.c had copied the erroneous code.

25 years agoUpdate TODO list.
Bruce Momjian [Sat, 17 Jul 1999 16:47:46 +0000 (16:47 +0000)]
Update TODO list.

25 years agoFix for multi-byte includes.
Bruce Momjian [Sat, 17 Jul 1999 16:25:28 +0000 (16:25 +0000)]
Fix for multi-byte includes.

25 years agoFix silly typo in commentary...
Tom Lane [Sat, 17 Jul 1999 16:02:50 +0000 (16:02 +0000)]
Fix silly typo in commentary...

25 years agoAdd c.h to exclusion list.
Bruce Momjian [Sat, 17 Jul 1999 15:37:30 +0000 (15:37 +0000)]
Add c.h to exclusion list.

25 years agoclean up comment on missing file.
Bruce Momjian [Sat, 17 Jul 1999 05:16:15 +0000 (05:16 +0000)]
clean up comment on missing file.

25 years agoInclude check
Bruce Momjian [Sat, 17 Jul 1999 04:25:33 +0000 (04:25 +0000)]
Include check

25 years agoMore config.h cleanups.
Bruce Momjian [Sat, 17 Jul 1999 04:12:10 +0000 (04:12 +0000)]
More config.h cleanups.

25 years agoAdd config.h as needed.
Bruce Momjian [Sat, 17 Jul 1999 04:00:31 +0000 (04:00 +0000)]
Add config.h as needed.

25 years agoUpdate TODO list.
Bruce Momjian [Sat, 17 Jul 1999 03:07:10 +0000 (03:07 +0000)]
Update TODO list.

25 years agoTired of seeing that 'unused variable' warning...
Tom Lane [Fri, 16 Jul 1999 23:15:46 +0000 (23:15 +0000)]
Tired of seeing that 'unused variable' warning...

25 years agoAdd back improperly removed #include for utils/trace.h.
Tom Lane [Fri, 16 Jul 1999 23:12:39 +0000 (23:12 +0000)]
Add back improperly removed #include for utils/trace.h.

25 years agoAdd back improperly removed #include for config.h.
Tom Lane [Fri, 16 Jul 1999 23:09:45 +0000 (23:09 +0000)]
Add back improperly removed #include for config.h.
This probably ought to be kept in *all* the port files, but these two
are the only ones that generated compiler warnings for me ...

25 years agoAdd back improperly removed #include for utils/dynamic_loader.h.
Tom Lane [Fri, 16 Jul 1999 23:05:45 +0000 (23:05 +0000)]
Add back improperly removed #include for utils/dynamic_loader.h.

25 years agoFix 'SO__MINOR_VERSION' typo for irix5; add AIX shlib support
Tom Lane [Fri, 16 Jul 1999 22:56:01 +0000 (22:56 +0000)]
Fix 'SO__MINOR_VERSION' typo for irix5; add AIX shlib support
from Andreas Z.; minor cosmetic cleanups.

25 years agoSupport subscripts on bare column names.
Tom Lane [Fri, 16 Jul 1999 22:32:25 +0000 (22:32 +0000)]
Support subscripts on bare column names.

25 years agoAllow bare column names to be subscripted as arrays. This
Tom Lane [Fri, 16 Jul 1999 22:29:42 +0000 (22:29 +0000)]
Allow bare column names to be subscripted as arrays.  This
creates a reduce/reduce conflict, which I resolved by changing the
'AexprConst -> Typename Sconst' rule to 'AexprConst -> SimpleTypename Sconst'.
In other words, a subscripted type declaration can't be used in that
syntax any longer.  This seems a small price to pay for not having to
qualify subscripted columns anymore.
Other cleanups: rename res_target_list to update_target_list, and remove
productions for variants that are not legal in an UPDATE target list;
rename res_target_list2 to plain target_list; delete position_expr
in favor of using b_expr in that production; merge opt_indirection
into attr nonterminal, since there are no places where an unsubscripted
attr is wanted; fix typos in Param support; change case_arg so that
an arbitrary a_expr is allowed, not only a column name.

25 years agoRevise _bt_binsrch() so that its binary search loop takes
Tom Lane [Fri, 16 Jul 1999 22:17:06 +0000 (22:17 +0000)]
Revise _bt_binsrch() so that its binary search loop takes
care of equal-key cases, eliminating bt_firsteq().  The linear search
formerly done by bt_firsteq() took a lot of time in the case where many
equal keys appear on the same page.

25 years agoMore cleanup
Bruce Momjian [Fri, 16 Jul 1999 17:46:32 +0000 (17:46 +0000)]
More cleanup

25 years agoMore cleanup
Bruce Momjian [Fri, 16 Jul 1999 17:07:40 +0000 (17:07 +0000)]
More cleanup

25 years agoFix conflicting id tags (sql.sgml also used "select-title").
Thomas G. Lockhart [Fri, 16 Jul 1999 14:32:06 +0000 (14:32 +0000)]
Fix conflicting id tags (sql.sgml also used "select-title").

25 years agoMore cleanup
Bruce Momjian [Fri, 16 Jul 1999 05:41:19 +0000 (05:41 +0000)]
More cleanup

25 years agoFinal cleanup
Bruce Momjian [Fri, 16 Jul 1999 05:23:30 +0000 (05:23 +0000)]
Final cleanup

25 years agoUpdate TODO list.
Bruce Momjian [Fri, 16 Jul 1999 05:06:34 +0000 (05:06 +0000)]
Update TODO list.

25 years agoFinal cleanup.
Bruce Momjian [Fri, 16 Jul 1999 05:00:38 +0000 (05:00 +0000)]
Final cleanup.