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

Commit Graph

  • d359facb05 Remove unintended file change. Bruce Momjian 2005-08-09 05:14:26 +00:00
  • 833d91ae5e Fix ordering of default sync options to match code. Bruce Momjian 2005-08-09 05:01:10 +00:00
  • df24e93933 Update patches queue URL, description. Bruce Momjian 2005-08-09 04:56:58 +00:00
  • 6a3021b7d3 Done: Bruce Momjian 2005-08-09 04:51:18 +00:00
  • 487b757b7a Clarify wal_sync_method options in documentation. Bruce Momjian 2005-08-09 04:50:44 +00:00
  • 1c09a3c46d Fix crash when reading 'timezone = unknown' from postgresql.conf during SIGHUP; it's not OK for an assign_hook to return a non-malloc'd string. Problem was introduced during timezone library rewrite. Tom Lane 2005-08-08 23:39:14 +00:00
  • 3117afa75d Fix crash when reading 'timezone = unknown' from postgresql.conf during SIGHUP; it's not OK for an assign_hook to return a non-malloc'd string. Problem was introduced during timezone library rewrite. Tom Lane 2005-08-08 23:39:01 +00:00
  • 2dd9672d96 Done: Bruce Momjian 2005-08-08 20:26:53 +00:00
  • 15269b5955 Avoid useless loop overhead in AtEOXact routines when the backend is compiled with USE_ASSERT_CHECKING but is running with assert_enabled false. Tom Lane 2005-08-08 19:44:22 +00:00
  • 4568e0f791 Modify AtEOXact_CatCache and AtEOXact_RelationCache to assume that the ResourceOwner mechanism already released all reference counts for the cache entries; therefore, we do not need to scan the catcache or relcache at transaction end, unless we want to do it as a debugging crosscheck. Do the crosscheck only in Assert mode. This is the same logic we had previously installed in AtEOXact_Buffers to avoid overhead with large numbers of shared buffers. I thought it'd be a good idea to do it here too, in view of Kari Lavikka's recent report showing a real-world case where AtEOXact_CatCache is taking a significant fraction of runtime. Tom Lane 2005-08-08 19:17:23 +00:00
  • be27a20123 Cygwin no longer needs to hack SHLIB_LINK, now that Rocco Altier fixed the contrib library inclusions properly. Tom Lane 2005-08-08 03:35:13 +00:00
  • 7117cd3a77 Cause ShutdownPostgres to do a normal transaction abort during backend exit, instead of trying to take shortcuts. Introduce some additional shutdown callback routines to eliminate kluges like having ProcKill be responsible for shutting down the buffer manager. Ensure that the order of operations during shutdown is predictable and what you would expect given the module layering. Tom Lane 2005-08-08 03:12:16 +00:00
  • 89439b8c4f Set shlib naming convention on Cygwin to 'cygFOO.dll', which appears to be the platform standard. This should fix recursive-rule breakage due to recent Makefile changes. Per discussion. Tom Lane 2005-08-07 19:02:08 +00:00
  • c98a606f4d Fix count_usable_fds() to stop trying to open files once it reaches max_files_per_process. Going further than that is just a waste of cycles, and it seems that current Cygwin does not cope gracefully with deliberately running the system out of FDs. Per Andrew Dunstan. Tom Lane 2005-08-07 18:48:00 +00:00
  • 4cf0feae2c Fix count_usable_fds() to stop trying to open files once it reaches max_files_per_process. Going further than that is just a waste of cycles, and it seems that current Cygwin does not cope gracefully with deliberately running the system out of FDs. Per Andrew Dunstan. Tom Lane 2005-08-07 18:47:38 +00:00
  • 5337ad464e Fix count_usable_fds() to stop trying to open files once it reaches max_files_per_process. Going further than that is just a waste of cycles, and it seems that current Cygwin does not cope gracefully with deliberately running the system out of FDs. Per Andrew Dunstan. Tom Lane 2005-08-07 18:47:19 +00:00
  • 9b29f9f3f8 COPY performance improvements. Avoid calling CopyGetData for each input character, tighten the inner loops of CopyReadLine and CopyReadAttribute, arrange to parse out all the attributes of a line in just one call instead of one CopyReadAttribute call per attribute, be smarter about which client encodings require slow pg_encoding_mblen() loops. Also, clean up the mishmash of static variables and overly-long parameter lists in favor of passing around a single CopyState struct containing all the state data. Original patch by Alon Goldshuv, reworked by Tom Lane. Tom Lane 2005-08-06 20:41:58 +00:00
  • 28d3ee4771 Actually, this macro had worse problems than a bogus name ... Tom Lane 2005-08-05 15:01:48 +00:00
  • 848c30a501 Fix misspelled macro name. Doesn't appear to be used anywhere yet, so no one noticed. Tom Lane 2005-08-05 14:36:43 +00:00
  • 33f5bf9700 ALTER TABLE OWNER must change the ownership of the table's rowtype too. This was not especially critical before, but it is now that we track ownership dependencies --- the dependency for the rowtype *must* shift to the new owner. Spotted by Bernd Helmle. Also fix a problem introduced by recent change to allow non-superusers to do ALTER OWNER in some cases: if the table had a toast table, ALTER OWNER failed *even for superusers*, because the test being applied would conclude that the new would-be owner had no create rights on pg_toast. A side-effect of the fix is to disallow changing the ownership of indexes or toast tables separately from their parent table, which seems a good idea on the whole. Tom Lane 2005-08-04 01:09:29 +00:00
  • e48b28b688 Done: Bruce Momjian 2005-08-03 01:46:25 +00:00
  • 6eac4e69cf Tweak BgBufferSync() so that a persistent write error on a dirty buffer doesn't block the bgwriter from making progress writing out other buffers. This was a hard problem in the context of the ARC/2Q design, but it's trivial in the context of clock sweep ... just advance the sweep counter before we try to write not after. Tom Lane 2005-08-02 20:52:08 +00:00
  • 688784f671 Prevent planner from including temp tables of other backends when expanding an inheritance tree. Per recent discussions. Tom Lane 2005-08-02 20:27:45 +00:00
  • 558730ac6b Clean up CREATE DATABASE processing to make it more robust and get rid of special case for Windows port. Put a PG_TRY around most of createdb() to ensure that we remove copied subdirectories on failure, even if the failure happens while creating the pg_database row. (I think this explains Oliver Siegmar's recent report.) Having done that, there's no need for the fragile assumption that copydir() mustn't ereport(ERROR), so simplify its API. Eliminate the old code that used system("cp ...") to copy subdirectories, in favor of using copydir() on all platforms. This not only should allow much better error reporting, but allows us to fsync the created files before trusting that the copy has succeeded. Tom Lane 2005-08-02 19:02:32 +00:00
  • 0001e98d54 Code and docs review for pg_column_size() patch. Tom Lane 2005-08-02 16:11:57 +00:00
  • f023fc6689 Use ReadDir() not readdir() so as to have some modicum of error checking. Tom Lane 2005-08-02 15:17:24 +00:00
  • 74888b9349 Add ERROR_NO_MORE_FILES workaround to check_data_dir(). This may or may not be obsolete, but since every other readdir loop in our code has it, I think this should too. Tom Lane 2005-08-02 15:16:27 +00:00
  • 668448d6f0 rmtree() reported the wrong pathname if final rmdir failed. Tom Lane 2005-08-02 15:14:56 +00:00
  • 9216c8999a rmtree() reported the wrong pathname if final rmdir failed. Tom Lane 2005-08-02 15:14:47 +00:00
  • 35c4764f88 Un-Windows-ify newlines. Tom Lane 2005-08-02 14:07:27 +00:00
  • ae1d34f23a Back-port several small portability fixes to get contrib building cleanly on AIX in the 8.0 branch. Rocco Altier Tom Lane 2005-08-02 01:35:23 +00:00
  • 2a4fad1a0e Add NOWAIT option to SELECT FOR UPDATE/SHARE. Original patch by Hans-Juergen Schoenig, revisions by Karel Zak and Tom Lane. Tom Lane 2005-08-01 20:31:16 +00:00
  • ca7abcd89d nor -> or. Bruce Momjian 2005-08-01 19:38:03 +00:00
  • f58434f18f Documentation for ALTER object SET SCHEMA commands. Also some minor editorialization. Tom Lane 2005-08-01 16:11:14 +00:00
  • 614b6e2581 Done: Bruce Momjian 2005-08-01 14:13:30 +00:00
  • 523997daf1 Done: Bruce Momjian 2005-08-01 14:05:03 +00:00
  • 35508d1cca Add ALTER object SET SCHEMA capability for a limited but useful set of object kinds (tables, functions, types). Documentation is not here yet. Original code by Bernd Helmle, extensive rework by Bruce Momjian and Tom Lane. Tom Lane 2005-08-01 04:03:59 +00:00
  • a85e5d1b1b Add description: Bruce Momjian 2005-08-01 00:52:27 +00:00
  • d42cf5a42a Add per-user and per-database connection limit options. This patch also includes preliminary update of pg_dumpall for roles. Petr Jelinek, with review by Bruce Momjian and Tom Lane. Tom Lane 2005-07-31 17:19:22 +00:00
  • b125877107 Suggest syntax: Bruce Momjian 2005-07-31 13:54:52 +00:00
  • 73b574c187 Add item to sentence: Bruce Momjian 2005-07-31 03:28:52 +00:00
  • 81b1551e41 Spacing improvement. Bruce Momjian 2005-07-31 03:08:35 +00:00
  • ecf7fccebc Fix broken markup and spelling, put paragraph in a somewhat less random place. Tom Lane 2005-07-30 22:53:15 +00:00
  • a42407c5a2 Use the standard spelling of the protocol argument to get/setsockopt. Tom Lane 2005-07-30 20:28:20 +00:00
  • 5b5013f502 Fix justify_days() for integer datestamp, clean up code. Bruce Momjian 2005-07-30 18:20:44 +00:00
  • 08d728372e More vacuum markup fixes. Alvaro Bruce Momjian 2005-07-30 17:15:35 +00:00
  • 31a2824263 Fix VACUUM sgml markup. Bruce Momjian 2005-07-30 17:03:56 +00:00
  • 2ab9997ec2 Patch to mention cost-based delay in vacuum reference Bruce Momjian 2005-07-30 15:45:49 +00:00
  • 1f54d43075 Add GUC variables to control keep-alive times for idle, interval, and count. Bruce Momjian 2005-07-30 15:17:26 +00:00
  • b2b6548c79 Please find attached diffs for documentation and simple regression tests for the new interval->day changes. I added tests for justify_hours() and justify_days() to interval.sql, as they take interval input and produce interval output. If there's a more appropriate place for them, please let me know. Bruce Momjian 2005-07-30 14:52:04 +00:00
  • 5b0bfec414 Fix compile for no O_SYNC, but introduced with O_DIRECT. Bruce Momjian 2005-07-30 14:15:44 +00:00
  • 90524998c0 Add constraint exclusion items: < > * Allow EXPLAIN to identify tables that were skipped because of > enable_constraint_exclusion > * Allow EXPLAIN output to be more easily processed by scripts 760a763 > * Allow enable_constraint_exclusion to work for UPDATE and DELETE queries Bruce Momjian 2005-07-30 04:05:17 +00:00
  • 326816295e Add: Bruce Momjian 2005-07-30 03:59:23 +00:00
  • f9512130f9 Add: Bruce Momjian 2005-07-30 03:49:17 +00:00
  • 61dc3df71f Update AIX FAQ. Bruce Momjian 2005-07-30 03:39:40 +00:00
  • b6af0dc49e Update AIX FAQ. Bruce Momjian 2005-07-30 03:39:27 +00:00
  • aa8290be99 Add: Bruce Momjian 2005-07-30 03:21:41 +00:00
  • 24df49bd5a Add: Bruce Momjian 2005-07-30 03:18:38 +00:00
  • 43e33c51d4 Clarify: Bruce Momjian 2005-07-30 03:16:08 +00:00
  • 3fae29ef13 Add: Bruce Momjian 2005-07-30 03:15:22 +00:00
  • 1521aef1db SUNOS4_CC -> SUNOS_CC. Bruce Momjian 2005-07-30 03:07:42 +00:00
  • 9ebe05c5bc Add: Bruce Momjian 2005-07-30 02:52:30 +00:00
  • 81f2d972a8 Back-patch fix for NOT-below-a-NOT case. Tom Lane 2005-07-29 21:40:26 +00:00
  • 284e4739ef Fix an oversight I introduced on 2003-12-28: find_nots/push_nots should continue to recurse after eliminating a NOT-below-a-NOT, since the contained subexpression will now be part of the top-level AND/OR structure and so deserves to be simplified. The real-world impact of this is probably minimal, since it'd require at least three levels of NOT to make a difference, but it's still a bug. Also remove some redundant tests for NULL subexpressions. Tom Lane 2005-07-29 21:40:02 +00:00
  • 80f6c35833 Remove contrib version of pg_autovacuum --- superseded by integrated version. Tom Lane 2005-07-29 19:38:22 +00:00
  • 5d5f1a79e6 Clean up a number of autovacuum loose ends. Make the stats collector track shared relations in a separate hashtable, so that operations done from different databases are counted correctly. Add proper support for anti-XID-wraparound vacuuming, even in databases that are never connected to and so have no stats entries. Miscellaneous other bug fixes. Alvaro Herrera, some additional fixes by Tom Lane. Tom Lane 2005-07-29 19:30:09 +00:00
  • 507b758ad9 It appears we need -DSUNOS4_CC for both solaris and sunos4 templates. Per report from Andrew Clark. Tom Lane 2005-07-29 17:00:29 +00:00
  • f387e0615c Add detail: > > If CRC check fails during recovery, remember the page in case > a later CRC for that page properly matches. > Bruce Momjian 2005-07-29 16:05:28 +00:00
  • 85e9a5a014 Move reindexdb from /contrib to /bin. Bruce Momjian 2005-07-29 15:13:11 +00:00
  • 2ea44d1ada Update catversion for dbsize changes. Bruce Momjian 2005-07-29 15:04:22 +00:00
  • 46c5b4bf5d Remove dbsize mention. Bruce Momjian 2005-07-29 15:03:51 +00:00
  • 358a897fa1 Move dbsize functions into the backend. New functions: Bruce Momjian 2005-07-29 14:47:04 +00:00
  • b05801c828 Add mp3 entry to FAQ. Bruce Momjian 2005-07-29 14:05:12 +00:00
  • 16a23597e3 I've had this small patch in my local tree for a while. It documents new commands which may make an SPI call fail. Bruce Momjian 2005-07-29 13:00:03 +00:00
  • 8efe8f7b3e Fix typo. Bruce Momjian 2005-07-29 12:59:15 +00:00
  • c6b1724c67 Update O_DIRECT comment. Bruce Momjian 2005-07-29 03:25:53 +00:00
  • 5b63e7b467 Done: Bruce Momjian 2005-07-29 03:23:00 +00:00
  • c34bb00581 Use O_DIRECT if available when using O_SYNC for wal_sync_method. Bruce Momjian 2005-07-29 03:22:33 +00:00
  • 722f31f786 Thank you for applying patch --- regexp_replace. Bruce Momjian 2005-07-29 03:17:55 +00:00
  • 5d27bf20b4 Make use of new list primitives list_append_unique and list_concat_unique where applicable. Tom Lane 2005-07-28 22:27:02 +00:00
  • ef85f5fabc Add tab completion syntax for PREPARE 2-phase commit syntax. Bruce Momjian 2005-07-28 22:14:30 +00:00
  • a4ca842319 Fix a bunch of bad interactions between partial indexes and the new planning logic for bitmap indexscans. Partial indexes create corner cases in which a scan might be done with no explicit index qual conditions, and the code wasn't handling those cases nicely. Also be a little tenser about eliminating redundant clauses in the generated plan. Per report from Dmitry Karasik. Tom Lane 2005-07-28 20:26:22 +00:00
  • 3535cb827a Code cleanup. Bruce Momjian 2005-07-28 15:30:55 +00:00
  • 95cbfb5c7c Refactor exec_cast_value() and exec_simple_cast_value(): since they do not ever write through the `isnull' parameter, it does not need to be an out parameter. Therefore it can be declared a "bool" rather than a "bool *". Neil Conway 2005-07-28 07:51:13 +00:00
  • 525e83bea3 Mark a static array "const" to move a few bytes from the "data" segment to the "text" segment. It would be possible to mark the elements of the array "const" as well, but this would require multiple API changes and does not seem to be worth the notational inconvenience. Neil Conway 2005-07-28 07:38:33 +00:00
  • 39850313e2 Remove no-longer-needed hack to add pgsleep.c to regress.so. Tom Lane 2005-07-28 04:32:32 +00:00
  • a7f8ae32de Put libpgport into OBJS instead of LIBS, so that it gets included into .def and .exp files automatically on Windows, AIX, and the like. An additional benefit is that changes in libpgport files correctly propagate to force rebuild of the backend executable. This is my reworking of Rocco Altier's idea, and if it breaks anything it's definitely my fault. Tom Lane 2005-07-28 04:31:30 +00:00
  • 06e1d62689 Fix a whole bunch of #includes that were either wrong or redundant. The first rule of portability for us is 'thou shalt have no other gods before c.h', and a whole lot of these files were either not including c.h at all, or including random system headers beforehand, either of which sins can mess up largefile support nicely. Once you have included c.h, there is no need to re-include what it includes, either. Tom Lane 2005-07-28 04:03:14 +00:00
  • 420cfd0366 Remove some long-dead support for libpgtcl with Tk. Tom Lane 2005-07-28 03:15:52 +00:00
  • 37bd2aaf28 Fix breakage introduced in plpgsql CONTINUE patch. Per Kevin McArthur. Tom Lane 2005-07-28 00:26:30 +00:00
  • f124e820a1 Add some missing SGML markup. Neil Conway 2005-07-27 13:42:01 +00:00
  • a4c75ece82 Fix a few macro definitions to ensure that unary minus is enclosed in parentheses. This avoids possible operator precedence problems, and is consistent with most of the macro definitions in the tree. Neil Conway 2005-07-27 12:44:10 +00:00
  • b98b75eb3b Remove MMCacheLock -- it is no longer used. Per ITAGAKI Takahiro. Neil Conway 2005-07-27 08:05:36 +00:00
  • f4bbe13491 Avoid crashing pg_dump if we can't connect to the database server, and no database has been explicitly specified. Per gripe from Omar Kilani. Neil Conway 2005-07-27 05:15:03 +00:00
  • a43bbe34ff Avoid crashing pg_dump if we can't connect to the database server, and no database has been explicitly specified. Per gripe from Omar Kilani. Neil Conway 2005-07-27 05:14:12 +00:00
  • 58d214e51f Basic documentation for ROLEs. The user-manag chapter still needs to be rewritten, but at least the reference pages are reasonably sane. Tom Lane 2005-07-26 23:24:02 +00:00
  • 0c2d7e39f9 Minor correction: cause ALTER ROLE role ROLE rolenames to behave sensibly, even though we don't document it. Tom Lane 2005-07-26 22:37:50 +00:00
  • af019fb9ae Add a role property 'rolinherit' which, when false, denotes that the role doesn't automatically inherit the privileges of roles it is a member of; for such a role, membership in another role can be exploited only by doing explicit SET ROLE. The default inherit setting is TRUE, so by default the behavior doesn't change, but creating a user with NOINHERIT gives closer adherence to our current reading of SQL99. Documentation still lacking, and I think the information schema needs another look. Tom Lane 2005-07-26 16:38:29 +00:00
  • f9fd176461 Add pg_has_role() family of privilege inquiry functions modeled after the existing ones for object privileges. Update the information_schema for roles --- pg_has_role() makes this a whole lot easier, removing the need for most of the explicit joins with pg_user. The views should be a tad faster now, too. Stephen Frost and Tom Lane. Tom Lane 2005-07-26 00:04:19 +00:00
  • e5d6b91220 Add SET ROLE. This is a partial commit of Stephen Frost's recent patch; I'm still working on the has_role function and information_schema changes. Tom Lane 2005-07-25 22:12:34 +00:00