OSDN Git Service
Tom Lane [Thu, 30 Mar 2000 05:49:47 +0000 (05:49 +0000)]
Unixware fix for new config.guess output,
from Bill.Allie@mug.org.
Tom Lane [Thu, 30 Mar 2000 05:30:42 +0000 (05:30 +0000)]
Make use of configure symbols for unportable constructs. Make
inclusions of system headers more consistent.
Tom Lane [Thu, 30 Mar 2000 05:29:44 +0000 (05:29 +0000)]
Autoconf.
Tom Lane [Thu, 30 Mar 2000 05:29:21 +0000 (05:29 +0000)]
Add configure checks to see if 'using namespace std' and
'#include <string>' work in the local C++ compiler.
Thomas G. Lockhart [Thu, 30 Mar 2000 05:07:48 +0000 (05:07 +0000)]
Change cross reference to CREATE AGGREGATE to a citation, since the
Programmer's Guide does not have access to the reference page.
Normalize markup.
Tom Lane [Thu, 30 Mar 2000 02:59:14 +0000 (02:59 +0000)]
Remove extraneous semicolon.
Tom Lane [Thu, 30 Mar 2000 02:51:12 +0000 (02:51 +0000)]
Replace refs to v6.6 with v7.0.
Tom Lane [Thu, 30 Mar 2000 00:53:30 +0000 (00:53 +0000)]
Tweak indexscan cost estimation: round estimated # of tuples visited up
to next integer. Previously, if selectivity was small, we could compute
very tiny scan cost on the basis of estimating that only 0.001 tuple
would be fetched, which is silly. This naturally led to some rather
silly plans...
Peter Eisentraut [Wed, 29 Mar 2000 16:12:31 +0000 (16:12 +0000)]
Added latest config.guess and config.sub
Thomas G. Lockhart [Wed, 29 Mar 2000 03:57:18 +0000 (03:57 +0000)]
Change rules for interpreting date/time input to disallow 1 and 3 character
years. Rejects dates like '0.085', which were accepted previously.
Thomas G. Lockhart [Wed, 29 Mar 2000 03:57:11 +0000 (03:57 +0000)]
Change rules for interpreting date/time input to disallow 1 and 3 character
years. Rejects dates like '0.085', which were accepted previously.
Minor mods of ODBC markup.
Thomas G. Lockhart [Tue, 28 Mar 2000 14:35:27 +0000 (14:35 +0000)]
Fix markup for terminology.
Thomas G. Lockhart [Tue, 28 Mar 2000 14:35:13 +0000 (14:35 +0000)]
Add mention of join syntax to release notes, and reformat a few lines.
Update porting info. Still need a lot of platforms tested.
Fix small errors in markup.
Thomas G. Lockhart [Tue, 28 Mar 2000 14:16:07 +0000 (14:16 +0000)]
Update SGML catalog references to DocBook 3.1 on FreeBSD.
Matches postgresql.org/hub.org environment.
Tom Lane [Tue, 28 Mar 2000 03:39:50 +0000 (03:39 +0000)]
Small improvements to user's guide description of arrays.
Tom Lane [Tue, 28 Mar 2000 02:59:55 +0000 (02:59 +0000)]
Oops, missed some < and > that need to be < and > ...
Tom Lane [Tue, 28 Mar 2000 02:53:02 +0000 (02:53 +0000)]
Clean up major bogosity in description of creating a new index operator
class. This chapter was apparently sewed together from several
inconsistent examples... and perhaps from old docs that no longer
apply at all.
Tom Lane [Tue, 28 Mar 2000 02:51:09 +0000 (02:51 +0000)]
Add a little to index operator class discussion.
Tom Lane [Tue, 28 Mar 2000 02:49:19 +0000 (02:49 +0000)]
Fix some bogosity in the tutorial examples.
Bruce Momjian [Mon, 27 Mar 2000 22:39:13 +0000 (22:39 +0000)]
Allow compile to finish even if plperl fails, which it does now.
Peter Eisentraut [Mon, 27 Mar 2000 21:11:37 +0000 (21:11 +0000)]
Fixed bug with repeated \e in psql (failed to clear buffers correctly)
Thomas G. Lockhart [Mon, 27 Mar 2000 17:14:43 +0000 (17:14 +0000)]
Start updating for the v7.0 release.
Use "generic functions" for math and other routines.
Use SQL92 "type 'literal'" syntax rather than Postgres "'literal'::type".
Thomas G. Lockhart [Mon, 27 Mar 2000 17:12:06 +0000 (17:12 +0000)]
Allow full type names in CREATE FUNCTION arguments and return type.
Move CREATE FUNCTION/WITH clause to end of statement to get around
shift/reduce conflicts with type names containing "WITH".
Add lots of tokens as allowed ColId's and/or ColLabel's,
so this should be a complete set for the v7.0 release.
Thomas G. Lockhart [Mon, 27 Mar 2000 17:07:48 +0000 (17:07 +0000)]
Fix up comments where had been uglified by the automated reformatter.
Thomas G. Lockhart [Mon, 27 Mar 2000 17:04:47 +0000 (17:04 +0000)]
Change form of query which used "DISTINCT ON" to help support primary keys.
We still have an internal limit in the ODBC code of 8 columns per key,
but this should lay the groundwork for resolving that.
Includes reformulated query from Tom Lane.
Bruce Momjian [Mon, 27 Mar 2000 16:07:59 +0000 (16:07 +0000)]
Add html FAQ and FAQ_DEV sources
Tatsuo Ishii [Mon, 27 Mar 2000 02:12:03 +0000 (02:12 +0000)]
Enhance pg_ctl so that it prints error messages from postmaster
if it fails to start up it (this is only vaild if -w is given).
Tom Lane [Sun, 26 Mar 2000 19:47:17 +0000 (19:47 +0000)]
Update obsolete statement that indexes can have only 7 columns.
Reorganize description of index features for more clarity.
Tom Lane [Sun, 26 Mar 2000 19:45:21 +0000 (19:45 +0000)]
Update/improve documentation about creating aggregate functions.
Tom Lane [Sun, 26 Mar 2000 19:43:58 +0000 (19:43 +0000)]
nodeAgg has always been willing to accept an aggregate with a finalFunc
and only one transition state, but the CREATE AGGREGATE code rejected
this combination.
Peter Eisentraut [Sun, 26 Mar 2000 18:32:30 +0000 (18:32 +0000)]
Updated user's guide to match new psql's output format
Fixed bug in createdb/alternative location
Tom Lane [Sun, 26 Mar 2000 07:04:54 +0000 (07:04 +0000)]
Improve descriptions of postmaster switches.
Tom Lane [Sun, 26 Mar 2000 07:03:38 +0000 (07:03 +0000)]
Rearrange steps in recommended install procedure to something more
reasonable, ie configure and build first, then optionally run regress
tests using new parallel (non-installed) test method, and only then
backup and kill old installation.
Tom Lane [Sun, 26 Mar 2000 07:01:19 +0000 (07:01 +0000)]
Add description of new parallel regression testing method; update
procedure to cover running either test script; other minor improvements.
Tom Lane [Sun, 26 Mar 2000 06:59:31 +0000 (06:59 +0000)]
Update descriptions of configure's options, and document how to specify
multiple directories for --with-includes or --with-libraries.
Tom Lane [Sun, 26 Mar 2000 06:58:17 +0000 (06:58 +0000)]
Fix erroneous claim that 'postmaster -S' leaves the postmaster running
in the foreground --- in fact, it auto-detaches.
Bruce Momjian [Sun, 26 Mar 2000 03:40:37 +0000 (03:40 +0000)]
Update initdb flags.
Tatsuo Ishii [Sun, 26 Mar 2000 02:35:01 +0000 (02:35 +0000)]
Change resultmap:
powerpc-unknown-linux-gnu --> powerpc-unknown-linux-gnulibc1
this is because for new config.guess.
Tatsuo Ishii [Sun, 26 Mar 2000 02:28:07 +0000 (02:28 +0000)]
New platform specific geometry regression expected file for
powerpc-linux-gnulibc1.
Tatsuo Ishii [Sun, 26 Mar 2000 02:25:34 +0000 (02:25 +0000)]
Remove some results from int4-not-representable.out
This is due to the changes made to int4.sql.
< SELECT dsqrt(float8 '64') AS eight;
< eight
< -------
< 8
< (1 row)
<
< SELECT |/float8 '64' AS eight;
< eight
< -------
< 8
< (1 row)
<
< SELECT ||/float8 '27' AS three;
< three
< -------
< 3
< (1 row)
<
Tom Lane [Sun, 26 Mar 2000 01:29:25 +0000 (01:29 +0000)]
Make configure --help produce slightly more useful and consistently-
formatted descriptions of --with options.
Tom Lane [Sun, 26 Mar 2000 01:00:17 +0000 (01:00 +0000)]
In PQnotifies discussion, reference PQsocket as function needed to get
file descriptor number for select(). (Suggestion from Ken Wright.)
Bruce Momjian [Sun, 26 Mar 2000 00:18:57 +0000 (00:18 +0000)]
Attached is the regression diff for geometry, RedHat 6.1 on a Pentium
200 MMX. I was going through my e-mail, cleaning out my 1000+ message
inbox, and found this one. Sorry.
--
Lamar Owen
Tom Lane [Sat, 25 Mar 2000 19:26:49 +0000 (19:26 +0000)]
Remove bogus complexity from build/install of plperl. This stuff was
apparently copied from the makefile for the perl5 interface module,
which needs it for reasons explained in src/interfaces/Makefile.
But none of those reasons apply to plperl.
Tom Lane [Sat, 25 Mar 2000 19:10:27 +0000 (19:10 +0000)]
Old patch from Mark Hollomon to add plperl to createlang's repertoire.
Seems to have slipped through the cracks.
Tom Lane [Sat, 25 Mar 2000 19:01:48 +0000 (19:01 +0000)]
Another fix for old shells.
Tom Lane [Sat, 25 Mar 2000 18:46:17 +0000 (18:46 +0000)]
Fix syntax error reported by old shells ("if ! command..." is a
neologism, apparently).
Bruce Momjian [Sat, 25 Mar 2000 14:44:42 +0000 (14:44 +0000)]
More >&1 cleanups
Bruce Momjian [Sat, 25 Mar 2000 14:36:58 +0000 (14:36 +0000)]
More changes of >& to 2>&1
Bruce Momjian [Sat, 25 Mar 2000 14:32:50 +0000 (14:32 +0000)]
Remove >& and make it 2>&1
Bruce Momjian [Sat, 25 Mar 2000 14:25:31 +0000 (14:25 +0000)]
Add POLLUTE=1 to perl Makefile.PL creations.
Tom Lane [Fri, 24 Mar 2000 23:34:19 +0000 (23:34 +0000)]
transformCreateStmt should put Ident nodes, not ColumnDef nodes, into
keys lists of Constraint nodes. This eliminates a type pun that would
probably have caused trouble someday, and eliminates circular references
in the parsetree that were causing trouble now.
Also, change parser's uses of strcasecmp() to strcmp(). Since scan.l
has downcased any unquoted identifier, it is never correct to check an
identifier with strcasecmp() in the parser. For example,
CREATE TABLE FOO (f1 int, UNIQUE("F1"));
was accepted, which is wrong, and xlateSqlFunc did more than it should:
select datetime();
ERROR: Function 'timestamp()' does not exist
(good)
select "DateTime"();
ERROR: Function 'timestamp()' does not exist
(bad)
Tom Lane [Fri, 24 Mar 2000 23:26:45 +0000 (23:26 +0000)]
Improve comment.
Tom Lane [Fri, 24 Mar 2000 21:40:43 +0000 (21:40 +0000)]
Save a few cycles in simple cases: no need to call cost_sort() when there
is no presorted path to compare with.
Bruce Momjian [Fri, 24 Mar 2000 14:39:07 +0000 (14:39 +0000)]
Remove -O2 for aix.
Bruce Momjian [Fri, 24 Mar 2000 03:57:06 +0000 (03:57 +0000)]
Move LOCK terms down.
Tom Lane [Fri, 24 Mar 2000 02:58:25 +0000 (02:58 +0000)]
outfuncs.c was missing a print routine for Material plan nodes, leading
to trouble when trying to EXPLAIN VERBOSE a plan containing one.
Tom Lane [Fri, 24 Mar 2000 02:41:46 +0000 (02:41 +0000)]
Rename bytea functions to not have upper-case letters in their names.
Clean up grotty coding in them, too. AFAICS from the CVS logs, these
have been broken since Postgres95, so I'm not going to insist on an
initdb to fix them now...
Tom Lane [Fri, 24 Mar 2000 01:39:55 +0000 (01:39 +0000)]
Fold PQsetenv working state into PGconn, rather than trying to maintain
it in a separate object. There's no value in keeping the state separate,
and it creates dangling-pointer problems. Also, remove PQsetenv routines
from public API, until and unless they are redesigned to have a safer
interface. Since they were never part of the documented API before 7.0,
it's unlikely that anyone is calling them.
Tatsuo Ishii [Fri, 24 Mar 2000 01:37:11 +0000 (01:37 +0000)]
Update multi-byte support README
Bruce Momjian [Fri, 24 Mar 2000 01:20:09 +0000 (01:20 +0000)]
Update HISTORY
Tom Lane [Thu, 23 Mar 2000 23:35:47 +0000 (23:35 +0000)]
A little further tweaking of the range-query selectivity logic:
to avoid undue sensitivity to roundoff error, believe that a zero
or slightly negative range estimate should represent a small
positive selectivity, rather than falling back on a generic default
estimate.
Bruce Momjian [Thu, 23 Mar 2000 23:16:49 +0000 (23:16 +0000)]
>> 5. empty define that results in an empty but terminated line ( ; )
easy (maybe dumb) fix for 5 in attachment define.patch
greetings, Andreas
Bruce Momjian [Thu, 23 Mar 2000 22:25:36 +0000 (22:25 +0000)]
Back out // compiler flag.
Bruce Momjian [Thu, 23 Mar 2000 21:38:58 +0000 (21:38 +0000)]
Hmm, absolute pathnames for the copy makes sense. I'll whip up that
patch in a second. Should be sufficent to just make sure the first
character is a '/', right?
Ross J. Reedstrom
Bruce Momjian [Thu, 23 Mar 2000 17:27:36 +0000 (17:27 +0000)]
Some points for portability improvements:
1. C++ style comments in C source for ecpg ( // comment )
2. compiler finds wrong include file extern.h in ecpg/lib/descriptor.c
from
include path instead of workdir (rename it ?)
3. fe-connect getsockopt takes a socklen_t as fifth arg not int (use
SOCKET_SIZE_TYPE instead)
4. char vs unsigned char in psql calls to libpq
5. empty define that results in an empty but terminated line ( ; )
Now for all but point 3 I can supply changes to the
compiler flags, to make the compiler less pedantic.
Or is someone interested in the complications ?
in the meantime can someone apply the attached patch ?
Andreas
Bruce Momjian [Thu, 23 Mar 2000 15:09:56 +0000 (15:09 +0000)]
Update history/sgml.
Bruce Momjian [Thu, 23 Mar 2000 15:00:11 +0000 (15:00 +0000)]
Please apply the attached patch to interfaces/libpq/libpq-fe.h. This would
allow to write applications which do not have a link to postgres_ext.h in
their source directory.
Andreas Kardos
Michael Meskes [Thu, 23 Mar 2000 07:53:48 +0000 (07:53 +0000)]
*** empty log message ***
Tom Lane [Thu, 23 Mar 2000 07:42:13 +0000 (07:42 +0000)]
subselect regress test was kind of silly; it claimed to test correlation
cases but actually did no such thing. Make it test some more cases than
before (including things that didn't work in 6.5).
Tom Lane [Thu, 23 Mar 2000 07:40:00 +0000 (07:40 +0000)]
Float-to-int conversion functions should return NULL when given NULL
input, not throw a gratuitous elog().
Tom Lane [Thu, 23 Mar 2000 07:38:30 +0000 (07:38 +0000)]
Remove no-longer-necessary restriction against uplevel correlation vars
outside WHERE clause. Fix a couple of places that didn't handle uplevel
refs cleanly.
Tom Lane [Thu, 23 Mar 2000 07:36:03 +0000 (07:36 +0000)]
Hack parse_coerce so it won't try to constant-fold the dummy Const
nodes introduced by make_subplan(). It'd be better if we used a
different node type for subplan result placeholders, but for now...
Tom Lane [Thu, 23 Mar 2000 07:32:58 +0000 (07:32 +0000)]
ExecSubPlan needs to be able to cope with RelabelType nodes atop the
Const placeholder nodes for subplan result values.
Bruce Momjian [Thu, 23 Mar 2000 06:35:58 +0000 (06:35 +0000)]
Update TODO list.
Bruce Momjian [Thu, 23 Mar 2000 06:30:58 +0000 (06:30 +0000)]
Update HISTORY file for 7.0.
Tatsuo Ishii [Thu, 23 Mar 2000 02:04:07 +0000 (02:04 +0000)]
Prepare for 7.0 release
Tom Lane [Thu, 23 Mar 2000 00:58:36 +0000 (00:58 +0000)]
If we cannot get a real estimate for the selectivity of a range query,
use a default value that's fairly small. We were generating a result
of about 0.1, but I think 0.01 is probably better --- want to encourage
use of an indexscan in this situation.
Tom Lane [Thu, 23 Mar 2000 00:55:42 +0000 (00:55 +0000)]
Improve selectivity estimation involving string constants: pay attention
to more than one character, and try to do the right thing in non-ASCII
locales.
Tom Lane [Wed, 22 Mar 2000 22:08:35 +0000 (22:08 +0000)]
Repair logic flaw in cost estimator: cost_nestloop() was estimating CPU
costs using the inner path's parent->rows count as the number of tuples
processed per inner scan iteration. This is wrong when we are using an
inner indexscan with indexquals based on join clauses, because the rows
count in a Relation node reflects the selectivity of the restriction
clauses for that rel only. Upshot was that if join clause was very
selective, we'd drastically overestimate the true cost of the join.
Fix is to calculate correct output-rows estimate for an inner indexscan
when the IndexPath node is created and save it in the path node.
Change of path node doesn't require initdb, since path nodes don't
appear in saved rules.
Bruce Momjian [Wed, 22 Mar 2000 05:25:06 +0000 (05:25 +0000)]
Update pg_dumpall again.
Bruce Momjian [Wed, 22 Mar 2000 05:10:22 +0000 (05:10 +0000)]
Fix pg_dumpall for new psql output.
Tom Lane [Tue, 21 Mar 2000 06:35:22 +0000 (06:35 +0000)]
Forgot that odbc had its own copies of config.sub/config.guess.
Update those to latest Autoconf sources, too.
Thomas G. Lockhart [Tue, 21 Mar 2000 06:02:22 +0000 (06:02 +0000)]
Fix query for primary keys to reflect new DISTINCT ON () syntax.
Reported by "Tibor Laszlo" <ltibor@mail.tiszanet.hu> and fix suggested by
"Hiroshi Inoue" <Inoue@tpf.co.jp>.
Thomas G. Lockhart [Tue, 21 Mar 2000 06:00:41 +0000 (06:00 +0000)]
Add syntax for BIT() and BIT VARYING(), but no underlying implementation
is available yet.
Remove redundant call to xlateSqlType() in the character
type handling code.
Thomas G. Lockhart [Tue, 21 Mar 2000 05:59:14 +0000 (05:59 +0000)]
Update test for new ORDER BY clause from Tom Lane.
Tom Lane [Tue, 21 Mar 2000 05:12:12 +0000 (05:12 +0000)]
Restructure planning code so that preprocessing of targetlist and quals
to simplify constant expressions and expand SubLink nodes into SubPlans
is done in a separate routine subquery_planner() that calls union_planner().
We formerly did most of this work in query_planner(), but that's the
wrong place because it may never see the real targetlist. Splitting
union_planner into two routines also allows us to avoid redundant work
when union_planner is invoked recursively for UNION and inheritance
cases. Upshot is that it is now possible to do something like
select float8(count(*)) / (select count(*) from int4_tbl) from int4_tbl
group by f1;
which has never worked before.
Tom Lane [Tue, 21 Mar 2000 04:20:45 +0000 (04:20 +0000)]
Correct typo in error message.
Bruce Momjian [Tue, 21 Mar 2000 01:52:12 +0000 (01:52 +0000)]
This patch corrects spelling, grammar and euphony for the psql reference
page for 7.0:
Oliver Elphick
Bruce Momjian [Mon, 20 Mar 2000 15:42:47 +0000 (15:42 +0000)]
Reverse out BYTEA type coersion.
Vadim B. Mikheev [Mon, 20 Mar 2000 07:25:39 +0000 (07:25 +0000)]
Turn XLOG off (do not create log file).
Tom Lane [Mon, 20 Mar 2000 05:20:34 +0000 (05:20 +0000)]
Emit 'this operator is deprecated' warnings for ':' and ';'.
Tom Lane [Mon, 20 Mar 2000 05:19:11 +0000 (05:19 +0000)]
Convert float8 regress test to use exp() and ln() instead of ':' and
';' operators.
Bruce Momjian [Mon, 20 Mar 2000 04:26:01 +0000 (04:26 +0000)]
Update for BYTEAOID.
Tom Lane [Mon, 20 Mar 2000 04:22:11 +0000 (04:22 +0000)]
Sorry, I have read the misspelling 'coersion' one time too many.
Tom Lane [Mon, 20 Mar 2000 04:20:52 +0000 (04:20 +0000)]
Add exp(), ln(), and some other functions to numeric-functions table.
Tom Lane [Mon, 20 Mar 2000 04:19:47 +0000 (04:19 +0000)]
Add note that ':' and ';' operators are deprecated.
Bruce Momjian [Mon, 20 Mar 2000 04:02:47 +0000 (04:02 +0000)]
Add compatiblity information for bytea.
Hiroshi Inoue [Mon, 20 Mar 2000 00:24:37 +0000 (00:24 +0000)]
Add FORCE keyword to ColID
Tom Lane [Sun, 19 Mar 2000 22:48:30 +0000 (22:48 +0000)]
Make use of pre-existing regexp match capability to eliminate redundant
entries in template selection rules. Also, change alpha-dec-osf pattern
to cope with version info attached to the 'alpha' part.