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

Commit Graph

  • 3a3c06f0e0 Adjust SGML so major feature items are all not in a single subparagraph. Bruce Momjian 2005-08-23 11:53:33 +00:00
  • 2a49282477 Update release notes from community comments. Bruce Momjian 2005-08-23 11:32:33 +00:00
  • f9989dae88 Update release notes for 8.1. Bruce Momjian 2005-08-23 02:57:07 +00:00
  • 5f8b22c20d Fix wrong dependency on owner created by ALTER OPCLASS OWNER. Per Alvaro. Tom Lane 2005-08-23 01:41:30 +00:00
  • 2c57528487 Fix SGML sect1-3 alignment in the 8.0.X series. Bruce Momjian 2005-08-23 01:22:53 +00:00
  • 9052537325 Rewrite gather-write patch into something less obviously bolted on after the fact. Fix bug with incorrect test for whether we are at end of logfile segment. Arrange for writes triggered by XLogInsert's is-cache-more-than-half-full test to synchronize with the cache boundaries, so that in long transactions we tend to write alternating halves of the cache rather than randomly chosen portions of it; this saves one more write syscall per cache load. Tom Lane 2005-08-22 23:59:04 +00:00
  • ae94f10397 Update documentation that non-super users can now do ALTER OWNER. Bruce Momjian 2005-08-22 21:32:01 +00:00
  • 9bddb5c8c7 Back out incorrect use of E'' escape addition. Bruce Momjian 2005-08-22 20:25:03 +00:00
  • 83357da684 Cause ALTER INDEX OWNER to generate a warning and do nothing, rather than erroring out as it has done for the last couple weeks. Document that this form is now ignored because indexes can't usefully have different owners from their parent tables. Fix pg_dump to not generate ALTER OWNER commands for indexes. Tom Lane 2005-08-22 19:40:37 +00:00
  • bf1e33d24a Fix unwanted denial of ALTER OWNER rights to superusers. There was some discussion of getting around this by relaxing the checks made for regular users, but I'm disinclined to toy with the security model right now, so just special-case it for superusers where needed. Tom Lane 2005-08-22 17:38:20 +00:00
  • a7f49252d2 enable_constraint_exclusion => constraint_exclusion Bruce Momjian 2005-08-22 17:35:03 +00:00
  • 8ad3965a11 Improve xid wraparound message (the server isn't really shut down, just not accepting queries). Bruce Momjian 2005-08-22 16:59:47 +00:00
  • f88e8070b7 Use an initdb-time test to see if the local version of getaddrinfo() chokes on IPv6 addresses, and comment out the IPv6 entry in the default pg_hba.conf if so. Per Andrew Dunstan. Tom Lane 2005-08-22 16:27:36 +00:00
  • d0096a41fa Fix some inconsistent choices of datatypes in xlog.c. Make buffer indexes all be int, rather than variously int, uint16 and uint32; add some casts where necessary to support large buffer arrays. Tom Lane 2005-08-22 00:41:28 +00:00
  • 6fcaaf29da Minor GUC cleanups: document krb_server_hostname and custom_variable_classes in postgresql.conf.sample, mark custom_variable_classes as SIGHUP not POSTMASTER to agree with the documentation (I can't see a reason it has to be POSTMASTER so I think the docs are right). Tom Lane 2005-08-21 03:39:37 +00:00
  • e22443f405 Add: Bruce Momjian 2005-08-21 01:04:45 +00:00
  • f39f6b500f Seems that the childXids list would be better based on Oid lists than integer lists. Tom Lane 2005-08-20 23:45:08 +00:00
  • 0007490e09 Convert the arithmetic for shared memory size calculation from 'int' to 'Size' (that is, size_t), and install overflow detection checks in it. This allows us to remove the former arbitrary restrictions on NBuffers etc. It won't make any difference in a 32-bit machine, but in a 64-bit machine you could theoretically have terabytes of shared buffers. (How efficiently we could manage 'em remains to be seen.) Similarly, num_temp_buffers, work_mem, and maintenance_work_mem can be set above 2Gb on a 64-bit machine. Original patch from Koichi Suzuki, additional work by moi. Tom Lane 2005-08-20 23:26:37 +00:00
  • 01bc28d48a Invoke mksafefunc and mkunsafefunc with :: decoration. This seems a good idea on consistency grounds, whether or not it really fixes bug #1831. Michael Fuhr Tom Lane 2005-08-20 19:19:31 +00:00
  • 2299ceab1c Invoke mksafefunc and mkunsafefunc with :: decoration. This seems a good idea on consistency grounds, whether or not it really fixes bug #1831. Michael Fuhr Tom Lane 2005-08-20 19:19:21 +00:00
  • ba2fc7eb4b Make GetMultiXactIdMembers() a public function. Tatsuo Ishii 2005-08-20 01:29:27 +00:00
  • bc3991c185 Add BackendXidGetPid(). Tatsuo Ishii 2005-08-20 01:26:36 +00:00
  • f57e3f4cf3 Repair problems with VACUUM destroying t_ctid chains too soon, and with insufficient paranoia in code that follows t_ctid links. (We must do both because even with VACUUM doing it properly, the intermediate state with a dangling t_ctid link is visible concurrently during lazy VACUUM, and could be seen afterwards if either type of VACUUM crashes partway through.) Also try to improve documentation about what's going on. Patch is a bit bulky because passing the XMAX information around required changing the APIs of some low-level heapam.c routines, but it's not conceptually very complicated. Per trouble report from Teodor and subsequent analysis. This needs to be back-patched, but I'll do that after 8.1 beta is out. Tom Lane 2005-08-20 00:40:32 +00:00
  • 97bb6e89be Fix LRU/ALL description mismatch for GUC parameter. Bruce Momjian 2005-08-19 18:58:18 +00:00
  • 0c7786bdfc Consistently align comments in postgresql.conf, move some slightly to the right to stand out. Bruce Momjian 2005-08-19 01:55:18 +00:00
  • 77b4bd3b43 Update some obsolete comments --- code is using t_self now, not t_ctid. Tom Lane 2005-08-18 21:34:20 +00:00
  • dfdf07aab1 Fix up LIMIT/OFFSET planning so that we cope with non-constant LIMIT or OFFSET clauses by using estimate_expression_value(). The main advantage of this is that if the expression is a Param and we have a value for the Param, we'll use that value rather than defaulting. Also, fix some thinkos in the logic for combining LIMIT/OFFSET with an externally supplied tuple fraction (this covers cases like EXISTS(...LIMIT...)). And make sure the results of all this are shown by EXPLAIN. Per a gripe from Merlin Moncure. Tom Lane 2005-08-18 17:51:12 +00:00
  • 96f63aebc8 Add: Bruce Momjian 2005-08-18 14:14:31 +00:00
  • 7be1b3ba74 Add hint for to_char(interval) invalid format specifications. Bruce Momjian 2005-08-18 13:43:08 +00:00
  • a11fe54507 Done: Bruce Momjian 2005-08-18 04:42:41 +00:00
  • e20261128d Fix to_char(interval) to return proper year and century values. Fix to_char(interval) to return large year/month/day/hour values that are larger than possible timestamp values. Prevent to_char(interval) format specifications that make no sense, like Month. Clean up formatting.c code to more logically handle return lengths. Bruce Momjian 2005-08-18 04:37:08 +00:00
  • f8d0a82bf9 Avoid an Assert failure if OuterUserId hasn't been set yet during AbortTransaction. This can happen if a backend's InitPostgres transaction fails (eg, because the given username is invalid). Per Alvaro. Tom Lane 2005-08-17 22:14:34 +00:00
  • 63f850cd4d More formatting.c cleanups. Bruce Momjian 2005-08-17 22:06:53 +00:00
  • 9cd3fb172d Small cleanup. Bruce Momjian 2005-08-17 21:54:50 +00:00
  • 420fc28ac5 Adjust to_char/from_char code to use boolean "is_to_char" rather than integer with flags. Bruce Momjian 2005-08-17 21:47:55 +00:00
  • f468542b10 Remove unnecessary configure test for inet_ntop(), per Andrew Dunstan. Tom Lane 2005-08-17 20:20:22 +00:00
  • cb6a08c9b3 Remove unnecessary configure test for inet_ntop(), per Andrew Dunstan. Tom Lane 2005-08-17 20:20:10 +00:00
  • ff15b3dac5 Fix declaration of dumpacl, per Alvaro. Tom Lane 2005-08-17 19:45:51 +00:00
  • 28d0515d18 Fix FSM warning to mention increasing max_fsm_pages. Was incorrectly max_fsm_relations. Bruce Momjian 2005-08-17 03:50:59 +00:00
  • 26b9dcb640 Minor cleanup. Bruce Momjian 2005-08-17 01:45:20 +00:00
  • e19e382804 Update comments. Bruce Momjian 2005-08-16 19:29:38 +00:00
  • e7fb5563af Improve comment. Bruce Momjian 2005-08-16 19:23:31 +00:00
  • f2ad4cadbf Update pgcvslog comment on how to find branch start time. Bruce Momjian 2005-08-16 17:46:57 +00:00
  • f47f4be902 Remove registration message in all the supported back branches; we had decided to drop it for 7.4, and no one misses it. github/REL7_2_STABLE REL7_2_STABLE Tom Lane 2005-08-16 03:33:39 +00:00
  • d5bd53c2c5 Remove registration message in all the supported back branches; we had decided to drop it for 7.4, and no one misses it. Tom Lane 2005-08-16 03:32:34 +00:00
  • bec2f429af Reject operator names >= NAMEDATALEN characters. These will not work anyway, and in assert-enabled builds you are likely to get an assertion failure. Backpatch as far as 7.3; 7.2 seems not to have the problem. Tom Lane 2005-08-16 00:48:58 +00:00
  • e2e2e15cf8 Reject operator names >= NAMEDATALEN characters. These will not work anyway, and in assert-enabled builds you are likely to get an assertion failure. Backpatch as far as 7.3; 7.2 seems not to have the problem. Tom Lane 2005-08-16 00:48:43 +00:00
  • 96fc1a4f77 Reject operator names >= NAMEDATALEN characters. These will not work anyway, and in assert-enabled builds you are likely to get an assertion failure. Backpatch as far as 7.3; 7.2 seems not to have the problem. Tom Lane 2005-08-16 00:48:29 +00:00
  • 6629bc79f1 Reject operator names >= NAMEDATALEN characters. These will not work anyway, and in assert-enabled builds you are likely to get an assertion failure. Backpatch as far as 7.3; 7.2 seems not to have the problem. Tom Lane 2005-08-16 00:48:12 +00:00
  • 070a3ad76b Rename pg_stat_file columns to be more consistent. Split apart change and creation columns to behave for Unix or Win32. Bruce Momjian 2005-08-15 23:00:14 +00:00
  • 24bd9447ac Clean up recent patch for PL handler functions in pg_catalog: the patch caused PL languages and handlers to be dumped ALWAYS, even in the face of contrary --schema or --table switches. Adopt a slightly saner definition. Tom Lane 2005-08-15 21:50:15 +00:00
  • 9a9328003d Make createlang and droplang proof against weird search_path settings by forcing search_path to be just pg_catalog. Tom Lane 2005-08-15 21:02:26 +00:00
  • ec70ca7954 array_in() and array_recv() need to be more paranoid about validating their OID parameter. It was possible to crash the backend with select array_in('{123}',0,0); because that would bypass the needed step of initializing the workspace. These seem to be the only two places with a problem, though (record_in and record_recv don't have the issue, and the other array functions aren't depending on user-supplied input). Back-patch as far as 7.4; 7.3 does not have the bug. Tom Lane 2005-08-15 19:41:06 +00:00
  • ab648632eb array_in() and array_recv() need to be more paranoid about validating their OID parameter. It was possible to crash the backend with select array_in('{123}',0,0); because that would bypass the needed step of initializing the workspace. These seem to be the only two places with a problem, though (record_in and record_recv don't have the issue, and the other array functions aren't depending on user-supplied input). Back-patch as far as 7.4; 7.3 does not have the bug. Tom Lane 2005-08-15 19:40:43 +00:00
  • 866ffc2fe3 array_in() and array_recv() need to be more paranoid about validating their OID parameter. It was possible to crash the backend with select array_in('{123}',0,0); because that would bypass the needed step of initializing the workspace. These seem to be the only two places with a problem, though (record_in and record_recv don't have the issue, and the other array functions aren't depending on user-supplied input). Back-patch as far as 7.4; 7.3 does not have the bug. Tom Lane 2005-08-15 19:40:20 +00:00
  • f739566069 int_array_enum function should be using fcinfo->flinfo->fn_extra for working state, not fcinfo->context. Silly oversight on my part in last go-round of fixes. Tom Lane 2005-08-15 19:05:58 +00:00
  • 6f0da9545a int_array_enum function should be using fcinfo->flinfo->fn_extra for working state, not fcinfo->context. Silly oversight on my part in last go-round of fixes. Tom Lane 2005-08-15 19:05:43 +00:00
  • 497f11845c int_array_enum function should be using fcinfo->flinfo->fn_extra for working state, not fcinfo->context. Silly oversight on my part in last go-round of fixes. Tom Lane 2005-08-15 19:05:30 +00:00
  • e6a30121be int_array_enum function should be using fcinfo->flinfo->fn_extra for working state, not fcinfo->context. Silly oversight on my part in last go-round of fixes. Tom Lane 2005-08-15 19:05:16 +00:00
  • 87808aef05 Allow the pgstat views to show toast tables as well as regular tables (the stats system has always collected this info, but the views were filtering it out). Modify autovacuum so that over-threshold activity in a toast table can trigger a VACUUM of the parent table, even if the parent didn't appear to need vacuuming itself. Per discussion a month or so back about "short, wide tables". Tom Lane 2005-08-15 16:25:19 +00:00
  • 2498d8296e Clean up some stray remaining references to pg_shadow, pg_user, pg_group. Tom Lane 2005-08-15 02:40:36 +00:00
  • f590ed12f6 Change pg_dump to use pg_roles instead of pg_user on 8.1 and up, so that it will correctly dump owners of objects owned by non-login roles. Tom Lane 2005-08-15 02:36:30 +00:00
  • 840b7f5205 Update administrator's guide chapters for ROLEs patch. Tom Lane 2005-08-14 23:35:38 +00:00
  • bf86bacb2c Change standard_compliant_strings to standard_conforming_strings. Peter Eisentraut 2005-08-14 22:19:50 +00:00
  • 8ae0d476a9 Update the createuser utility for the ROLEs world. Alvaro Herrera Tom Lane 2005-08-14 20:16:03 +00:00
  • e36de18191 Fix psql's \d commands to use pg_roles instead of pg_user, so that they don't miss owners that are NOLOGIN. Tom Lane 2005-08-14 19:20:45 +00:00
  • 84ccf7212c Fix up tab completion for ROLEs and add some more completion logic for other stuff; change \du and \dg to be role-aware (Stefan Kaltenbrunner). Also make tab completion fetch the list of GUC variables from pg_settings instead of having a hard-wired copy of the list (Tom Lane). Tom Lane 2005-08-14 18:49:30 +00:00
  • f60d176a5e Tweak catalog cache management algorithms to reduce cost of SearchCatCacheList and ReleaseCatCacheList. Previously, we incremented and decremented the refcounts of list member tuples along with the list itself, but that's unnecessary, and very expensive when the list is big. It's cheaper to change only the list refcount. When we are considering deleting a cache entry, we have to check not only its own refcount but its parent list's ... but it's easy to arrange the code so that this check is not made in any commonly-used paths, so the cost is really nil. The bigger gain though is to refrain from DLMoveToFront'ing each individual member tuple each time the list is referenced. To keep some semblance of fair space management, lists are just marked as used or not since the last cache cleanout search, and we do a MoveToFront pass only when about to run a cleanout. In combination, these changes reduce the costs of SearchCatCacheList and ReleaseCatCacheList from about 4.5% of pgbench runtime to under 1%, according to my gprof results. Tom Lane 2005-08-13 22:18:07 +00:00
  • 2af9a44fa9 Make pg_stat_file() use OUT parameters so that the user doesn't have to remember the output parameter set for himself. It's a bit of a kluge but fixing array_in to work in bootstrap mode looks worse. I removed the separate pg_file_length() function, as it no longer has any real notational advantage --- you can write (pg_stat_file(...)).length. Tom Lane 2005-08-13 19:02:34 +00:00
  • f547909db7 Remove API file. Bruce Momjian 2005-08-13 15:27:41 +00:00
  • 03be45fbe6 CREATE TABLE has optional column names, so change {} to []. Bruce Momjian 2005-08-13 02:48:18 +00:00
  • 87688ddf87 The large one adds support for RSA keys and reorganizes the pubkey functions a bit. The actual RSA-specific code there is tiny, most of the patch consists of reorg of the pubkey code, as lots of it was written as elgamal-only. Bruce Momjian 2005-08-13 02:06:21 +00:00
  • abecf1afc2 Add documentation: Bruce Momjian 2005-08-13 01:55:41 +00:00
  • f810cfb291 Disable strtoul() ERANGE check on Win32, because it isn't thread safe, and it isn't really required. Bruce Momjian 2005-08-13 01:34:30 +00:00
  • 27639809d2 Reverse out Assert addition. Bruce Momjian 2005-08-12 23:13:54 +00:00
  • 59c016aa9f Pass the type OID as the typioparam for all non-array types, rather than only composite types as we did in 8.0. Per discussion with Martijn van Oosterhout. Tom Lane 2005-08-12 21:49:47 +00:00
  • bb2ffe9acf Back out plpython makefile change. Bruce Momjian 2005-08-12 21:44:51 +00:00
  • fab177e64f Improve documention on loading large data sets into plperl. Bruce Momjian 2005-08-12 21:42:53 +00:00
  • 0c9f00506b This patch fixes the event type used to log output from the stderr-in-service or output-from-syslogger-in-service code. Previously everything was flagged as ERRORs there, which caused all instances to log "LOG: logger shutting down" as error... Bruce Momjian 2005-08-12 21:38:00 +00:00
  • ed63689b43 This patch fixes the event type used to log output from the stderr-in-service or output-from-syslogger-in-service code. Previously everything was flagged as ERRORs there, which caused all instances to log "LOG: logger shutting down" as error... Bruce Momjian 2005-08-12 21:36:59 +00:00
  • 65790b9e01 Un-break plperl for non-set case. Tom Lane 2005-08-12 21:26:32 +00:00
  • 18b15c3946 [ backpatched to 8.0.X.] Bruce Momjian 2005-08-12 21:23:18 +00:00
  • 7d781c62b1 [ backpatched to 8.0.X.] Bruce Momjian 2005-08-12 21:23:10 +00:00
  • 479a8fd69e > Gavin Sherry <swm@linuxworld.com.au> writes: > > I ran across this yesterday on HEAD: > > > template1=# grant select on foo, foo to swm; > > ERROR: tuple already updated by self > > Seems to fail similarly in every version back to 7.2; probably further, > but that's all I have running at the moment. > > > We could do away with the error by producing a unique list of object names > > -- but that would impose an extra cost on the common case. > > CommandCounterIncrement in the GRANT loop would be easier, likely. > I'm having a hard time getting excited about it though... Bruce Momjian 2005-08-12 21:20:24 +00:00
  • abc8a0a0fe More rsi assignment line too. Bruce Momjian 2005-08-12 21:09:34 +00:00
  • 0d1ebe0194 Fix up canonicalize_path to do the right thing in all cases (I think ... this was harder than it seemed at first glance). Also push code for checking for ".." in file names into path.c where it belongs. Tom Lane 2005-08-12 21:07:53 +00:00
  • 9cc5caea6c Fix this: Bruce Momjian 2005-08-12 21:02:25 +00:00
  • 2c07d6bfa5 Cleanups for FreeBSD linking (PIC) and plpython compiles. Bruce Momjian 2005-08-12 20:57:11 +00:00
  • 60672b59b8 > The attached patch moves a plperl sanity check into the correct > position. Performing the check in the existing position allows the call > to go through to perl first, possibly resulting in a SEGV. Bruce Momjian 2005-08-12 20:48:03 +00:00
  • 88a2b5c10f No server version of snprintf needed, so remove Makefile rule. Bruce Momjian 2005-08-12 19:45:14 +00:00
  • 3b0ee862d6 Reverse out changes to canonicalize_path(), per suggestion from Tom. Bruce Momjian 2005-08-12 19:43:32 +00:00
  • 35379e9079 Modify canonicalize_path() so if we would return a trailing "..", throw an error instead. Bruce Momjian 2005-08-12 19:42:45 +00:00
  • a43ea120bf Code & docs review for server instrumentation patch. File timestamps should surely be timestamptz not timestamp; fix some but not all of the holes in check_and_make_absolute(); other minor cleanup. Also put in the missed catversion bump. Tom Lane 2005-08-12 18:23:56 +00:00
  • cb29f669b0 Add markup for GUC mention in docs. Bruce Momjian 2005-08-12 15:57:48 +00:00
  • 6ea05c16a4 Change a couple of "can't happen" error messages to be a shade more verbose when they do happen. The "left link changed unexpectedly" one in particular has been seen more than once in the field. Tom Lane 2005-08-12 14:34:14 +00:00
  • 3ae7e4a33b Remove BufferBlockPointers array in favor of a base + (bufnum) * BLCKSZ computation. On modern machines this is as fast if not faster, and we don't have to clog the CPU's L2 cache with a tens-of-KB pointer array. If we ever decide to adopt a more dynamic allocation method for shared buffers, we'll probably have to revert this patch, but in the meantime we might as well save a few bytes and nanoseconds. Per Qingqing Zhou. Tom Lane 2005-08-12 05:05:51 +00:00
  • b609695b7a Add files to do read I/O on the cluster directory: Bruce Momjian 2005-08-12 03:25:13 +00:00
  • d95886e734 Update comments. Bruce Momjian 2005-08-12 03:07:45 +00:00
  • 6effc19d9c Document why we only handle trailing "..". Bruce Momjian 2005-08-12 02:48:37 +00:00
  • 721e53785d Solve the problem of OID collisions by probing for duplicate OIDs whenever we generate a new OID. This prevents occasional duplicate-OID errors that can otherwise occur once the OID counter has wrapped around. Duplicate relfilenode values are also checked for when creating new physical files. Per my recent proposal. Tom Lane 2005-08-12 01:36:05 +00:00