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

Commit Graph

  • 980acc8329 Fix sed expression for BSD sed. Peter Eisentraut 2003-01-21 10:11:52 +00:00
  • bdfbfde1b1 IN clauses appearing at top level of WHERE can now be handled as joins. There are two implementation techniques: the executor understands a new JOIN_IN jointype, which emits at most one matching row per left-hand row, or the result of the IN's sub-select can be fed through a DISTINCT filter and then joined as an ordinary relation. Along the way, some minor code cleanup in the optimizer; notably, break out most of the jointree-rearrangement preprocessing in planner.c and put it in a new file prep/prepjointree.c. Tom Lane 2003-01-20 18:55:07 +00:00
  • be2b660ecd This patch includes a lot of minor cleanups to the SGML documentation, including: Bruce Momjian 2003-01-19 00:13:31 +00:00
  • 2042daf5c3 Improve symlink handling for C tags file. Bruce Momjian 2003-01-18 06:06:51 +00:00
  • d12be5c37b Add section on testing index scan. Bruce Momjian 2003-01-17 17:15:14 +00:00
  • 3c731e0ed7 Add dash to: Bruce Momjian 2003-01-17 03:28:18 +00:00
  • b19adc1aae Fix parse_agg.c to detect ungrouped Vars in sub-SELECTs; remove code that used to do it in planner. That was an ancient kluge that was never satisfactory; errors should be detected at parse time when possible. But at the time we didn't have the support mechanism (expression_tree_walker et al) to make it convenient to do in the parser. Tom Lane 2003-01-17 03:25:04 +00:00
  • a4d82dd4b4 Adjust API of expression_tree_mutator and query_tree_mutator to simplify callers. It turns out the common case is that the caller does want to recurse into sub-queries, so push support for that into these subroutines. Tom Lane 2003-01-17 02:01:21 +00:00
  • 227a404cf4 Add code to print information about a detected deadlock cycle. The printed data is comparable to what you could read in the pg_locks view, were you fortunate enough to have been looking at it at the right time. Tom Lane 2003-01-16 21:01:45 +00:00
  • 136828c699 Ooops, didn't cut-and-paste quite enough code from ResolveNew; with result that flatten_join_alias_vars failed to descend into subselects. Tom Lane 2003-01-16 18:26:02 +00:00
  • c0f0d709e6 Fix bogus formatting of DROP DATABASE command, per Christopher Kings-Lynne. Tom Lane 2003-01-16 15:28:06 +00:00
  • 57ce0f84f2 Fix bogus formatting of DROP DATABASE command, per Christopher Kings-Lynne. Tom Lane 2003-01-16 15:27:59 +00:00
  • db398d05be Repair an embarrassingly large number of alphabetization mistakes in the datetime token tables. Even more embarrassing, the regression tests revealed some of the problems --- but evidently the bogus output wasn't questioned. Add code to postmaster startup to directly check the tables for correct ordering, in hopes of not being embarrassed like this again. Tom Lane 2003-01-16 00:27:17 +00:00
  • cb23b8415b Repair an embarrassingly large number of alphabetization mistakes in the datetime token tables. Even more embarrassing, the regression tests revealed some of the problems --- but evidently the bogus output wasn't questioned. Add code to postmaster startup to directly check the tables for correct ordering, in hopes of not being embarrassed like this again. Tom Lane 2003-01-16 00:26:49 +00:00
  • 828822bc96 Add remaining documentation tables to information schema. Peter Eisentraut 2003-01-15 23:37:28 +00:00
  • cde9f852e0 Now that switch_outer processing no longer relies on being run after join_references(), it's practical to consolidate all join_references() processing into the set_plan_references traversal in setrefs.c. This seems considerably cleaner than the old way where we did it for join quals in createplan.c and for targetlists in setrefs.c. Tom Lane 2003-01-15 23:10:32 +00:00
  • 606d4f7b38 Oops, put back changes. Those were Peter's, not mine. Bruce Momjian 2003-01-15 21:55:52 +00:00
  • 57a15288a1 Revert my changes to features.sgml. Bruce Momjian 2003-01-15 21:44:35 +00:00
  • 1fb7158124 More comment cleanups for shared_buffers in postgresql.conf. Bruce Momjian 2003-01-15 20:50:18 +00:00
  • 0c64b58b6c More comment cleanups for shared_buffers in postgresql.conf. Bruce Momjian 2003-01-15 20:49:56 +00:00
  • 430fd35368 Update shared_buffer comment in postgresql.conf. Bruce Momjian 2003-01-15 20:41:33 +00:00
  • 20803fa3d2 Update shared_buffer comment in postgresql.conf. Bruce Momjian 2003-01-15 20:41:18 +00:00
  • 4b874036c2 Back out ORDER BY addition to Inet, for Tom. Bruce Momjian 2003-01-15 20:01:01 +00:00
  • de97072e3c Allow merge and hash joins to occur on arbitrary expressions (anything not containing a volatile function), rather than only on 'Var = Var' clauses as before. This makes it practical to do flatten_join_alias_vars at the start of planning, which in turn eliminates a bunch of klugery inside the planner to deal with alias vars. As a free side effect, we now detect implied equality of non-Var expressions; for example in SELECT ... WHERE a.x = b.y and b.y = 42 we will deduce a.x = 42 and use that as a restriction qual on a. Also, we can remove the restriction introduced 12/5/02 to prevent pullup of subqueries whose targetlists contain sublinks. Still TODO: make statistical estimation routines in selfuncs.c and costsize.c smarter about expressions that are more complex than plain Vars. The need for this is considerably greater now that we have to be able to estimate the suitability of merge and hash join techniques on such expressions. Tom Lane 2003-01-15 19:35:48 +00:00
  • 0eed62f34d Reorder VARCHAR() to appear before CHAR() in docs. Bruce Momjian 2003-01-15 18:01:05 +00:00
  • 7112d38c7e This patch fixes an incorrect statement and makes a few cleanups to contrib/fulltextindex/README.fti Bruce Momjian 2003-01-15 16:45:34 +00:00
  • d14c64c4a3 This patch fixes an incorrect statement and makes a few cleanups to contrib/fulltextindex/README.fti Bruce Momjian 2003-01-15 16:45:17 +00:00
  • 3b6ca54cda This patch includes some minor fixes and improvements to the SGML docs for PL/PgSQL. Bruce Momjian 2003-01-15 16:40:24 +00:00
  • ecbd8daaac Add ORDER BY for inet regression, pointed out by Rod Taylor. Bruce Momjian 2003-01-15 16:35:50 +00:00
  • 2160c9177d Add sql_features table to information schema. Generate the features list in the documentation from that same data. Peter Eisentraut 2003-01-14 23:19:34 +00:00
  • 1eddbd81fa Readd #include netinet/in.h for FreeBSD. Bruce Momjian 2003-01-14 22:52:57 +00:00
  • 97f0d0c86f Escape ampersand. Peter Eisentraut 2003-01-14 10:19:02 +00:00
  • 56e6436c3a Bumped up build number to 200 Barry Lind 2003-01-14 09:42:07 +00:00
  • 3b8147a003 Bumped up build number to 107 Barry Lind 2003-01-14 09:40:48 +00:00
  • 3f479efa2f Backport to 7.3 of patch to correctly handle fractional seconds Barry Lind 2003-01-14 09:15:35 +00:00
  • feefc329bd Patch from Florian Wunderlich to correctly support java Timestamps. Previously the code would only capture milliseconds where as both postgres and the java Timestamp object support greater resolution. Also fixed a bug reported by Rhett Sutphin where the last digit of the fractional seconds was lost when using timestamp without time zone Barry Lind 2003-01-14 09:13:51 +00:00
  • 9db065ba56 Patch from Aaron Mulder to have pooled connections implement PGConnection Barry Lind 2003-01-14 05:46:49 +00:00
  • 3ff4496454 Patch from Kris Jurka to improve the performance of getImportedKeys(). The fix uses explicit joins to avoid using the genetic query optimizer for consistent results. Barry Lind 2003-01-14 05:07:56 +00:00
  • 88e524063a Patch from Kris Jurka to improve the performance of getImportedKeys(). Use explicit joins to avoid using the genetic query optimizer. Also fixed a regression test that was failing to compile. This change also cleans up how key names are reported as per: A change to the value of the FK_NAME column. Currently the returned value is the triggers arguments which look like Barry Lind 2003-01-14 05:05:26 +00:00
  • 956762a546 Add: Bruce Momjian 2003-01-14 00:47:35 +00:00
  • 4e9face69a Add Hugarian FAQ, from Laszlo Hornyak Bruce Momjian 2003-01-13 23:00:32 +00:00
  • 1e9f85b9f6 Fix information_schema.sql install to work when building outside source tree. Tom Lane 2003-01-13 20:37:18 +00:00
  • 56e1aab286 Reconsider mechanism for marking sub-selects that are at top level of a qualification clause (and hence can get away with being sloppy about distinguishing FALSE from UNKNOWN). We need to know this in subselect.c; marking the subplans in setrefs.c is too late. Tom Lane 2003-01-13 18:10:53 +00:00
  • de432ce39e Change Adjust_lo_type() so that it doesn't cause an error even when cast functions are allowed to be volatile. Hiroshi Inoue 2003-01-13 04:28:55 +00:00
  • 9e66243c35 Fixes to pgcvslog for last narrive entry. Bruce Momjian 2003-01-13 01:57:47 +00:00
  • 8ac6d952cf Cause planner to account for evaluation costs in targetlists and HAVING quals. Normally this is an insignificant effect --- but it will not be insignificant when these clauses contain sub-selects. The added costs cannot affect the planning of the query containing them, but they might have an impact when the query is a sub-query of a larger one. Tom Lane 2003-01-13 00:29:26 +00:00
  • d1686b42ab Recent changes in sublink representation require exprType() to accept SubPlan nodes, else explaining queries containing sublinks may fail. Tom Lane 2003-01-13 00:18:51 +00:00
  • d4ce5a4f4c Revise cost_qual_eval() to compute both startup (one-time) and per-tuple costs for expression evaluation, not only per-tuple cost as before. This extension is needed in order to deal realistically with hashed or materialized sub-selects. Tom Lane 2003-01-12 22:35:29 +00:00
  • d51260aa9d Fix wrong/misleading comments, be more consistent about where to call ExecAssignResultTypeFromTL(). Tom Lane 2003-01-12 22:01:38 +00:00
  • b05204ac8a Fix some minor grammatical errors. Tom Lane 2003-01-12 18:42:59 +00:00
  • 9392c40553 Update CHAR(). Bruce Momjian 2003-01-12 18:36:22 +00:00
  • 13437d1e9c Replace RelidGetNamespaceId() by get_rel_namespace(). Peter Eisentraut 2003-01-12 18:19:37 +00:00
  • 6f4855842c Update CHAR() description. Bruce Momjian 2003-01-12 14:58:46 +00:00
  • d340e00626 Update date only. Bruce Momjian 2003-01-12 05:35:55 +00:00
  • 4976816b03 Improve CHAR() description. Bruce Momjian 2003-01-12 05:16:12 +00:00
  • 19b886332a First cut at implementing IN (and NOT IN) via hashtables. There is more to be done yet, but this is a good start. Tom Lane 2003-01-12 04:03:34 +00:00
  • 3e54e26bcf SGML build cleanups from Neil Conway. Bruce Momjian 2003-01-12 01:33:00 +00:00
  • fbc590fd6c Fix capitalization. Bruce Momjian 2003-01-11 21:03:21 +00:00
  • 161c2a7be6 Fix capitalization. Bruce Momjian 2003-01-11 21:02:49 +00:00
  • bb6652552a Back out flockfile change for NetBSD. Giles Lean reports they are not supported. Bruce Momjian 2003-01-11 19:38:23 +00:00
  • 7680826848 Cause symlinks for shared-library versioning to run in the standard direction on HP-UX; our former approach has been obsolete since HPUX 9. Tom Lane 2003-01-11 17:22:34 +00:00
  • 43057c7a27 Cause symlinks for shared-library versioning to run in the standard direction on HP-UX; our former approach has been obsolete since HPUX 9. Tom Lane 2003-01-11 17:22:19 +00:00
  • 266eb6ad28 Fix markup problem in link to other SGML file. Bruce Momjian 2003-01-11 17:03:45 +00:00
  • 8b434d647e Fix typo in an error messages Tatsuo Ishii 2003-01-11 06:59:30 +00:00
  • 38535f8e32 Fix typo in an error message Tatsuo Ishii 2003-01-11 06:55:11 +00:00
  • 8ca66703e2 > > This patch improves the documentation for the shared_buffers GUC param. > > I'd suggest that the runtime.sgml description explicitly say "values of > at least a few thousand are recommended for production installations". Bruce Momjian 2003-01-11 05:04:27 +00:00
  • 3cd7edfee0 > > This patch improves the documentation for the shared_buffers GUC param. > > I'd suggest that the runtime.sgml description explicitly say "values of > at least a few thousand are recommended for production installations". Bruce Momjian 2003-01-11 05:04:14 +00:00
  • ef581f0552 Rewrite for-loop, because this is not the Obfuscated C Code Contest. Bruce Momjian 2003-01-11 05:01:03 +00:00
  • 295ece4a0c A tiny patch to fix a typo in configure.in and another one in RELEASE_CHANGES. Bruce Momjian 2003-01-11 04:59:08 +00:00
  • bcf7a35f3c A tiny patch to fix a typo in configure.in and another one in RELEASE_CHANGES. Bruce Momjian 2003-01-11 04:58:44 +00:00
  • ab74a932a3 Add doc links from SET to SET_CONSTRAINTS, SET_SESSION_AUTH, SET_TRANSACTION. Bruce Momjian 2003-01-11 00:39:52 +00:00
  • 2650fba6ff Fix markup. Peter Eisentraut 2003-01-11 00:00:03 +00:00
  • 1afac12910 Create a new file executor/execGrouping.c to centralize utility routines shared by nodeGroup, nodeAgg, and soon nodeSubplan. Tom Lane 2003-01-10 23:54:24 +00:00
  • e2123a9708 Add missing <limits.h> for INT64_IS_BUSTED case. Tom Lane 2003-01-10 23:51:46 +00:00
  • c83702606c Add missing <limits.h> for INT64_IS_BUSTED case. Tom Lane 2003-01-10 23:49:06 +00:00
  • b65cd56240 Read-only transactions, as defined in SQL. Peter Eisentraut 2003-01-10 22:03:30 +00:00
  • b7ca9bdf18 Do not shell-quote the name of the editor, so that the editor can be a command with arguments. Peter Eisentraut 2003-01-10 21:57:44 +00:00
  • e69785debf Further tweaking of parsetree & plantree representation of SubLinks. Simplify SubLink by storing just a List of operator OIDs, instead of a list of incomplete OpExprs --- that was a bizarre and bulky choice, with no redeeming social value since we have to build new OpExprs anyway when forming the plan tree. Tom Lane 2003-01-10 21:08:15 +00:00
  • 36ea26793a Add optional drop behavior clause to REVOKE command, for SQL conformance. Currently, only RESTRICT is allowed. Peter Eisentraut 2003-01-10 11:02:51 +00:00
  • 611278cc0b Clean ip.c. Peter Eisentraut 2003-01-10 10:59:08 +00:00
  • 6bc61fc046 Adjust parser so that 'x NOT IN (subselect)' is converted to 'NOT (x IN (subselect))', that is 'NOT (x = ANY (subselect))', rather than 'x <> ALL (subselect)' as we formerly did. This opens the door to optimizing NOT IN the same way as IN, whereas there's no hope of optimizing the expression using <>. Also, convert 'x <> ALL (subselect)' to the NOT(IN) style, so that the optimization will be available when processing rules dumped by older Postgres versions. initdb forced due to small change in SubLink node representation. Tom Lane 2003-01-09 20:50:53 +00:00
  • 59779c81ba Add missing #include <getopt.h>. Tom Lane 2003-01-09 18:27:39 +00:00
  • 83b06823f6 Move new typedef AclId into c.h, so as to avoid cluttering namespace by having to include miscadmin.h into other header files. Tom Lane 2003-01-09 18:00:24 +00:00
  • 9df2c44032 Fix IPv6 detection and IPv6 to 4 conversion to use only standard interfaces. Peter Eisentraut 2003-01-09 14:35:03 +00:00
  • 2e98da5246 Call timestamp_in with proper arguments, per gripe from Mark Halliwell. Tom Lane 2003-01-09 07:10:07 +00:00
  • 4a9588f671 Fix indenting of log_min_error_statement. Bruce Momjian 2003-01-09 05:19:18 +00:00
  • 8e20b91e78 Fix indenting of log_min_error_statement. Bruce Momjian 2003-01-09 05:19:02 +00:00
  • 0481f3f461 Remove bit.c/h routines. Not used anymore. Bruce Momjian 2003-01-09 01:23:55 +00:00
  • 9ecfdbcae1 Repair inconsistent rounding behavior for timestamp, time, interval, per gripe from Csaba Nagy. There is still potential for platform-specific behavior for values that are exactly halfway between integers, but at least we now get the expected answer for all other cases. Tom Lane 2003-01-09 01:07:18 +00:00
  • fb715e05f5 Repair inconsistent rounding behavior for timestamp, time, interval, per gripe from Csaba Nagy. There is still potential for platform-specific behavior for values that are exactly halfway between integers, but at least we now get the expected answer for all other cases. Tom Lane 2003-01-09 01:06:57 +00:00
  • 2cd00f0bac add to threads discussion. Bruce Momjian 2003-01-09 01:04:35 +00:00
  • 1c25c52c66 Add missing pg_proc entry for interval_scale(). The lack of this entry causes interval rounding not to work as expected in 7.3, for example SELECT '18:17:15.6'::interval(0) does not round the value. I did not force initdb, but one is needed to install the added row. Tom Lane 2003-01-09 00:58:41 +00:00
  • 9260e79d11 Remove 'const' from secure_write, to prevent compiler warning. Bruce Momjian 2003-01-08 23:34:37 +00:00
  • 7aa2038d82 Remove 'const' from secure_write, to prevent compiler warning. Bruce Momjian 2003-01-08 23:34:22 +00:00
  • 3bb248ac23 Guard against stopping when numberTuples=0 and counter wraps around. Tom Lane 2003-01-08 23:32:29 +00:00
  • ce83fc68aa The second was that renegotiation was just plain broken. I can't believe I didn't notice this before -- once 64k was sent to/from the server the client would crash. Basicly, in 7.3 the server SSL code set the initial state to "about to renegotiate" without actually starting the renegotiation. In addition, the server and client didn't properly handle the SSL_ERROR_WANT_(READ|WRITE) error. This is fixed in the second patch. Bruce Momjian 2003-01-08 23:18:35 +00:00
  • b56af49849 The second was that renegotiation was just plain broken. I can't believe I didn't notice this before -- once 64k was sent to/from the server the client would crash. Basicly, in 7.3 the server SSL code set the initial state to "about to renegotiate" without actually starting the renegotiation. In addition, the server and client didn't properly handle the SSL_ERROR_WANT_(READ|WRITE) error. This is fixed in the second patch. Bruce Momjian 2003-01-08 23:18:25 +00:00
  • 671231f588 I was playing around with 7.3.1 and found some more SSL problems. The first, that I missed when checking over 7.3.1, was that the client method was switched to SSLv23 along with the server. The SSLv23 client method does SSLv2 by default, but can also understand SSLv3. In our situation the SSLv2 backwords compatibility is really only needed on the server. This is the first patch. Bruce Momjian 2003-01-08 22:57:05 +00:00
  • 6ccb5aebad I was playing around with 7.3.1 and found some more SSL problems. The first, that I missed when checking over 7.3.1, was that the client method was switched to SSLv23 along with the server. The SSLv23 client method does SSLv2 by default, but can also understand SSLv3. In our situation the SSLv2 backwords compatibility is really only needed on the server. This is the first patch. Bruce Momjian 2003-01-08 22:56:58 +00:00
  • fdb1c80747 Fix dumping of DEFERRABLE/INITIALLY DEFERRED: Bruce Momjian 2003-01-08 22:54:36 +00:00