| da83ecb | PostgreSQL Daemon | 14 January 2002, 13:15:28 UTC | tag as beta 5 for *hopefully* a very very short beta cycle on this one? | 14 January 2002, 13:15:28 UTC |
| 1b5d8e6 | Bruce Momjian | 13 January 2002, 17:52:00 UTC | Fix recreation of sequence files for 7.2 also because of XID change from beta4 to beta5. | 13 January 2002, 17:52:00 UTC |
| 7138a1e | Michael Meskes | 13 January 2002, 08:52:09 UTC | - Fixed variable handling for struct members. - Removed check for array input. An attribut might store the complete array. | 13 January 2002, 08:52:09 UTC |
| 4b20cc1 | Bruce Momjian | 13 January 2002, 05:36:42 UTC | Now works for 7.1 databases. | 13 January 2002, 05:36:42 UTC |
| 11b3e56 | Bruce Momjian | 13 January 2002, 04:55:44 UTC | Now tested on 7.2->7.2 migration; still disabled. Need 7.1 testing now. | 13 January 2002, 04:55:44 UTC |
| 9be030f | Bruce Momjian | 13 January 2002, 01:22:27 UTC | Keep it disabled. | 13 January 2002, 01:22:27 UTC |
| 5b2ebe9 | Bruce Momjian | 13 January 2002, 01:13:59 UTC | Wow, it actually worked for the regression database. More testing needed. | 13 January 2002, 01:13:59 UTC |
| f5bbcfb | Tom Lane | 12 January 2002, 18:09:04 UTC | Bump catversion to ensure people apply recent timestamp and sequence fixes. | 12 January 2002, 18:09:04 UTC |
| 47503f9 | Tom Lane | 12 January 2002, 18:07:34 UTC | Update horology expected results (this variant extrapolated by yours truly; should be verified by someone with an appropriate system). | 12 January 2002, 18:07:34 UTC |
| f171bd5 | Tom Lane | 12 January 2002, 18:06:53 UTC | Update horology expected results (this variant verified on HPUX). | 12 January 2002, 18:06:53 UTC |
| 192061e | Thomas G. Lockhart | 12 January 2002, 04:38:38 UTC | Repair bugs in declarations of routines to add timestamptz and interval. Thanks to Bruce for spotting it and Tom Lane for diagnosing it. Since horology test output is changing anyway, add some date/time input tests to horology.sql. Some of these should move to the tests for the individual data types, and we perhaps should add an entire new test for "timezone" to allow manipulating the current time zone without risking damage to the results of other tests. | 12 January 2002, 04:38:38 UTC |
| 0e1a507 | Tom Lane | 11 January 2002, 23:21:55 UTC | Fix pg_dump to read-lock all tables to be dumped as soon as it's read their names from pg_class. This considerably reduces the window wherein someone could DROP or ALTER a table that pg_dump is intending to dump. Not a perfect solution, but definitely an improvement. Per complaints from Marc Fournier; patch by Brent Verner with some kibitzing by Tom Lane. | 11 January 2002, 23:21:55 UTC |
| 5c2d36c | Tom Lane | 11 January 2002, 21:27:13 UTC | Code review for latest changes. | 11 January 2002, 21:27:13 UTC |
| c6fdf8b | Bruce Momjian | 11 January 2002, 20:48:47 UTC | More man pages improvements; also needed to test sgml build. | 11 January 2002, 20:48:47 UTC |
| 3bb7755 | Bruce Momjian | 11 January 2002, 20:34:14 UTC | Sync up. | 11 January 2002, 20:34:14 UTC |
| 5ab0ad5 | Tom Lane | 11 January 2002, 20:07:03 UTC | VACUUM must make sure that a HEAP_MARKED_FOR_UPDATE tuple gets marked as either HEAP_XMAX_COMMITTED or HEAP_XMAX_INVALID once the updating transaction is gone. Otherwise some other transaction may come along and try to test the commit status of t_xmax later --- which could be after VACUUM has recycled the CLOG status for that xact. Bug introduced in post-beta4 bug fix. | 11 January 2002, 20:07:03 UTC |
| eb5e8ba | Tom Lane | 11 January 2002, 18:16:04 UTC | Fix sequence creation to set the t_xmin of a sequence's tuple to FrozenTransactionId, not the XID of the creating transaction. Without this it's possible for a reference to a long-gone CLOG record to occur, per Christian Meunier's bug report of 10-Jan-02. Worse, the sequence tuple would become invisible to SELECTs after 2 billion transactions. Since the fix is applied during sequence creation it does not help existing databases, unless you drop and recreate every sequence. However, we intend to force initdb for 7.2RC1 anyway, to fix a pg_proc error, so I see no need to do more for this problem. | 11 January 2002, 18:16:04 UTC |
| 051a4f2 | Michael Meskes | 11 January 2002, 14:43:11 UTC | Added Christof's fixes. | 11 January 2002, 14:43:11 UTC |
| 4e37786 | Bruce Momjian | 11 January 2002, 06:48:41 UTC | More testing, more cleanups. | 11 January 2002, 06:48:41 UTC |
| 37c9346 | Bruce Momjian | 11 January 2002, 06:33:01 UTC | pg_resetxlog specifies log location in hex; more pg_upgrade testing improvments. | 11 January 2002, 06:33:01 UTC |
| ba3231a | Bruce Momjian | 11 January 2002, 06:08:02 UTC | More cleanups. | 11 January 2002, 06:08:02 UTC |
| d91b445 | Hiroshi Inoue | 11 January 2002, 06:01:47 UTC | *** empty log message *** | 11 January 2002, 06:01:47 UTC |
| 3b3b730 | Bruce Momjian | 11 January 2002, 05:54:59 UTC | More updates for int8 sequence restoration. Old dump file not required anymore. | 11 January 2002, 05:54:59 UTC |
| 6bd45e5 | Bruce Momjian | 11 January 2002, 04:39:19 UTC | Handle int4-int8 sequence migration without full data dump. | 11 January 2002, 04:39:19 UTC |
| f43b5de | Hiroshi Inoue | 11 January 2002, 02:50:01 UTC | Add a directory to save the changes until 7.3-tree is branched. | 11 January 2002, 02:50:01 UTC |
| 5370cd6 | Bruce Momjian | 11 January 2002, 00:27:42 UTC | More improvements using pg_resetxlog. still disabled. | 11 January 2002, 00:27:42 UTC |
| 9ab1872 | Bruce Momjian | 10 January 2002, 23:46:13 UTC | Have pg_resetxlog -n return zero exit status. | 10 January 2002, 23:46:13 UTC |
| 8ae5316 | Bruce Momjian | 10 January 2002, 23:41:49 UTC | Update FAQ. | 10 January 2002, 23:41:49 UTC |
| c309873 | Bruce Momjian | 10 January 2002, 23:40:58 UTC | Remove 7.1beta WAL handling from /contrib/pg_resetxlog. | 10 January 2002, 23:40:58 UTC |
| e6aa458 | Bruce Momjian | 10 January 2002, 23:35:20 UTC | Update FAQ. | 10 January 2002, 23:35:20 UTC |
| b010afe | Bruce Momjian | 10 January 2002, 23:35:19 UTC | Update FAQ. | 10 January 2002, 23:35:19 UTC |
| d356ec9 | Bruce Momjian | 10 January 2002, 23:34:14 UTC | Update FAQ. | 10 January 2002, 23:34:14 UTC |
| 775a610 | Bruce Momjian | 10 January 2002, 23:33:35 UTC | Update FAQ. | 10 January 2002, 23:33:35 UTC |
| e886905 | Bruce Momjian | 10 January 2002, 23:32:11 UTC | Update FAQ. | 10 January 2002, 23:32:11 UTC |
| e19d7b7 | Bruce Momjian | 10 January 2002, 23:07:07 UTC | Update FAQ. | 10 January 2002, 23:07:07 UTC |
| 4c0e9b5 | Bruce Momjian | 10 January 2002, 20:09:06 UTC | Add new -l flag to set checkpoint location for /contrib/pg_resetxlog. | 10 January 2002, 20:09:06 UTC |
| 0385ba1 | Peter Eisentraut | 10 January 2002, 18:22:44 UTC | Temporary workaround for links within bibliography references fouling up footnote count. | 10 January 2002, 18:22:44 UTC |
| 872aad6 | Bruce Momjian | 10 January 2002, 18:08:29 UTC | Per Tom, do full reset on -x flag. | 10 January 2002, 18:08:29 UTC |
| f6e603c | Bruce Momjian | 10 January 2002, 17:51:52 UTC | Add new -x XID option to /contrib/pg_resetxlog for future pg_upgrade use. | 10 January 2002, 17:51:52 UTC |
| 7955f98 | Michael Meskes | 10 January 2002, 10:42:54 UTC | Include sqlca.h automatically. | 10 January 2002, 10:42:54 UTC |
| 7a0672b | Bruce Momjian | 10 January 2002, 04:58:19 UTC | More pg_upgrade improvements. Almost done, except for max transaction setting. | 10 January 2002, 04:58:19 UTC |
| 4d151d0 | Bruce Momjian | 10 January 2002, 03:05:48 UTC | More improvements; still disabled. (Don't panic.) | 10 January 2002, 03:05:48 UTC |
| 92a2598 | Tom Lane | 10 January 2002, 01:11:45 UTC | The result of getopt() should be compared to -1, not EOF, per pgsql-hackers discussion of this date. | 10 January 2002, 01:11:45 UTC |
| 4d72af6 | Tom Lane | 09 January 2002, 23:38:06 UTC | Describe type casts under the heading of Value Expressions, and explain the difference between a run-time type cast and casting a literal string to a specific type. Minor editorial work in same area. | 09 January 2002, 23:38:06 UTC |
| 5461983 | Bruce Momjian | 09 January 2002, 21:50:52 UTC | Update with new features. Still disabled. | 09 January 2002, 21:50:52 UTC |
| 9facc58 | Tom Lane | 09 January 2002, 19:13:41 UTC | Fix use of 'char' to hold result of getc, per bug report forwarded by Oliver Elphick. A few other minor cleanups while at it. | 09 January 2002, 19:13:41 UTC |
| 8ff263f | Tom Lane | 09 January 2002, 18:21:46 UTC | Fix portability problem (result of getopt is int, not char). | 09 January 2002, 18:21:46 UTC |
| bf6992b | Bruce Momjian | 09 January 2002, 16:08:54 UTC | Remove clog copy. | 09 January 2002, 16:08:54 UTC |
| 7dc2dc2 | Bruce Momjian | 09 January 2002, 16:00:46 UTC | Make improvements to pg_upgrade; is still disabled. | 09 January 2002, 16:00:46 UTC |
| 5ac1098 | Bruce Momjian | 09 January 2002, 04:56:44 UTC | Add quotes around $bindir. | 09 January 2002, 04:56:44 UTC |
| da1c114 | Peter Eisentraut | 09 January 2002, 00:52:38 UTC | Make spelling of operating system names match official version closely. And listing QNX 6 as both supported and unsupported is probably not helpful. | 09 January 2002, 00:52:38 UTC |
| d079c41 | Tom Lane | 09 January 2002, 00:06:42 UTC | Fix include paths for case of VPATH build. | 09 January 2002, 00:06:42 UTC |
| c58d5d5 | Peter Eisentraut | 08 January 2002, 23:50:37 UTC | Adjust spelling of article titles to match the originals, add some links. | 08 January 2002, 23:50:37 UTC |
| 5490c72 | Tom Lane | 08 January 2002, 23:40:02 UTC | make install failed in VPATH build. | 08 January 2002, 23:40:02 UTC |
| a34f313 | Tom Lane | 08 January 2002, 23:34:47 UTC | Fix copy-and-paste mistake exposed by gcc warning. | 08 January 2002, 23:34:47 UTC |
| bf2e5ee | Tom Lane | 08 January 2002, 21:00:30 UTC | In a VPATH build, resultmap must be one of the symlinked files, else pg_regress doesn't see it and you don't get any port-specific comparisons. | 08 January 2002, 21:00:30 UTC |
| 154ccb6 | Peter Eisentraut | 08 January 2002, 20:41:28 UTC | Revert last change (CFLAGS+=-g). Probably was a mistake... | 08 January 2002, 20:41:28 UTC |
| aecd85d | Bruce Momjian | 08 January 2002, 20:04:31 UTC | Update Lockhart's email address. < * Thomas is Thomas Lockhart <lockhart@alumni.caltech.edu> --- > * Thomas is Thomas Lockhart <lockhart@fourpalms.org> | 08 January 2002, 20:04:31 UTC |
| 89e6ce1 | Bruce Momjian | 08 January 2002, 20:03:58 UTC | Update Thomas Lockhart's email address to lockhart@fourpalms.org. | 08 January 2002, 20:03:58 UTC |
| 61dd8b6 | Tom Lane | 08 January 2002, 19:02:51 UTC | Remove shift/reduce conflicts introduced by last change. | 08 January 2002, 19:02:51 UTC |
| 9c9a72b | Peter Eisentraut | 08 January 2002, 18:03:26 UTC | Repair the GEQO bibliography. It was marked up all wrong. Move some of the info to the main bibliography. | 08 January 2002, 18:03:26 UTC |
| 649d854 | Tom Lane | 08 January 2002, 17:03:41 UTC | Fix lpad() and rpad() to produce correct results in variable-length multibyte encodings. | 08 January 2002, 17:03:41 UTC |
| f872846 | Peter Eisentraut | 08 January 2002, 16:13:41 UTC | Point to main CPAN site, and reword a little. | 08 January 2002, 16:13:41 UTC |
| d09f6f7 | Tom Lane | 08 January 2002, 15:38:42 UTC | Minor wordsmithing. | 08 January 2002, 15:38:42 UTC |
| a6e704c | Peter Eisentraut | 08 January 2002, 15:16:16 UTC | Make FreeBSD URL point to the right chapter again. | 08 January 2002, 15:16:16 UTC |
| 1e15f9e | Michael Meskes | 08 January 2002, 14:25:06 UTC | Fixed array pointers, no longer using void * in arithmetics. | 08 January 2002, 14:25:06 UTC |
| 055d4f9 | Bruce Momjian | 08 January 2002, 05:45:19 UTC | Email address no longer valid. | 08 January 2002, 05:45:19 UTC |
| cc9ae0b | Bruce Momjian | 08 January 2002, 05:39:26 UTC | Update bad URL's with good ones. | 08 January 2002, 05:39:26 UTC |
| f88aa2d | Bruce Momjian | 07 January 2002, 22:36:51 UTC | Update my2pg to version 1.22. | 07 January 2002, 22:36:51 UTC |
| 6d6b3e9 | Tom Lane | 07 January 2002, 18:56:09 UTC | Add variants of digest() and hmac() that accept text inputs. Marko Kreen says: This is so obvious that I would like to make it 'official'. Seems like the theology around bytea<>text casting kept me from seeing the simple :) | 07 January 2002, 18:56:09 UTC |
| 5b9a058 | Tom Lane | 07 January 2002, 16:33:00 UTC | Tweak LWLock algorithms so that an awakened waiter for a lock is not granted the lock when awakened; the signal now only means that the lock is potentially available. The waiting process must retry its attempt to get the lock when it gets to run. This allows the lock releasing process to re-acquire the lock later in its timeslice. Since LWLocks are usually held for short periods, it is possible for a process to acquire and release the same lock many times in a timeslice. The old spinlock-based implementation of these locks allowed for that; but the original coding of LWLock would force a process swap for each acquisition if there was any contention. Although this approach reopens the door to process starvation (a waiter might repeatedly fail to get the lock), the odds of that being a big problem seem low, and the performance cost of the previous approach is considerable. | 07 January 2002, 16:33:00 UTC |
| 5445283 | Michael Meskes | 07 January 2002, 16:25:45 UTC | Fixed parser to accept initializing expressions starting with "(". | 07 January 2002, 16:25:45 UTC |
| 731204e | Peter Eisentraut | 07 January 2002, 02:29:15 UTC | Editorial review | 07 January 2002, 02:29:15 UTC |
| a510bf4 | Tom Lane | 06 January 2002, 21:40:02 UTC | If we fail to fork a new backend process, (try to) report the failure to the client before closing the connection. Before 7.2 this was done correctly, but new code would simply close the connection with no report to the client. | 06 January 2002, 21:40:02 UTC |
| 96ad60e | Bruce Momjian | 06 January 2002, 18:12:00 UTC | Fix ecpg wording to be consistent. | 06 January 2002, 18:12:00 UTC |
| 88ebc0f | Bruce Momjian | 06 January 2002, 17:54:14 UTC | Remove ecpg TODO section: > Looking at this I also found an ecpg TODO list in the docs: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/ecpg-develop.html > > Seems that TODO section should be removed. Some items are done, others > are on the main TODO list. That's correct. I did not fix the docs for quite some time. Michael -- Michael Meskes | 06 January 2002, 17:54:14 UTC |
| e59c15e | Tom Lane | 06 January 2002, 03:33:26 UTC | Fix copy-and-paste brain damage. (These commands do not create a database.) | 06 January 2002, 03:33:26 UTC |
| 3b6cbce | Tom Lane | 06 January 2002, 00:37:44 UTC | Add CHECK_FOR_INTERRUPTS() in various strategic spots, per comments from Hiroshi. | 06 January 2002, 00:37:44 UTC |
| 734e421 | Barry Lind | 05 January 2002, 22:26:23 UTC | Bugfix for bug reported by Marcus Better (marcus@dactylis.com). When preforming a get on a bytea value the code was running the raw value from the server through character set conversion, which if the character set was SQL_ASCII would cause all 8bit characters to become ?'s. | 05 January 2002, 22:26:23 UTC |
| f3efaf8 | Bruce Momjian | 05 January 2002, 04:03:47 UTC | Spelling fix: < * Consider use of open/fctl(O_DIRECT) to minimize OS caching --- > * Consider use of open/fcntl(O_DIRECT) to minimize OS caching | 05 January 2002, 04:03:47 UTC |
| 3ef4925 | Bruce Momjian | 04 January 2002, 21:32:28 UTC | Re-order items: > * Consider use of open/fctl(O_DIRECT) to minimize OS caching > * Make blind writes go through the file descriptor cache 391d392 < * Make blind writes go through the file descriptor cache 409d409 < * Consider use of open/fctl(O_DIRECT) to minimize OS caching | 04 January 2002, 21:32:28 UTC |
| 7a38672 | Bruce Momjian | 04 January 2002, 21:08:42 UTC | Added: > * Consider use of open/fctl(O_DIRECT) to minimize OS caching | 04 January 2002, 21:08:42 UTC |
| 99a3396 | Bruce Momjian | 04 January 2002, 18:58:46 UTC | ecpg.sgml manual page updated to ON. --------------------------------------------------------------------------- When you run 'ecpg --help' you get the following: -t turn on autocommit of transactions amongst the other options... Shouldn't this be OFF as per the documentation? Best regards, Lee. -- Lee Kindness, Senior Software Engineer, lkindness@csl.co.uk | 04 January 2002, 18:58:46 UTC |
| 35fcb84 | Bruce Momjian | 04 January 2002, 18:42:40 UTC | Change: < perhaps CREATE DATABASE dbname WITH USER = "user" (Gavin) --- > perhaps CREATE DATABASE dbname WITH OWNER = "user" (Gavin) | 04 January 2002, 18:42:40 UTC |
| 11d4c2c | Bruce Momjian | 04 January 2002, 18:23:56 UTC | Add from Vadim: > * Allow command blocks that can ignore certain types of errors | 04 January 2002, 18:23:56 UTC |
| 1aff1d3 | Tom Lane | 04 January 2002, 17:06:51 UTC | Fix some incorrect and obsolete commentary. | 04 January 2002, 17:06:51 UTC |
| c5c28ed | Thomas G. Lockhart | 04 January 2002, 17:02:25 UTC | Add more complete details on date/time keywords and parsing rules. Move some tabular information on these from the chapter on data types to the appendix on dates and times. | 04 January 2002, 17:02:25 UTC |
| c826d1c | Thomas G. Lockhart | 04 January 2002, 15:49:42 UTC | Have to_date() call timestamptz_date() per Karel's email instructions. Fixes time zone problems introduced by Thomas' implementation of TIMESTAMP WITHOUT TIME ZONE which caused the behavior of the previously appropriate routine, timestamp_date(), to change for the worse in this context. | 04 January 2002, 15:49:42 UTC |
| 5a60ba5 | Bruce Momjian | 04 January 2002, 05:50:25 UTC | Replace #ifdef, #endif with # requires comment. | 04 January 2002, 05:50:25 UTC |
| 0b79ed2 | Bruce Momjian | 04 January 2002, 05:44:45 UTC | Update FAQ. | 04 January 2002, 05:44:45 UTC |
| b5213b5 | Bruce Momjian | 04 January 2002, 05:03:15 UTC | Give attribution: < perhaps CREATE DATABASE dbname WITH USER = "user" --- > perhaps CREATE DATABASE dbname WITH USER = "user" (Gavin) | 04 January 2002, 05:03:15 UTC |
| f27b0ee | Bruce Momjian | 04 January 2002, 04:53:26 UTC | Remove: < * Allow only owner to create indexes | 04 January 2002, 04:53:26 UTC |
| dc6b4de | Tom Lane | 03 January 2002, 23:21:32 UTC | Require ownership permission for CREATE INDEX, per bug report. Disallow CREATE INDEX on system catalogs, non-tables (views, sequences, etc). Disallow CREATE/DROP TRIGGER on system catalogs, non-tables. Disallow ALTER TABLE ADD/DROP CONSTRAINT on system catalogs. Disallow FOREIGN KEY reference to non-table. None of these things can actually work in the present system structure, but the code was letting them pass without complaint. | 03 January 2002, 23:21:32 UTC |
| d02f0aa | Tom Lane | 03 January 2002, 21:52:05 UTC | Instead of waiting a fixed amount of time for the test postmaster to start up, wait until a psql connection attempt succeeds. Per gripe from Jason Tishler. | 03 January 2002, 21:52:05 UTC |
| 0e3793e | Bruce Momjian | 03 January 2002, 21:15:04 UTC | Prefer savepoints term: < allow error codes to be specified; requires nested transactions --- > allow error codes to be specified; requires savepoints 321c321 < * Allow nested transactions / savepoints [transactions] --- > * Allow savepoints / nested transactions [transactions] | 03 January 2002, 21:15:04 UTC |
| a2dc469 | Bruce Momjian | 03 January 2002, 20:42:23 UTC | Update: < allow error codes to be specified --- > allow error codes to be specified; requires nested transactions | 03 January 2002, 20:42:23 UTC |
| ab20692 | Tom Lane | 03 January 2002, 20:30:47 UTC | SPI_cursor_open must copy by-reference parameter values into the portal's memory context, so that they will live as long as the portal does. | 03 January 2002, 20:30:47 UTC |
| 6d78fda | Bruce Momjian | 03 January 2002, 18:25:43 UTC | Add: > o Allow COPY to report error lines and continue; optionally > allow error codes to be specified | 03 January 2002, 18:25:43 UTC |
| 258af1d | Bruce Momjian | 03 January 2002, 18:22:43 UTC | Add: > * Make equals sign optional in CREATE DATABASE WITH param = 'val' | 03 January 2002, 18:22:43 UTC |
| 8dcc4c0 | Bruce Momjian | 03 January 2002, 18:13:14 UTC | Added: > * Prevent create/drop scripts from allowing extra args (Bruce) | 03 January 2002, 18:13:14 UTC |
