cc88ed6 | PostgreSQL Daemon | 24 August 2005, 21:32:41 UTC | fix up a few references to 8.1devel -> 8.1beta1 | 24 August 2005, 21:32:41 UTC |
009e8d4 | Tom Lane | 24 August 2005, 20:49:35 UTC | Remove statement that to_char(interval) is deprecated; seems we are going to keep it after all. | 24 August 2005, 20:49:35 UTC |
c4bf582 | Bruce Momjian | 24 August 2005, 20:34:05 UTC | Remove sentence: < Logically, a reload should set the same values as a < server restart. | 24 August 2005, 20:34:05 UTC |
41bb3cb | Tom Lane | 24 August 2005, 20:20:38 UTC | Back off allow_nonpic_in_shlib for FreeBSD builds: only set it on i386. This might be overly conservative, but we know it does not work on amd64. Per buildfarm results. | 24 August 2005, 20:20:38 UTC |
75f633b | Bruce Momjian | 24 August 2005, 19:43:26 UTC | Update: < Currently, if a variable is commented out, it keeps the < previous uncommented value until a server restarted. > Currently, if a variable is commented out, it keeps the > previous uncommented value until a server restarted. > Logically, a reload should set the same values as a > server restart. | 24 August 2005, 19:43:26 UTC |
03417ac | Bruce Momjian | 24 August 2005, 19:41:33 UTC | Run spellchecker over release notes. | 24 August 2005, 19:41:33 UTC |
63a6722 | Bruce Momjian | 24 August 2005, 19:34:34 UTC | More beta1 cleanup. | 24 August 2005, 19:34:34 UTC |
83ba41f | Tom Lane | 24 August 2005, 19:34:12 UTC | Fix SHOW and RESET grammar to accept custom variable names. | 24 August 2005, 19:34:12 UTC |
5d14b0d | Bruce Momjian | 24 August 2005, 19:31:46 UTC | Suggest markup items for the future. | 24 August 2005, 19:31:46 UTC |
06f4a53 | Tom Lane | 24 August 2005, 19:24:54 UTC | Make the plperl regression tests pass in 'use_strict' mode, by adding 'my' where appropriate. Michael Fuhr | 24 August 2005, 19:24:54 UTC |
9a4fd8f | Bruce Momjian | 24 August 2005, 19:24:20 UTC | Update release notes for beta1. | 24 August 2005, 19:24:20 UTC |
9005b75 | Tom Lane | 24 August 2005, 19:16:49 UTC | Mention BEGIN { strict->import(); } as a substitute for 'use strict' in plperl functions. | 24 August 2005, 19:16:49 UTC |
6f64cf5 | Tom Lane | 24 August 2005, 19:06:28 UTC | Get rid of inappropriate use of croak(). Per report from Michael Fuhr. | 24 August 2005, 19:06:28 UTC |
95f202c | Tom Lane | 24 August 2005, 18:56:07 UTC | Adjust description of use_strict parameter. Some other minor editorial cleanup. | 24 August 2005, 18:56:07 UTC |
f21e262 | Tom Lane | 24 August 2005, 18:26:36 UTC | Fix broken markup. | 24 August 2005, 18:26:36 UTC |
a626045 | Tom Lane | 24 August 2005, 18:16:58 UTC | Fix up plperl 'use_strict' so that it can be enabled or disabled on the fly. Fix problem with incompletely duplicated setup code. Andrew Dunstan, from an idea of Michael Fuhr's. | 24 August 2005, 18:16:58 UTC |
a06d98b | Bruce Momjian | 24 August 2005, 17:56:20 UTC | Additem: > * Add sleep() function, remove from regress.c | 24 August 2005, 17:56:20 UTC |
767a902 | Tom Lane | 24 August 2005, 17:50:00 UTC | Add small hack to support use of Unicode-based locales on WIN32. This is not adequately tested yet, but let's get it into beta1 so it can be tested. Magnus Hagander and Tom Lane. | 24 August 2005, 17:50:00 UTC |
a0a0bc0 | Tom Lane | 24 August 2005, 17:38:35 UTC | Fix ExecBRDeleteTriggers so that deletion is not suppressed when delete triggers exist but are all disabled. Problem noted by Gavin Sherry in original discussion of enable/disable trigger patch, but was never addressed. | 24 August 2005, 17:38:35 UTC |
130b2dd | Tom Lane | 24 August 2005, 17:24:19 UTC | Add documentation for ALTER TABLE ENABLE/DISABLE TRIGGER. | 24 August 2005, 17:24:19 UTC |
249a720 | Bruce Momjian | 24 August 2005, 16:49:39 UTC | Add: > o Add sleep() to PL/PgSQL | 24 August 2005, 16:49:39 UTC |
db8275d | Bruce Momjian | 24 August 2005, 16:47:00 UTC | Add to release notes. | 24 August 2005, 16:47:00 UTC |
2a733db | Tom Lane | 24 August 2005, 15:35:01 UTC | Fix broken markup. | 24 August 2005, 15:35:01 UTC |
e4bffda | Bruce Momjian | 24 August 2005, 14:35:26 UTC | Update release notes. | 24 August 2005, 14:35:26 UTC |
c864c3b | Bruce Momjian | 24 August 2005, 14:24:19 UTC | Fix typo. | 24 August 2005, 14:24:19 UTC |
ee2b61e | Bruce Momjian | 24 August 2005, 14:05:37 UTC | Mark "easy" items. Jim C. Nasby | 24 August 2005, 14:05:37 UTC |
6ca102d | Bruce Momjian | 24 August 2005, 14:00:36 UTC | Update: < o Do VACUUM FULL if table is nearly empty? > o Suggest VACUUM FULL if a table is nearly empty | 24 August 2005, 14:00:36 UTC |
69e4e57 | Bruce Momjian | 24 August 2005, 13:57:27 UTC | Add explaination: > > Currently, if a variable is commented out, it keeps the > previous uncommented value until a server restarted. > | 24 August 2005, 13:57:27 UTC |
f417ebf | Michael Meskes | 24 August 2005, 10:34:19 UTC | - Check for NULL before checking whether argument is an array. - Remove stary character from string quoting. - Fixed check to report missing varchar pointer implementation. | 24 August 2005, 10:34:19 UTC |
9012bb6 | Bruce Momjian | 24 August 2005, 03:47:11 UTC | Remove periods on bullet items. | 24 August 2005, 03:47:11 UTC |
2b21521 | Bruce Momjian | 23 August 2005, 23:51:18 UTC | Mark item as complete, add another: < * Allow triggers to be disabled [trigger] > * -Allow triggers to be disabled [trigger] > * Allow triggers to be disabled in only the current session. < Currently the only way to disable triggers is to modify the system < tables. > This is currently possible by starting a multi-statement transaction, > modifying the system tables, performing the desired SQL, restoring the > system tables, and committing the transaction. ALTER TABLE ... > TRIGGER requires a table lock so it is not idea for this usage. | 23 August 2005, 23:51:18 UTC |
5279f68 | Bruce Momjian | 23 August 2005, 23:31:52 UTC | Release note cleanups. | 23 August 2005, 23:31:52 UTC |
188c7c8 | Tom Lane | 23 August 2005, 22:40:47 UTC | Add ALTER TABLE ENABLE/DISABLE TRIGGER commands. Change pg_dump to use these instead of its previous hack of changing pg_class.reltriggers. Documentation is lacking, will add that later. Patch by Satoshi Nagayasu, review and some extra work by Tom Lane. | 23 August 2005, 22:40:47 UTC |
d086da4 | Bruce Momjian | 23 August 2005, 21:25:56 UTC | Update pgcrypto items. | 23 August 2005, 21:25:56 UTC |
26ca0d6 | Bruce Momjian | 23 August 2005, 21:17:15 UTC | Update ALTER OWNER description. | 23 August 2005, 21:17:15 UTC |
9cf18ee | Bruce Momjian | 23 August 2005, 21:11:22 UTC | Add new file for win32 threading. | 23 August 2005, 21:11:22 UTC |
43bf3a6 | Bruce Momjian | 23 August 2005, 21:02:05 UTC | The attached patch updates the thread test program to run stand-alone on Windows. The test itself is bypassed in configure as discussed, and libpq has been updated appropriately to allow it to build in thread-safe mode. Dave Page | 23 August 2005, 21:02:05 UTC |
f2cec87 | Bruce Momjian | 23 August 2005, 20:51:27 UTC | Fix function name. | 23 August 2005, 20:51:27 UTC |
e331404 | Tom Lane | 23 August 2005, 20:49:47 UTC | Clean up some very old and crufty code for TID scan planning. Not much functional difference really, but make use of stuff added to the planner since this code was touched last. | 23 August 2005, 20:49:47 UTC |
a970a8c | Bruce Momjian | 23 August 2005, 20:48:47 UTC | Back out incorrect commit. | 23 August 2005, 20:48:47 UTC |
eef7e30 | Bruce Momjian | 23 August 2005, 20:45:11 UTC | Fix function name. | 23 August 2005, 20:45:11 UTC |
bc1a3cd | Bruce Momjian | 23 August 2005, 19:44:58 UTC | Update release notes. | 23 August 2005, 19:44:58 UTC |
31ef058 | Bruce Momjian | 23 August 2005, 14:54:06 UTC | More release note updates. | 23 August 2005, 14:54:06 UTC |
0f455b3 | Tom Lane | 23 August 2005, 13:31:11 UTC | Fix broken lrand48() implementation, per Merlin Moncure. | 23 August 2005, 13:31:11 UTC |
e889ff4 | Bruce Momjian | 23 August 2005, 12:47:30 UTC | Release note updates. | 23 August 2005, 12:47:30 UTC |
53a04e0 | Bruce Momjian | 23 August 2005, 12:46:35 UTC | Release note updates. | 23 August 2005, 12:46:35 UTC |
a5e1ccc | Bruce Momjian | 23 August 2005, 12:14:33 UTC | Avoid bullets in subparagraphs. | 23 August 2005, 12:14:33 UTC |
9d615a9 | Bruce Momjian | 23 August 2005, 11:59:09 UTC | Fix markup for para. | 23 August 2005, 11:59:09 UTC |
3a3c06f | Bruce Momjian | 23 August 2005, 11:53:33 UTC | Adjust SGML so major feature items are all not in a single subparagraph. | 23 August 2005, 11:53:33 UTC |
2a49282 | Bruce Momjian | 23 August 2005, 11:32:33 UTC | Update release notes from community comments. | 23 August 2005, 11:32:33 UTC |
f9989da | Bruce Momjian | 23 August 2005, 02:57:07 UTC | Update release notes for 8.1. | 23 August 2005, 02:57:07 UTC |
5f8b22c | Tom Lane | 23 August 2005, 01:41:30 UTC | Fix wrong dependency on owner created by ALTER OPCLASS OWNER. Per Alvaro. | 23 August 2005, 01:41:30 UTC |
2c57528 | Bruce Momjian | 23 August 2005, 01:22:53 UTC | Fix SGML sect1-3 alignment in the 8.0.X series. | 23 August 2005, 01:22:53 UTC |
9052537 | Tom Lane | 22 August 2005, 23:59:04 UTC | 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. | 22 August 2005, 23:59:04 UTC |
ae94f10 | Bruce Momjian | 22 August 2005, 21:32:01 UTC | Update documentation that non-super users can now do ALTER OWNER. | 22 August 2005, 21:32:01 UTC |
9bddb5c | Bruce Momjian | 22 August 2005, 20:25:03 UTC | Back out incorrect use of E'' escape addition. | 22 August 2005, 20:25:03 UTC |
83357da | Tom Lane | 22 August 2005, 19:40:37 UTC | 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. | 22 August 2005, 19:40:37 UTC |
bf1e33d | Tom Lane | 22 August 2005, 17:38:20 UTC | 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. | 22 August 2005, 17:38:20 UTC |
a7f4925 | Bruce Momjian | 22 August 2005, 17:35:03 UTC | enable_constraint_exclusion => constraint_exclusion Also improve wording. | 22 August 2005, 17:35:03 UTC |
8ad3965 | Bruce Momjian | 22 August 2005, 16:59:47 UTC | Improve xid wraparound message (the server isn't really shut down, just not accepting queries). errmsg("database is not accepting queries to avoid wraparound data loss in database \"%s\"", errhint("Stop the postmaster and use a standalone backend to VACUUM database \"%s\".", | 22 August 2005, 16:59:47 UTC |
f88e807 | Tom Lane | 22 August 2005, 16:27:36 UTC | 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. | 22 August 2005, 16:27:36 UTC |
d0096a4 | Tom Lane | 22 August 2005, 00:41:28 UTC | 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. | 22 August 2005, 00:41:28 UTC |
6fcaaf2 | Tom Lane | 21 August 2005, 03:39:37 UTC | 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). | 21 August 2005, 03:39:37 UTC |
e22443f | Bruce Momjian | 21 August 2005, 01:04:45 UTC | Add: > * Fix problems with wrong runtime encoding conversion for NLS message files | 21 August 2005, 01:04:45 UTC |
f39f6b5 | Tom Lane | 20 August 2005, 23:45:08 UTC | Seems that the childXids list would be better based on Oid lists than integer lists. | 20 August 2005, 23:45:08 UTC |
0007490 | Tom Lane | 20 August 2005, 23:26:37 UTC | 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. | 20 August 2005, 23:26:37 UTC |
2299cea | Tom Lane | 20 August 2005, 19:19:21 UTC | Invoke mksafefunc and mkunsafefunc with :: decoration. This seems a good idea on consistency grounds, whether or not it really fixes bug #1831. Michael Fuhr | 20 August 2005, 19:19:21 UTC |
ba2fc7e | Tatsuo Ishii | 20 August 2005, 01:29:27 UTC | Make GetMultiXactIdMembers() a public function. | 20 August 2005, 01:29:27 UTC |
bc3991c | Tatsuo Ishii | 20 August 2005, 01:26:36 UTC | Add BackendXidGetPid(). | 20 August 2005, 01:26:36 UTC |
f57e3f4 | Tom Lane | 20 August 2005, 00:40:32 UTC | 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. | 20 August 2005, 00:40:32 UTC |
97bb6e8 | Bruce Momjian | 19 August 2005, 18:58:18 UTC | Fix LRU/ALL description mismatch for GUC parameter. | 19 August 2005, 18:58:18 UTC |
0c7786b | Bruce Momjian | 19 August 2005, 01:55:18 UTC | Consistently align comments in postgresql.conf, move some slightly to the right to stand out. | 19 August 2005, 01:55:18 UTC |
77b4bd3 | Tom Lane | 18 August 2005, 21:34:20 UTC | Update some obsolete comments --- code is using t_self now, not t_ctid. | 18 August 2005, 21:34:20 UTC |
dfdf07a | Tom Lane | 18 August 2005, 17:51:12 UTC | 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. | 18 August 2005, 17:51:12 UTC |
96f63ae | Bruce Momjian | 18 August 2005, 14:14:31 UTC | Add: > o Remove unnecessary abstractions in pg_dump source code | 18 August 2005, 14:14:31 UTC |
7be1b3b | Bruce Momjian | 18 August 2005, 13:43:08 UTC | Add hint for to_char(interval) invalid format specifications. | 18 August 2005, 13:43:08 UTC |
a11fe54 | Bruce Momjian | 18 August 2005, 04:42:41 UTC | Done: > * -Prevent to_char() on interval from returning meaningless values | 18 August 2005, 04:42:41 UTC |
e202611 | Bruce Momjian | 18 August 2005, 04:37:08 UTC | 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. | 18 August 2005, 04:37:08 UTC |
f8d0a82 | Tom Lane | 17 August 2005, 22:14:34 UTC | 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. | 17 August 2005, 22:14:34 UTC |
63f850c | Bruce Momjian | 17 August 2005, 22:06:53 UTC | More formatting.c cleanups. | 17 August 2005, 22:06:53 UTC |
9cd3fb1 | Bruce Momjian | 17 August 2005, 21:54:50 UTC | Small cleanup. | 17 August 2005, 21:54:50 UTC |
420fc28 | Bruce Momjian | 17 August 2005, 21:47:55 UTC | Adjust to_char/from_char code to use boolean "is_to_char" rather than integer with flags. | 17 August 2005, 21:47:55 UTC |
cb6a08c | Tom Lane | 17 August 2005, 20:20:10 UTC | Remove unnecessary configure test for inet_ntop(), per Andrew Dunstan. | 17 August 2005, 20:20:10 UTC |
ff15b3d | Tom Lane | 17 August 2005, 19:45:51 UTC | Fix declaration of dumpacl, per Alvaro. | 17 August 2005, 19:45:51 UTC |
28d0515 | Bruce Momjian | 17 August 2005, 03:50:59 UTC | Fix FSM warning to mention increasing max_fsm_pages. Was incorrectly max_fsm_relations. | 17 August 2005, 03:50:59 UTC |
26b9dcb | Bruce Momjian | 17 August 2005, 01:45:20 UTC | Minor cleanup. | 17 August 2005, 01:45:20 UTC |
e19e382 | Bruce Momjian | 16 August 2005, 19:29:38 UTC | Update comments. | 16 August 2005, 19:29:38 UTC |
e7fb556 | Bruce Momjian | 16 August 2005, 19:23:31 UTC | Improve comment. | 16 August 2005, 19:23:31 UTC |
f2ad4ca | Bruce Momjian | 16 August 2005, 17:46:57 UTC | Update pgcvslog comment on how to find branch start time. Run autoconf/autoheader in case someone forgot in the past. | 16 August 2005, 17:46:57 UTC |
6629bc7 | Tom Lane | 16 August 2005, 00:48:12 UTC | 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. | 16 August 2005, 00:48:12 UTC |
070a3ad | Bruce Momjian | 15 August 2005, 23:00:14 UTC | Rename pg_stat_file columns to be more consistent. Split apart change and creation columns to behave for Unix or Win32. | 15 August 2005, 23:00:14 UTC |
24bd944 | Tom Lane | 15 August 2005, 21:50:15 UTC | 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. | 15 August 2005, 21:50:15 UTC |
9a93280 | Tom Lane | 15 August 2005, 21:02:26 UTC | Make createlang and droplang proof against weird search_path settings by forcing search_path to be just pg_catalog. | 15 August 2005, 21:02:26 UTC |
866ffc2 | Tom Lane | 15 August 2005, 19:40:20 UTC | 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. | 15 August 2005, 19:40:20 UTC |
e6a3012 | Tom Lane | 15 August 2005, 19:05:16 UTC | 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. | 15 August 2005, 19:05:16 UTC |
87808ae | Tom Lane | 15 August 2005, 16:25:19 UTC | 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". | 15 August 2005, 16:25:19 UTC |
2498d82 | Tom Lane | 15 August 2005, 02:40:36 UTC | Clean up some stray remaining references to pg_shadow, pg_user, pg_group. | 15 August 2005, 02:40:36 UTC |
f590ed1 | Tom Lane | 15 August 2005, 02:36:30 UTC | 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. | 15 August 2005, 02:36:30 UTC |
840b7f5 | Tom Lane | 14 August 2005, 23:35:38 UTC | Update administrator's guide chapters for ROLEs patch. | 14 August 2005, 23:35:38 UTC |
bf86bac | Peter Eisentraut | 14 August 2005, 22:19:50 UTC | Change standard_compliant_strings to standard_conforming_strings. | 14 August 2005, 22:19:50 UTC |