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

Commit Graph

  • 0cc0d0822d Document that get_attstatsslot/free_attstatsslot only need to be passed valid type information if they are asked to fetch the values part of a pg_statistic slot; these arguments are unneeded if fetching only the numbers part. Use this to save a catcache lookup in btcostestimate, which is looking like a bit of a hotspot in recent profiling. Not a big savings, but since it's essentially free, might as well do it. Tom Lane 2005-10-11 17:27:14 +00:00
  • d30c134806 Fix oversight in 8.0 modification of RestrictInfo data structures. A RestrictInfo representing an OR clause now contains two versions of the contained expression, one with sub-RestrictInfos and one without. clause_selectivity() should descend to the version with sub-RestrictInfos so that it has a chance of caching its results for the OR's sub-clauses. Failing to do so resulted in redundant planner effort. Tom Lane 2005-10-11 16:45:00 +00:00
  • 07e6f93d6b Fix oversight in 8.0 modification of RestrictInfo data structures. A RestrictInfo representing an OR clause now contains two versions of the contained expression, one with sub-RestrictInfos and one without. clause_selectivity() should descend to the version with sub-RestrictInfos so that it has a chance of caching its results for the OR's sub-clauses. Failing to do so resulted in redundant planner effort. Tom Lane 2005-10-11 16:44:40 +00:00
  • c6b9924bec Remove the DELETEs from pg_shadow and pg_group that pg_dumpall used to emit when given the --clean option, in favor of individual DROP ROLE commands. The old technique could not possibly work in 8.1, and was never a very good idea anyway IMHO. The DROP ROLE approach has the defect that the DROPs will fail for roles that own objects or have privileges, but perhaps we can improve that later. Tom Lane 2005-10-10 22:29:48 +00:00
  • 375e7d5579 Use a safer order of operations in dropdb(): rollbackable operations, ie removing shared-dependency entries, should happen before non-rollbackable ones. That way a failure during the rollbackable part doesn't leave us with inconsistent state. Tom Lane 2005-10-10 20:02:20 +00:00
  • 15a110ed01 Document the process to update translations. Peter Eisentraut 2005-10-10 19:41:27 +00:00
  • b473d7adc4 Translation update Peter Eisentraut 2005-10-10 19:36:36 +00:00
  • 9178306151 Fix the problem of GRANTs creating "dangling" privileges not directly traceable to grant options. As per my earlier proposal, a GRANT made by a role member has to be recorded as being granted by the role that actually holds the grant option, and not the member. Tom Lane 2005-10-10 18:49:04 +00:00
  • d7527540f2 <limits.h> is now needed here, for INT_MAX. Per Michael Fuhr. Tom Lane 2005-10-10 01:34:00 +00:00
  • 313ed1ed94 Fix (hopefully for the last time) problems with datetime values displaying like '23:59:60' because of fractional-second roundoff problems. Trying to control this upstream of the actual display code was hopeless; the right way is to explicitly round fractional seconds in the display code and then refigure the results if the fraction rounds up to 1. Per bug #1927. Tom Lane 2005-10-09 17:21:47 +00:00
  • 7754f7634c Fix a thinko in description of krb_server_hostname. Tom Lane 2005-10-08 20:27:25 +00:00
  • 76cb32d848 Fix up grammar in variable description string. Tom Lane 2005-10-08 20:08:19 +00:00
  • 18d0ca2d1b Fix Kerberos authentication in wake of virtual-hosts changes --- need to call krb5_sname_to_principal() always. Also, use krb_srvname rather than the hardwired string 'postgres' as the appl_version string in the krb5_sendauth/recvauth calls, to avoid breaking compatibility with PG 8.0. Magnus Hagander Tom Lane 2005-10-08 19:32:58 +00:00
  • 4909357237 Remove unnecessary ABORT commands in dblink regression tests. Bruce Momjian 2005-10-08 16:10:38 +00:00
  • 768dfd0375 Cosmetic improvements to dblink. Bruce Momjian 2005-10-08 12:18:48 +00:00
  • f3576c33f8 Cosmetic changes to dblink. Bruce Momjian 2005-10-08 12:12:29 +00:00
  • 7d937cd408 Cosmetic changes to dblink. Bruce Momjian 2005-10-08 11:33:45 +00:00
  • adeca513f7 Add spacing around operators. Bruce Momjian 2005-10-08 02:39:27 +00:00
  • 82e861fbe1 Fix LWLockAssign() so that it can safely be executed after postmaster initialization. Add spinlocking, fix EXEC_BACKEND unsafeness. Tom Lane 2005-10-07 21:42:38 +00:00
  • 77d1de3c89 Minor parentheses cleanup. Bruce Momjian 2005-10-07 20:26:41 +00:00
  • 8e0c8a2463 Add spaces around operator. Bruce Momjian 2005-10-07 20:13:16 +00:00
  • bb55e583f6 Allocate a few extra LWLocks for possible use by add-on modules. Per request from Marc Munro. Tom Lane 2005-10-07 20:11:03 +00:00
  • 426d0158ca Marginal performance improvement in aclmask(): don't bother with testing ownership if the caller isn't interested in any GOPTION bits (which is the common case). It did not matter in 8.0 where the ownership test was just a trivial equality test, but it matters now. Tom Lane 2005-10-07 19:59:34 +00:00
  • b888ab82da Recognize ERROR_SHARING_VIOLATION (translate to EACCES), increase log level for unrecognized win32 error codes to LOG, and make messages conform to style guide. Per old suggestion from Qingqing Zhou, which seems to have gotten lost in the shuffle. Tom Lane 2005-10-07 16:34:48 +00:00
  • d156e1f850 (Apologies for fat-fingering cvs commit command...) Should have read: Remove unportable use of tfind/tsearch in favor of bsearch. Fix up random number generator to use random() not rand() and to actually honor its min/max arguments properly. That wasn't so important before, but with exposure of capability to ask for general ranges, it will be. Tom Lane 2005-10-07 15:34:17 +00:00
  • 6ae7671497 gni Tom Lane 2005-10-07 15:31:49 +00:00
  • a84429a1aa Remove an unused typedef. Alvaro Herrera 2005-10-07 14:55:36 +00:00
  • ab13353d31 Update: Bruce Momjian 2005-10-07 14:04:19 +00:00
  • 02eb6ea9b7 Add: Bruce Momjian 2005-10-07 02:43:59 +00:00
  • dd0fa0f958 Minor dbf2pg fixes from Martin Pitt: check for failure when issuing CREATE TABLE command, and translate dBase's 'M' field type to 'text'. Tom Lane 2005-10-06 23:05:22 +00:00
  • e6b92542a3 Marginal speedup in RelationIsVisible and TypeIsVisible: avoid a redundant cache lookup in the success case. This won't help much for cases where the given relation is far down the search path, but it does not hurt in any cases either; and it requires only a little new code. Per gripe from Jim Nasby about slowness of \d with many tables. Tom Lane 2005-10-06 22:43:16 +00:00
  • f59175d72f Minor API cleanup for async notifications: we can only register the current backend in pg_listener, so there is little point in making the PID to register part of async.c's public API. Other minor tweaks. Neil Conway 2005-10-06 21:30:39 +00:00
  • 20f5a328e5 Backpatch merge_db() example for PL/PgSQL to 8.0. Patch from David Fetter, fixes by Neil Conway. Neil Conway 2005-10-06 21:21:27 +00:00
  • 663476919c Minor tweaks for PL/PgSQL documentation. Neil Conway 2005-10-06 20:51:20 +00:00
  • 9ea14ef56a When a function not returning RECORD has a single OUT parameter, use the parameter's name (if any) as the default column name for SELECT FROM the function, rather than the function name as previously. I still think this is a bad idea, but I lost the argument. Force decompilation of function RTEs to specify full aliases always, to reduce the odds of this decision breaking dumped views. Tom Lane 2005-10-06 19:51:16 +00:00
  • fa63749d21 Fix oversight in indexscan plan creation. I recently added code to use predicate_implied_by() to detect redundant filter conditions, but forgot that predicate_implied_by() assumes its first argument contains only immutable functions. Add a check to guarantee that. Also, test to see if filter conditions can be discarded because they are redundant with the predicate of a partial index. Tom Lane 2005-10-06 16:01:55 +00:00
  • e9f11c6b64 pg_config should print an error message to stderr and exit if an information item is not available. Peter Eisentraut 2005-10-06 12:04:58 +00:00
  • cb8b6618ce Revise pgstats stuff to fix the problems with not counting accesses generated by bitmap index scans. Along the way, simplify and speed up the code for counting sequential and index scans; it was both confusing and inefficient to be taking care of that in the per-tuple loops, IMHO. initdb forced because of internal changes in pg_stat view definitions. Tom Lane 2005-10-06 02:29:23 +00:00
  • b5aad11a1b Code cleanup for log_disconnections(). Patch from Qingqing Zhou, fixes by Neil Conway. Neil Conway 2005-10-05 23:46:06 +00:00
  • 8c6f345005 Improve wording of entry. Bruce Momjian 2005-10-05 19:52:22 +00:00
  • e011459029 Make set_function_size_estimates() marginally smarter: per original comment, it can at least test whether the expression returns set. Tom Lane 2005-10-05 17:19:19 +00:00
  • 93d358a8a4 Add -Winline to the default CFLAGS for gcc, and remove -Wold-style-definition, per recent discussion. Tom Lane 2005-10-05 17:11:45 +00:00
  • a5fecda550 Also synced the ecpg lexer with the backend lexer. Michael Meskes 2005-10-05 14:58:36 +00:00
  • f39cfbe4be Fix pgxs for spaces in file names on Win32 Bruce Momjian 2005-10-05 12:16:28 +00:00
  • ce150c4a8b Update Japanese FAQ. Bruce Momjian 2005-10-05 11:51:27 +00:00
  • 0f397b9edb Update Japanese FAQ. Bruce Momjian 2005-10-05 11:50:36 +00:00
  • b0db380b09 Update version number in faq. Bruce Momjian 2005-10-05 11:27:10 +00:00
  • ad308fc4e9 Update FAQ for version number. Bruce Momjian 2005-10-05 11:24:54 +00:00
  • a8da71e0c4 Clean up some messages and fix missing translation support. Option --log renamed to --log-file for clarity. Peter Eisentraut 2005-10-04 19:01:18 +00:00
  • 380ab3669f Fix compile error Teodor Sigaev 2005-10-04 17:10:55 +00:00
  • 2a3f44b769 Update FAQ's in 8.0.X branch. (very small changes) Bruce Momjian 2005-10-04 14:18:43 +00:00
  • 610a7c6fdc Add FAQ_hungarian.html to 8.0.X branch. Bruce Momjian 2005-10-04 14:17:44 +00:00
  • 8e48e91bc7 Oops. Partially saved file was committed. Tatsuo Ishii 2005-10-04 13:46:52 +00:00
  • f50ae06e14 Allow multiple -f options. Make pgbench "script driven" to eliminate hard coded transaction scenario. (Tatsuo Ishii) Tatsuo Ishii 2005-10-04 13:40:45 +00:00
  • ffa156bb5b Somehow I missed some parser changes, so this commit comes pretty late. I just synced the parser of ecpg against the backend version, but still have to sync the lexer. Michael Meskes 2005-10-04 13:28:21 +00:00
  • 9c76af4a5e Add _ to gettext triggers. Must have been forgotten here when it was introduced. Peter Eisentraut 2005-10-04 11:14:03 +00:00
  • 1e6201a22c Add an expected case to cover error message as spelled by python 2.2.3. Per buildfarm results and Michael Fuhr. Tom Lane 2005-10-04 02:50:04 +00:00
  • 31d276d0ed COPY's test for read-only transaction was backward; it prohibited COPY TO where it should prohibit COPY FROM. Found by Alon Goldshuv. REL7_4_9 Tom Lane 2005-10-03 23:43:45 +00:00
  • 3dfec7f73e COPY's test for read-only transaction was backward; it prohibited COPY TO where it should prohibit COPY FROM. Found by Alon Goldshuv. REL8_0_4 Tom Lane 2005-10-03 23:43:29 +00:00
  • 060d13f7c7 COPY's test for read-only transaction was backward; it prohibited COPY TO where it should prohibit COPY FROM. Found by Alon Goldshuv. Tom Lane 2005-10-03 23:43:09 +00:00
  • 53e47cdd79 Add a trace_sort option to help with measuring resource usage of external sort operations. Per recent discussion. Simon Riggs and Tom Lane. Tom Lane 2005-10-03 22:55:56 +00:00
  • 12992ab37a Separate out the VacRUsage stuff as an independent module, in preparation for using it for other things besides VACUUM. Tom Lane 2005-10-03 22:52:26 +00:00
  • ae049f191d Stamp release 7.3.11. REL7_3_11 Tom Lane 2005-10-03 17:24:27 +00:00
  • 4082f5e34f Stamp release 7.4.9. Tom Lane 2005-10-03 17:14:24 +00:00
  • 73a71f50cd Stamp release 8.0.4. Tom Lane 2005-10-03 17:07:18 +00:00
  • 69fbf4816b Update release notes for pending back-branch releases. Tom Lane 2005-10-03 16:05:29 +00:00
  • fd366be49a Update release notes for pending back-branch releases. Tom Lane 2005-10-03 16:05:09 +00:00
  • 65ae842791 Update release notes for pending back-branch releases. Tom Lane 2005-10-03 16:04:51 +00:00
  • 9c873828bd Fix procedure for updating nextval() defaults so that it actually works. Update release dates for pending back-branch releases. Tom Lane 2005-10-03 16:04:13 +00:00
  • 8c73dfcc8b Optimize benchmark query and update benchmark's results. Teodor Sigaev 2005-10-03 14:41:42 +00:00
  • a87174dca1 Fix font of sequence header. Bruce Momjian 2005-10-03 13:52:28 +00:00
  • 1624d6d4d2 Fix null bytes at end of file (weird). Bruce Momjian 2005-10-03 02:49:31 +00:00
  • f890004cc1 Update sequence docs. Bruce Momjian 2005-10-03 02:46:43 +00:00
  • e1684062bc Preserve tuple OIDs during ATRewriteTable. Per gripe from Duncan Crombie. Tom Lane 2005-10-03 02:45:25 +00:00
  • f20cad7870 Preserve tuple OIDs during ATRewriteTable. Per gripe from Duncan Crombie. Tom Lane 2005-10-03 02:45:12 +00:00
  • 4361e0d295 Merge Tom and my descriptions of new sequence behavior into one entry. Bruce Momjian 2005-10-03 02:21:16 +00:00
  • 07e74305fe Update release notes to show how to upgrade a database to use the new early binding for nextval() calls in default clauses. Bruce Momjian 2005-10-03 01:57:59 +00:00
  • 6a17577933 Remove, 8.1 completed items already removed: Bruce Momjian 2005-10-03 00:42:57 +00:00
  • 2aa39a4cb1 Done: Bruce Momjian 2005-10-03 00:42:28 +00:00
  • 64eea6c21d Expand pg_control information so that we can verify that the database was created on a machine with alignment rules and floating-point format similar to the current machine. Per recent discussion, this seems like a good idea with the increasing prevalence of 32/64 bit environments. Tom Lane 2005-10-03 00:28:43 +00:00
  • aa731ed843 Change nextval and other sequence functions to specify their sequence argument as a 'regclass' value instead of a text string. The frontend conversion of text string to pg_class OID is now encapsulated as an implicitly-invocable coercion from text to regclass. This provides backwards compatibility to the old behavior when the sequence argument is explicitly typed as 'text'. When the argument is just an unadorned literal string, it will be taken as 'regclass', which means that the stored representation will be an OID. This solves longstanding problems with renaming sequences that are referenced in default expressions, as well as new-in-8.1 problems with renaming such sequences' schemas or moving them to another schema. All per recent discussion. Along the way, fix some rather serious problems in dbmirror's support for mirroring sequence operations (int4 vs int8 confusion for instance). Tom Lane 2005-10-02 23:50:16 +00:00
  • 1b61ee3c69 _SPI_execute_plan failed to return result tuple table to caller in the ProcessUtility case, resulting in an intratransaction memory leak if a utility command actually did return any tuples, as reported by Dmitry Karasik. Fix this and also make the behavior more consistent for cases involving nested SPI operations and multiple query trees, by ensuring that we store the state locally until it is ready to be returned to the caller. Tom Lane 2005-10-01 18:43:19 +00:00
  • ca8cfc9846 Adjust wording. Bruce Momjian 2005-10-01 01:42:43 +00:00
  • c40cd3660f One of the web pages mentioned in dmetaphone.c has moved. Also fix a few typos in comments. Bruce Momjian 2005-09-30 22:38:44 +00:00
  • b4a7213b07 Equalize wordings to avoid redundant translation work. Peter Eisentraut 2005-09-30 09:56:26 +00:00
  • e5c453edce Clean up the help displays. Peter Eisentraut 2005-09-30 07:58:01 +00:00
  • 7df9f55f4b Change the option spelling to --connection-limit to be consistent with the SQL option spelling. Peter Eisentraut 2005-09-30 07:13:54 +00:00
  • a7084efd2d Fix confusion between relfilenode and Oid. Alvaro Herrera 2005-09-29 22:04:36 +00:00
  • c775b423c1 Fix unportable usages in new pgbench code (strndup, ctype macros) Tom Lane 2005-09-29 16:18:26 +00:00
  • 9b19abd74f Add -f option which enables to read SQL commands from a file. Patches Contributed by Tomoaki Sato. Tatsuo Ishii 2005-09-29 13:44:25 +00:00
  • 8928d4d69d Correct spelling Peter Eisentraut 2005-09-29 08:34:50 +00:00
  • 7f66816b5d Remove acronym in one title. Bruce Momjian 2005-09-29 02:29:48 +00:00
  • 7b7d1ba0b6 Mention fix for bug #1916 in release notes for affected versions. Tom Lane 2005-09-28 21:22:12 +00:00
  • 196c9d289e Repair planning bug introduced in 7.4: outer-join ON clauses that referenced only the inner-side relation would be considered as potential equijoin clauses, which is wrong because the condition doesn't necessarily hold above the point of the outer join. Per test case from Kevin Grittner (bug#1916). Tom Lane 2005-09-28 21:17:50 +00:00
  • 7aef1bfd1f Repair planning bug introduced in 7.4: outer-join ON clauses that referenced only the inner-side relation would be considered as potential equijoin clauses, which is wrong because the condition doesn't necessarily hold above the point of the outer join. Per test case from Kevin Grittner (bug#1916). Tom Lane 2005-09-28 21:17:24 +00:00
  • 2e1254e7fa Repair planning bug introduced in 7.4: outer-join ON clauses that referenced only the inner-side relation would be considered as potential equijoin clauses, which is wrong because the condition doesn't necessarily hold above the point of the outer join. Per test case from Kevin Grittner (bug#1916). Tom Lane 2005-09-28 21:17:02 +00:00
  • 4ff203262b Fix typo. Bruce Momjian 2005-09-28 18:40:28 +00:00
  • e05a8c553c Add section on reliable operation, talking about caching and storage subsystem reliability. Bruce Momjian 2005-09-28 18:18:02 +00:00
  • 1c25594549 Improve messages Peter Eisentraut 2005-09-28 13:11:26 +00:00
  • 92cdd00c05 Translation updates for the 8.0 branch Alvaro Herrera 2005-09-28 13:11:00 +00:00