OSDN Git Service
Tom Lane [Sun, 11 Jul 1999 02:04:19 +0000 (02:04 +0000)]
Ignore resjunk targetlist entries when matching arguments to
a SubLink with the subplan's targetlist. This fixes a problem seen with,
for example, a subselect that uses GROUP BY.
Bruce Momjian [Sun, 11 Jul 1999 02:02:13 +0000 (02:02 +0000)]
Update TODO list.
Tom Lane [Sun, 11 Jul 1999 01:57:32 +0000 (01:57 +0000)]
ExecReScanGroup() forgot to clear grpstate->grp_firstTuple,
thereby guaranteeing wrong results from a rescanned Group node.
Tom Lane [Sat, 10 Jul 1999 22:06:26 +0000 (22:06 +0000)]
heapam.h uses type time_t, but didn't include <time.h>.
Bruce Momjian [Sat, 10 Jul 1999 18:38:16 +0000 (18:38 +0000)]
Add new item from Tom Lane sorting.
Tom Lane [Sat, 10 Jul 1999 18:21:59 +0000 (18:21 +0000)]
Fix tuplecmp() to ensure repeatable sort ordering of tuples
that contain null fields. Old code would produce erratic sort results
because comparisons of tuples containing nulls could produce inconsistent
answers.
Bruce Momjian [Sat, 10 Jul 1999 17:26:09 +0000 (17:26 +0000)]
Update release notes.
Bruce Momjian [Sat, 10 Jul 1999 17:16:05 +0000 (17:16 +0000)]
Update release for 6.5.1.
Bruce Momjian [Sat, 10 Jul 1999 17:03:34 +0000 (17:03 +0000)]
cleanup of long long int atoi test.
Bruce Momjian [Sat, 10 Jul 1999 16:28:02 +0000 (16:28 +0000)]
Update stuff for 6.5.1 release.
Tatsuo Ishii [Sat, 10 Jul 1999 12:33:10 +0000 (12:33 +0000)]
-mieee and # does not work for certain version of egcs
Tom Lane [Fri, 9 Jul 1999 22:53:40 +0000 (22:53 +0000)]
Fix gcc complaint about long being passed to sprintf %d.
Bruce Momjian [Fri, 9 Jul 1999 21:59:59 +0000 (21:59 +0000)]
Make ^ precidence greater than *.
Bruce Momjian [Fri, 9 Jul 1999 21:46:14 +0000 (21:46 +0000)]
update readme.nt
Bruce Momjian [Fri, 9 Jul 1999 17:57:46 +0000 (17:57 +0000)]
createlang now returns 2 for language already exists.
Bruce Momjian [Fri, 9 Jul 1999 17:40:31 +0000 (17:40 +0000)]
Re-apply range check patch after fixing LIMIT_H test and defines.
Bruce Momjian [Fri, 9 Jul 1999 16:56:44 +0000 (16:56 +0000)]
Add mention block size <= 32k.
Tom Lane [Fri, 9 Jul 1999 15:09:54 +0000 (15:09 +0000)]
Another place that HAVE_LIMITS_H was misspelled.
Bruce Momjian [Fri, 9 Jul 1999 04:51:27 +0000 (04:51 +0000)]
cleanup
Bruce Momjian [Fri, 9 Jul 1999 04:20:22 +0000 (04:20 +0000)]
Update TODO list.
Bruce Momjian [Fri, 9 Jul 1999 03:28:53 +0000 (03:28 +0000)]
Fix for ACL length problem on different platforms.
Bruce Momjian [Fri, 9 Jul 1999 03:27:20 +0000 (03:27 +0000)]
Backup pg_atoi patch for long checking. Caused initdb problems.
Bruce Momjian [Fri, 9 Jul 1999 02:35:37 +0000 (02:35 +0000)]
Add linux_m68k template file.
Bruce Momjian [Thu, 8 Jul 1999 15:28:51 +0000 (15:28 +0000)]
Rename tuturials for char2/char16 removal.
Bruce Momjian [Thu, 8 Jul 1999 15:27:01 +0000 (15:27 +0000)]
Rename example temp to mytemp.
Bruce Momjian [Thu, 8 Jul 1999 05:04:49 +0000 (05:04 +0000)]
Update TODO
Bruce Momjian [Thu, 8 Jul 1999 05:02:09 +0000 (05:02 +0000)]
Update.
Bruce Momjian [Thu, 8 Jul 1999 05:01:25 +0000 (05:01 +0000)]
Update todo
Bruce Momjian [Thu, 8 Jul 1999 03:34:00 +0000 (03:34 +0000)]
Update TODO.
Bruce Momjian [Thu, 8 Jul 1999 03:33:19 +0000 (03:33 +0000)]
New TODO list.
Bruce Momjian [Thu, 8 Jul 1999 03:32:57 +0000 (03:32 +0000)]
Test Case:
----------
exec sql begin declare section;
short s ;
unsigned short us;
exec sql end declare section;
exec sql create table test(s smallint, us smallint);
exec sql commit;
s = 1; us =32000;
exec sql insert into test values( :s, :us ) ; <== error
Error Message: "i4toi2: '-
600309759' causes int2 underflow"
Masaaki Sakaida
Bruce Momjian [Thu, 8 Jul 1999 03:30:16 +0000 (03:30 +0000)]
Add CXXFLAGS +=
Bruce Momjian [Thu, 8 Jul 1999 03:22:46 +0000 (03:22 +0000)]
> In both datetime_trunc() and timespan_trunc() in dt.c,
> the DTK_MICROSEC case is just like the DTK_MILLISEC case.
> I think this is wrong and it ought to look like
> fsec = rint(fsec *
1000000) /
1000000;
> no?
Tom Lane.
Bruce Momjian [Thu, 8 Jul 1999 02:46:39 +0000 (02:46 +0000)]
Rename pg_temp to pg_sorttemp so it does not conflict with temp table names.
Bruce Momjian [Thu, 8 Jul 1999 00:27:01 +0000 (00:27 +0000)]
pg_atoi() does range check on int4 data only if
"HAS_LONG_LONG" is defined based on the assumption that
strtol() would return ERANGE if a platform does not support
64-bit integers. In current PostgreSQL 6.5 (and 6.4.2)
distribution, "HAS_LONG_LONG" is defined only if platform
is "alpha". (See include/port/alpha.h) I think the int4
range check should apply to linux_alpha as well. (I have
not tested yet but I guess this might be applicable to
newer Linux/i386 distributions which includes new GCC which
implements long int as 64-bit int.)
Bruce Momjian [Thu, 8 Jul 1999 00:15:03 +0000 (00:15 +0000)]
Irix update from Mark Dalphin
Bruce Momjian [Thu, 8 Jul 1999 00:00:43 +0000 (00:00 +0000)]
Add ^ precidence.
Bruce Momjian [Wed, 7 Jul 1999 17:17:50 +0000 (17:17 +0000)]
Allow port numbers 32k - 64k.
Bruce Momjian [Wed, 7 Jul 1999 16:41:18 +0000 (16:41 +0000)]
Newer README.NT.
Bruce Momjian [Wed, 7 Jul 1999 16:09:33 +0000 (16:09 +0000)]
Fix for \do and ceil()/float.
Bruce Momjian [Wed, 7 Jul 1999 09:36:45 +0000 (09:36 +0000)]
Fix spelling of variable name.
Bruce Momjian [Wed, 7 Jul 1999 09:27:28 +0000 (09:27 +0000)]
Cleanup of min tuple size.
Bruce Momjian [Wed, 7 Jul 1999 09:11:15 +0000 (09:11 +0000)]
Fix misspelling.
Bruce Momjian [Tue, 6 Jul 1999 20:41:22 +0000 (20:41 +0000)]
Add new TODO file to CVS tree.
Thomas G. Lockhart [Tue, 6 Jul 1999 17:19:42 +0000 (17:19 +0000)]
Update makefile to generate man pages.
Include first cut at instructions for man pages in docguide.sgml.
Fix markup.
Thomas G. Lockhart [Tue, 6 Jul 1999 17:18:31 +0000 (17:18 +0000)]
Add missing paragraph end tag.
Thomas G. Lockhart [Tue, 6 Jul 1999 17:17:31 +0000 (17:17 +0000)]
Fix some markup, but probably not finished yet...
Thomas G. Lockhart [Tue, 6 Jul 1999 17:16:42 +0000 (17:16 +0000)]
Fix markup for docbook2man man page generation.
No big deal; fixed lots of other markup at the same time.
Bigest change: make sure there is no whitespace
in front of <term> contents.
This will probably help the other output types too.
Thomas G. Lockhart [Tue, 6 Jul 1999 17:13:50 +0000 (17:13 +0000)]
Include rules for building a man tar file.
Bruce Momjian [Mon, 5 Jul 1999 21:48:21 +0000 (21:48 +0000)]
Remove old readme file.
Bruce Momjian [Sun, 4 Jul 1999 05:47:06 +0000 (05:47 +0000)]
Align cleanup.
Bruce Momjian [Sun, 4 Jul 1999 05:44:56 +0000 (05:44 +0000)]
More alignment
Bruce Momjian [Sun, 4 Jul 1999 05:16:05 +0000 (05:16 +0000)]
Clean up maximum rewrite tuple length.
Bruce Momjian [Sun, 4 Jul 1999 04:56:02 +0000 (04:56 +0000)]
Clarify maximum tuple and max attribute lengths.
Tom Lane [Sun, 4 Jul 1999 01:03:01 +0000 (01:03 +0000)]
Make exec_simple_check_plan() check for a null plan, so
that it doesn't crash when processing a utility statement.
Bruce Momjian [Sat, 3 Jul 1999 15:43:57 +0000 (15:43 +0000)]
Add abortcurrent trans to temp table fix.
Bruce Momjian [Sat, 3 Jul 1999 01:57:53 +0000 (01:57 +0000)]
More cleanup
Bruce Momjian [Sat, 3 Jul 1999 01:56:16 +0000 (01:56 +0000)]
Update tuple size check.
Bruce Momjian [Sat, 3 Jul 1999 01:47:02 +0000 (01:47 +0000)]
Fix for insertion of tuple too large.
Bruce Momjian [Sat, 3 Jul 1999 00:33:04 +0000 (00:33 +0000)]
Fix to prevent too large tuple from being created.
Bruce Momjian [Fri, 2 Jul 1999 18:09:28 +0000 (18:09 +0000)]
Fix for removal of temp tables if last transaction was aborted.
Bruce Momjian [Fri, 2 Jul 1999 03:21:37 +0000 (03:21 +0000)]
typo fix.
Bruce Momjian [Thu, 1 Jul 1999 19:47:25 +0000 (19:47 +0000)]
#ifdef around true and false.
Bruce Momjian [Thu, 1 Jul 1999 05:31:22 +0000 (05:31 +0000)]
Add files to point to TODO list.
Tom Lane [Thu, 1 Jul 1999 00:06:28 +0000 (00:06 +0000)]
make distclean missed a few symlinks created by configure.
Tom Lane [Wed, 30 Jun 1999 23:57:31 +0000 (23:57 +0000)]
Make sure symlinks for sharedlib get removed by 'make clean'.
Tom Lane [Wed, 30 Jun 1999 23:54:18 +0000 (23:54 +0000)]
Generate a full set of version-numbered symlinks when building
a shared library, not just when installing it.
Michael Meskes [Tue, 29 Jun 1999 09:25:25 +0000 (09:25 +0000)]
*** empty log message ***
Vadim B. Mikheev [Tue, 29 Jun 1999 04:54:49 +0000 (04:54 +0000)]
Avoid disk writes for read-only transactions.
Bruce Momjian [Mon, 28 Jun 1999 18:40:34 +0000 (18:40 +0000)]
Add time warning about bigtests.
Peter Mount [Sun, 27 Jun 1999 11:05:38 +0000 (11:05 +0000)]
Some minor bug fixes
Bruce Momjian [Sat, 26 Jun 1999 15:58:28 +0000 (15:58 +0000)]
Add var defines for no testandset
Bruce Momjian [Sat, 26 Jun 1999 15:54:36 +0000 (15:54 +0000)]
Remove -m486 on Openbsd.
Michael Meskes [Fri, 25 Jun 1999 10:42:06 +0000 (10:42 +0000)]
*** empty log message ***
Tom Lane [Fri, 25 Jun 1999 00:13:45 +0000 (00:13 +0000)]
Makefile.global failed to define $(LIBS), which is
unfortunate considering that several subdirectory makefiles were counting
on it to do so...
Michael Meskes [Thu, 24 Jun 1999 13:15:31 +0000 (13:15 +0000)]
*** empty log message ***
Thomas G. Lockhart [Wed, 23 Jun 1999 06:21:19 +0000 (06:21 +0000)]
Remove User's Guide entities since they were not being used.
Thomas G. Lockhart [Wed, 23 Jun 1999 06:19:36 +0000 (06:19 +0000)]
Add information on generating INSTALL and HISTORY from sgml sources.
Thomas G. Lockhart [Wed, 23 Jun 1999 06:17:51 +0000 (06:17 +0000)]
Clarify input/output timezone information.
Add detail on exact interpretation of "concatenated date"
for various lengths.
Thomas G. Lockhart [Wed, 23 Jun 1999 06:15:37 +0000 (06:15 +0000)]
Add backup/restore info to Admin Guide.
Split management chapter from start-ag.sgml to manage-ag.sgml.
Thomas G. Lockhart [Wed, 23 Jun 1999 06:12:31 +0000 (06:12 +0000)]
Minor changes to Fred Horsh's updates.
Thomas G. Lockhart [Wed, 23 Jun 1999 06:09:57 +0000 (06:09 +0000)]
Update maximum identifier length from 15 to 31 characters.
Peter Mount [Wed, 23 Jun 1999 05:56:20 +0000 (05:56 +0000)]
Some fixes supplied by Jon Nielsen jonfn@image.dk
Bruce Momjian [Mon, 21 Jun 1999 15:23:58 +0000 (15:23 +0000)]
The references to mailing lists in the resources page seem outdated.
Patch attached.
Fred Horch
Bruce Momjian [Mon, 21 Jun 1999 15:12:19 +0000 (15:12 +0000)]
Some suggestions to clarify the current status of PostgreSQL. Patch
attached.
Fred Horch
Tom Lane [Mon, 21 Jun 1999 01:26:56 +0000 (01:26 +0000)]
Replace rewriter's checkQueryHasAggs and checkQueryHasSubLink
with expression_tree_walker-based code. The former failed to cope with
expressions containing SubLinks, and the latter returned TRUE for both
SubLinks and Aggrefs (cut-and-paste bug?). There is a lot more scope for
using expression_tree_walker in this module, but I'll restrain myself
until the 6.6 split occurs from touching not-demonstrably-broken code.
Tom Lane [Mon, 21 Jun 1999 01:20:57 +0000 (01:20 +0000)]
Clean up problems with sublinks + grouping in planner. Not
sure if they are all fixed, because rewriter is now the stumbling block,
but at least some cases work that did not work before.
Tom Lane [Mon, 21 Jun 1999 01:18:02 +0000 (01:18 +0000)]
On second thought, expression_tree_walker should handle bare
SubLink nodes after all ...
Bruce Momjian [Sat, 19 Jun 1999 05:05:52 +0000 (05:05 +0000)]
I have a small patch for 6.5.
aclchk.c: heap_close() is not called after calling heap_openr().
Atsushi Ogawa
Bruce Momjian [Sat, 19 Jun 1999 05:00:30 +0000 (05:00 +0000)]
Rename to vararg_format().
Bruce Momjian [Sat, 19 Jun 1999 04:54:23 +0000 (04:54 +0000)]
Change form() to varargform() to prevent portability problems.
Tom Lane [Sat, 19 Jun 1999 03:48:31 +0000 (03:48 +0000)]
My first chosen victim for expression_tree_walker conversion
is parse_aggs.c. This fixes its failure to cope with (at least) CaseExpr
and ArrayRef nodes, which is the reason why both of these fail in 6.5:
select coalesce(f1,0) from int4_tbl group by f1;
ERROR: Illegal use of aggregates or non-group column in target list
select sentence.words[0] from sentence group by sentence.words[0];
ERROR: Illegal use of aggregates or non-group column in target list
The array case still fails, but at least it's not parse_agg's fault
anymore ... considering that we now support CASE officially, I think
it's important to fix the first example ...
Tom Lane [Sat, 19 Jun 1999 03:41:45 +0000 (03:41 +0000)]
Create a generic expression-tree-walker subroutine, which
will gradually replace all of the boilerplate tree-walk-recursion code that
currently exists in O(N) slightly different forms in N subroutines.
I've had it with adding missing cases to these subroutines...
Tom Lane [Sat, 19 Jun 1999 00:44:44 +0000 (00:44 +0000)]
Temporarily disable error checks for missing selectivity
functions, in order to work around oversight in 6.5 release: rtree
index functions haven't got any. Mea culpa ...
Bruce Momjian [Fri, 18 Jun 1999 16:47:23 +0000 (16:47 +0000)]
Patch to allow vacuum on multi-segment tables, from Hiroshi Inoue
Thomas G. Lockhart [Fri, 18 Jun 1999 05:03:48 +0000 (05:03 +0000)]
Incorporate fixes from Date and Darwen, 1997.
Did not check the function declarations as carefully as the other parts,
though all of the function names *do* match up with D&D.
Bruce Momjian [Fri, 18 Jun 1999 00:46:11 +0000 (00:46 +0000)]
linux_ppc now use -O0 to fix problem in optimization of fmgr calls.
Tom Lane [Thu, 17 Jun 1999 23:45:32 +0000 (23:45 +0000)]
Explain didn't handle inheritance correctly (it didn't
manipulate rtable the same way executor does).
Tom Lane [Thu, 17 Jun 1999 22:21:41 +0000 (22:21 +0000)]
Defend against function calls with more than 8 arguments (code
used to overrun its fixed-size arrays before detecting error; not cool).
Also, replace uses of magic constant '8' with 'MAXFARGS'.
Bruce Momjian [Thu, 17 Jun 1999 15:16:09 +0000 (15:16 +0000)]
Remove QUERY_LIMIT and documenation on same. Change _ALIGN to TYPEALIGN
for Irix.