hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-11 16:57:35 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • f71fb9e0b8 Add a little to index operator class discussion. Tom Lane 2000-03-28 02:51:09 +00:00
  • 1f7ba1ebaf Fix some bogosity in the tutorial examples. Tom Lane 2000-03-28 02:49:19 +00:00
  • 081cba45e6 Allow compile to finish even if plperl fails, which it does now. Bruce Momjian 2000-03-27 22:39:13 +00:00
  • a9f37f16d2 Fixed bug with repeated \e in psql (failed to clear buffers correctly) Peter Eisentraut 2000-03-27 21:11:37 +00:00
  • 39f69bc38f 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 2000-03-27 17:14:43 +00:00
  • 2dabd2cd1f 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 2000-03-27 17:12:06 +00:00
  • 2c8223f14b Fix up comments where had been uglified by the automated reformatter. Thomas G. Lockhart 2000-03-27 17:07:48 +00:00
  • 0b96c6f4ae 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. Thomas G. Lockhart 2000-03-27 17:04:47 +00:00
  • 8d7dc6fffe Add html FAQ and FAQ_DEV sources Bruce Momjian 2000-03-27 16:07:59 +00:00
  • a92ab528ef 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). Tatsuo Ishii 2000-03-27 02:12:03 +00:00
  • 2ce4b4cda1 Update obsolete statement that indexes can have only 7 columns. Reorganize description of index features for more clarity. Tom Lane 2000-03-26 19:47:17 +00:00
  • ee4dcf1478 Update/improve documentation about creating aggregate functions. Tom Lane 2000-03-26 19:45:21 +00:00
  • 0a27641c1a 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. Tom Lane 2000-03-26 19:43:58 +00:00
  • 4579e68db2 Updated user's guide to match new psql's output format Fixed bug in createdb/alternative location Peter Eisentraut 2000-03-26 18:32:30 +00:00
  • 3871b69ba1 Improve descriptions of postmaster switches. Tom Lane 2000-03-26 07:04:54 +00:00
  • a7b8de40db 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 2000-03-26 07:03:38 +00:00
  • 5521658e30 Add description of new parallel regression testing method; update procedure to cover running either test script; other minor improvements. Tom Lane 2000-03-26 07:01:19 +00:00
  • 4e9c534766 Update descriptions of configure's options, and document how to specify multiple directories for --with-includes or --with-libraries. Tom Lane 2000-03-26 06:59:31 +00:00
  • 7c81a130a4 Fix erroneous claim that 'postmaster -S' leaves the postmaster running in the foreground --- in fact, it auto-detaches. Tom Lane 2000-03-26 06:58:17 +00:00
  • ba834d6425 Update initdb flags. Bruce Momjian 2000-03-26 03:40:37 +00:00
  • d7959b5c71 Change resultmap: powerpc-unknown-linux-gnu --> powerpc-unknown-linux-gnulibc1 this is because for new config.guess. Tatsuo Ishii 2000-03-26 02:35:01 +00:00
  • f3160a6530 New platform specific geometry regression expected file for powerpc-linux-gnulibc1. Tatsuo Ishii 2000-03-26 02:28:07 +00:00
  • 5363144d37 Remove some results from int4-not-representable.out This is due to the changes made to int4.sql. Tatsuo Ishii 2000-03-26 02:25:34 +00:00
  • bccac99e97 Make configure --help produce slightly more useful and consistently- formatted descriptions of --with options. Tom Lane 2000-03-26 01:29:25 +00:00
  • cb3b3eda9a In PQnotifies discussion, reference PQsocket as function needed to get file descriptor number for select(). (Suggestion from Ken Wright.) Tom Lane 2000-03-26 01:00:17 +00:00
  • d2684ea712 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. Bruce Momjian 2000-03-26 00:18:57 +00:00
  • 0abebf0e7b 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 2000-03-25 19:26:49 +00:00
  • e4739e7029 Old patch from Mark Hollomon to add plperl to createlang's repertoire. Seems to have slipped through the cracks. Tom Lane 2000-03-25 19:10:27 +00:00
  • cfc0ba8c04 Another fix for old shells. Tom Lane 2000-03-25 19:01:48 +00:00
  • c446802b22 Fix syntax error reported by old shells ("if ! command..." is a neologism, apparently). Tom Lane 2000-03-25 18:46:17 +00:00
  • 1aecb8d2ff More >&1 cleanups Bruce Momjian 2000-03-25 14:44:42 +00:00
  • 3df65f8499 More changes of >& to 2>&1 Bruce Momjian 2000-03-25 14:36:58 +00:00
  • 6e801bd8db Remove >& and make it 2>&1 Bruce Momjian 2000-03-25 14:32:50 +00:00
  • 0dd9558ed7 Add POLLUTE=1 to perl Makefile.PL creations. Bruce Momjian 2000-03-25 14:25:31 +00:00
  • 5c462baebc 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 2000-03-24 23:34:19 +00:00
  • 8f50f7a291 Improve comment. Tom Lane 2000-03-24 23:26:45 +00:00
  • 8cbeb5f131 Save a few cycles in simple cases: no need to call cost_sort() when there is no presorted path to compare with. Tom Lane 2000-03-24 21:40:43 +00:00
  • c07118b3b3 Remove -O2 for aix. Bruce Momjian 2000-03-24 14:39:07 +00:00
  • be0204133c Move LOCK terms down. Bruce Momjian 2000-03-24 03:57:06 +00:00
  • 39cd6e2e91 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 2000-03-24 02:58:25 +00:00
  • eca02fee2c 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 2000-03-24 02:41:46 +00:00
  • 0edcee3459 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. Tom Lane 2000-03-24 01:39:55 +00:00
  • 5b1f92eaa7 Update multi-byte support README Tatsuo Ishii 2000-03-24 01:37:11 +00:00
  • 853cf66176 Update HISTORY Bruce Momjian 2000-03-24 01:20:09 +00:00
  • 7177bbac29 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. Tom Lane 2000-03-23 23:35:47 +00:00
  • 6d79d6027c >> 5. empty define that results in an empty but terminated line ( ; ) easy (maybe dumb) fix for 5 in attachment define.patch Bruce Momjian 2000-03-23 23:16:49 +00:00
  • f8645018bc Back out // compiler flag. Bruce Momjian 2000-03-23 22:25:36 +00:00
  • 4ddc50dffa 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? Bruce Momjian 2000-03-23 21:38:58 +00:00
  • b2d867fb08 Some points for portability improvements: Bruce Momjian 2000-03-23 17:27:36 +00:00
  • 90cb4c89df Update history/sgml. Bruce Momjian 2000-03-23 15:09:56 +00:00
  • 2f839c58e2 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. Bruce Momjian 2000-03-23 15:00:11 +00:00
  • ac3884e2a9 *** empty log message *** Michael Meskes 2000-03-23 07:53:48 +00:00
  • 3097788f66 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 2000-03-23 07:42:13 +00:00
  • 5c63975504 Float-to-int conversion functions should return NULL when given NULL input, not throw a gratuitous elog(). Tom Lane 2000-03-23 07:40:00 +00:00
  • 37ab088770 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 2000-03-23 07:38:30 +00:00
  • dadb14fa60 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 2000-03-23 07:36:03 +00:00
  • 9da6d2c0e7 ExecSubPlan needs to be able to cope with RelabelType nodes atop the Const placeholder nodes for subplan result values. Tom Lane 2000-03-23 07:32:58 +00:00
  • b212e7ad7b Update TODO list. Bruce Momjian 2000-03-23 06:35:58 +00:00
  • b508136d81 Update HISTORY file for 7.0. Bruce Momjian 2000-03-23 06:30:58 +00:00
  • 5ca8eb9216 Prepare for 7.0 release Tatsuo Ishii 2000-03-23 02:04:07 +00:00
  • 1afaa2557a 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 2000-03-23 00:58:36 +00:00
  • cad764f349 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 2000-03-23 00:55:42 +00:00
  • 1d5e7a6f46 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. Tom Lane 2000-03-22 22:08:35 +00:00
  • d825e55c13 Update pg_dumpall again. Bruce Momjian 2000-03-22 05:25:06 +00:00
  • 233a52eaff Fix pg_dumpall for new psql output. Bruce Momjian 2000-03-22 05:10:22 +00:00
  • e1a1f22f13 Forgot that odbc had its own copies of config.sub/config.guess. Update those to latest Autoconf sources, too. Tom Lane 2000-03-21 06:35:22 +00:00
  • b688f8f034 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 2000-03-21 06:02:22 +00:00
  • dcdcada7e9 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 2000-03-21 06:00:41 +00:00
  • 3c7ca8d459 Update test for new ORDER BY clause from Tom Lane. Thomas G. Lockhart 2000-03-21 05:59:14 +00:00
  • 3ee8f7e207 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 2000-03-21 05:12:12 +00:00
  • aafe86d995 Correct typo in error message. Tom Lane 2000-03-21 04:20:45 +00:00
  • 1d5df1547a This patch corrects spelling, grammar and euphony for the psql reference page for 7.0: Bruce Momjian 2000-03-21 01:52:12 +00:00
  • 2216584bcf Reverse out BYTEA type coersion. Bruce Momjian 2000-03-20 15:42:47 +00:00
  • df238b2c06 Turn XLOG off (do not create log file). Vadim B. Mikheev 2000-03-20 07:25:39 +00:00
  • 3caa56fe5e Emit 'this operator is deprecated' warnings for ':' and ';'. Tom Lane 2000-03-20 05:20:34 +00:00
  • 72b4086711 Convert float8 regress test to use exp() and ln() instead of ':' and ';' operators. Tom Lane 2000-03-20 05:19:11 +00:00
  • 7f116a6b83 Update for BYTEAOID. Bruce Momjian 2000-03-20 04:26:01 +00:00
  • 8fc97e8276 Sorry, I have read the misspelling 'coersion' one time too many. Tom Lane 2000-03-20 04:22:11 +00:00
  • b9a990d8a8 Add exp(), ln(), and some other functions to numeric-functions table. Tom Lane 2000-03-20 04:20:52 +00:00
  • 339fe3c4cb Add note that ':' and ';' operators are deprecated. Tom Lane 2000-03-20 04:19:47 +00:00
  • 0e1f485f5f Add compatiblity information for bytea. Bruce Momjian 2000-03-20 04:02:47 +00:00
  • fe8098ed0c Add FORCE keyword to ColID Hiroshi Inoue 2000-03-20 00:24:37 +00:00
  • 966b5337e9 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. Tom Lane 2000-03-19 22:48:30 +00:00
  • 42ef928327 Autoconf run Tom Lane 2000-03-19 22:46:56 +00:00
  • 641c368ae9 Change configure.in to note that since we are using expr(1)'s regex match command, the entries in template/.similar can really be regular expressions. This isn't a new feature, just an observation of what the code already did. Tom Lane 2000-03-19 22:46:22 +00:00
  • b178865891 cash_words_out function truncated its output by 1 character due to incorrect use of StrNCpy. Tom Lane 2000-03-19 22:10:52 +00:00
  • 58422dd0af Several calls to StrNCpy incorrectly subtracted 1 from the length arg, leading to postmaster accepting args 1 shorter than it had room for. Tom Lane 2000-03-19 22:10:08 +00:00
  • 6a02746550 Change MemSet and StrNCpy to evaluate their arguments only once. Fix inadequate parenthesization in several other macros. Tom Lane 2000-03-19 22:08:51 +00:00
  • fdd7f59820 Since PORTNAME is no longer used at the level of C code (it's only in Makefiles now), there's no reason for os2client to maintain its own copy of c.h just to change #define PORTNAME. Simplify Makefile accordingly. Get rid of horribly-out-of-date modified copy of c.h, which should never have been in the distribution to start with, since it's actually a derived file. Now it's not needed anyway. Tom Lane 2000-03-19 21:59:30 +00:00
  • 3e0321f6e9 Proper unpack de_DE.ISO-8859-1 Bruce Momjian 2000-03-19 19:52:44 +00:00
  • d6429e552d Minor code rearrangement & doc improvement in eval_const_expressions(). Tom Lane 2000-03-19 18:20:38 +00:00
  • cf6420dd94 *** empty log message *** Michael Meskes 2000-03-19 10:04:47 +00:00
  • a73b75615f transformExpr() did the Wrong Thing if applied to a SubLink node that had already been transformed. This led to failure in examples like UPDATE table SET fld = (SELECT ...). Repair this, and revise the comments to explain that transformExpr has to be robust against this condition. Someday we might want to fix the callers so that transformExpr is never invoked on its own output, but that someday is not today. Tom Lane 2000-03-19 07:13:58 +00:00
  • 52d0265736 it seems in the beta2 release DBUSERID in pg_dumpall is the _name_ of the user, so it doesn't need to be translated from the number to the name. Bruce Momjian 2000-03-19 02:19:43 +00:00
  • cfa929f601 Fix incorrect implementation of log(x) for numeric, as well as incorrect descriptions of a couple of log-related functions. I will not force an initdb for this, but log() on a numeric won't work until you do one... Tom Lane 2000-03-19 01:12:18 +00:00
  • 440b0fea3d Another go-round with resolution of ambiguous functions and operators. In function parsing, try for an actual function of the given name and input types before trying to interpret the function call as a type coercion request, rather than after. Before, a function that had the same name as a type and operated on a binary-compatible type wouldn't get invoked. Also, cross-pollinate between func_select_candidates and oper_select_candidates to ensure that they use as nearly the same resolution rules as possible. A few other minor code cleanups too. Tom Lane 2000-03-19 00:19:39 +00:00
  • f11d253e25 In can_coerce_type, verify that a possible type-coercion function actually returns the type it is named for. Tom Lane 2000-03-19 00:15:39 +00:00
  • 7d392f257b Fixed psql -c "\slashcmd" Peter Eisentraut 2000-03-18 22:48:29 +00:00
  • f4d452c13c Update bytea type description Bruce Momjian 2000-03-18 20:50:10 +00:00
  • d63e05a638 Improve error message wording in unary_op_error() --- suggest that problem could be lack of parentheses. This addresses cases like X UserOp UserOp Y, which will be parsed as (X UserOp) UserOp Y, whereas what likely was wanted was X UserOp (UserOp Y). Tom Lane 2000-03-18 19:53:54 +00:00