0e8ab3a | PostgreSQL Daemon | 25 January 2002, 02:09:26 UTC | let's roll up rc2 .. | 25 January 2002, 02:09:26 UTC |
974135a | Bruce Momjian | 25 January 2002, 01:04:47 UTC | Add 128 mention: > * Increase identifier length (NAMEDATALEN) if small performance hit, > perhaps to standard length of 128; change struct pgNotify to use pid > first, breaks notify API; | 25 January 2002, 01:04:47 UTC |
b440e17 | Bruce Momjian | 24 January 2002, 23:50:09 UTC | Updated: > * Increase identifier length (NAMEDATALEN) if small performance hit; > change struct pgNotify to use pid first, breaks notify API | 24 January 2002, 23:50:09 UTC |
daf4891 | Bruce Momjian | 24 January 2002, 23:35:40 UTC | Added: > * Evaluate AIX cs() spinlock macro for performance optimizations (Tatsuo) | 24 January 2002, 23:35:40 UTC |
d958c08 | Bruce Momjian | 24 January 2002, 22:20:18 UTC | Another clarification. | 24 January 2002, 22:20:18 UTC |
b23de01 | Bruce Momjian | 24 January 2002, 22:19:48 UTC | Clarification on COPY failure options. | 24 January 2002, 22:19:48 UTC |
989b7d6 | Tom Lane | 24 January 2002, 21:40:44 UTC | Tweak plperl.c to compile against threaded Perls, per report from cturner@redhat.com. | 24 January 2002, 21:40:44 UTC |
3f5d3ce | Tom Lane | 24 January 2002, 19:50:36 UTC | Cope with gcc that outputs a multiline version string, per Trond. | 24 January 2002, 19:50:36 UTC |
47ccf37 | Tom Lane | 24 January 2002, 19:31:36 UTC | pltcl's spi_execp didn't handle NULL arguments quite correctly. It would try to call the input conversion routines for them anyway. So, a valid input string for the datatype had to be supplied. | 24 January 2002, 19:31:36 UTC |
db42e32 | Tom Lane | 24 January 2002, 18:28:15 UTC | Fix documentation misstatement: OLD is not valid in ON SELECT. | 24 January 2002, 18:28:15 UTC |
a45641d | Tom Lane | 24 January 2002, 16:53:42 UTC | Fix incorrect test for whether Perl code is returning undef. This allows plperl routines to return NULL as intended. | 24 January 2002, 16:53:42 UTC |
386f180 | Tom Lane | 24 January 2002, 15:31:43 UTC | Fix logic error in insert_fsm_page_entry: because compact_fsm_page_list removes any empty chunks, the chunk previously added won't be there anymore, so it's possible there is zero free space in the rel's page list afterwards. Must loop back and rerun the part that adds a chunk to the list. | 24 January 2002, 15:31:43 UTC |
cf77a2a | Tom Lane | 23 January 2002, 21:08:17 UTC | Overhaul PL/Tcl documentation. | 23 January 2002, 21:08:17 UTC |
35a5129 | Bruce Momjian | 23 January 2002, 19:22:08 UTC | Add Goggle mention of previous discussion. | 23 January 2002, 19:22:08 UTC |
ab5b063 | Tom Lane | 23 January 2002, 18:48:39 UTC | Remove long-obsolete version of pltcl documentation. | 23 January 2002, 18:48:39 UTC |
830cdb5 | Tom Lane | 23 January 2002, 18:45:41 UTC | Clean up Red Hat Tcl RPM brain-damage in a more reliable way: fix the value of TCL_SHLIB_LD in the shell script that creates Makefile.tcldefs, rather than trying to persude gmake to do it. | 23 January 2002, 18:45:41 UTC |
8ac3b16 | Bruce Momjian | 23 January 2002, 18:40:22 UTC | Add new email;remove old entries. | 23 January 2002, 18:40:22 UTC |
cb8961a | Michael Meskes | 23 January 2002, 16:34:06 UTC | Added patch to temporarily disable locale for descriptors too (Christof) | 23 January 2002, 16:34:06 UTC |
9d25b39 | Bruce Momjian | 23 January 2002, 16:14:04 UTC | Add: > * Reorder postgresql.conf WAL items in order of importance > * Remove wal_files postgresql.conf option because WAL files are now recycled > * Find proper defaults for postgresql.conf WAL entries > * Add checkpoint_min_warning postgresql.conf option to warn about checkpoints > that are too frequent | 23 January 2002, 16:14:04 UTC |
a7b7241 | Bruce Momjian | 22 January 2002, 22:22:34 UTC | Clarify URL: < http://www1.distributed.net/source, in client/common/cpucheck.cpp --- > from distributted.net, http://www1.distributed.net/source, > in client/common/cpucheck.cpp | 22 January 2002, 22:22:34 UTC |
f898e60 | Bruce Momjian | 22 January 2002, 22:15:07 UTC | Document SMP detection code. | 22 January 2002, 22:15:07 UTC |
e7e25b2 | Bruce Momjian | 22 January 2002, 21:55:06 UTC | Re-group items. | 22 January 2002, 21:55:06 UTC |
5b80169 | Bruce Momjian | 22 January 2002, 20:50:35 UTC | Break PERFORMANCE up into subsections. | 22 January 2002, 20:50:35 UTC |
fdf881d | Bruce Momjian | 22 January 2002, 20:40:27 UTC | Add: > * Add code to detect an SMP machine and handle spinlocks accordingly | 22 January 2002, 20:40:27 UTC |
859a9eb | Bruce Momjian | 22 January 2002, 20:24:14 UTC | Update FAQ. | 22 January 2002, 20:24:14 UTC |
04c8d4c | Tom Lane | 22 January 2002, 19:02:40 UTC | libpq++/pgconnection.h must not include postgres_fe.h, else it fails to compile in client apps that use the standard installed header set. To allow removing that include, move DLLIMPORT definitions out of c.h and into the appropriate port-specific header files. | 22 January 2002, 19:02:40 UTC |
c64f083 | PostgreSQL Daemon | 22 January 2002, 17:55:30 UTC | okay, sorry for delay all ... here is the tag for RC1 ... | 22 January 2002, 17:55:30 UTC |
2f383b2 | Tom Lane | 21 January 2002, 03:27:46 UTC | Suppress bogus soname switch that RedHat RPMs put into tclConfig.sh. | 21 January 2002, 03:27:46 UTC |
bf43bed | Peter Eisentraut | 20 January 2002, 22:19:57 UTC | Spell-check and markup police | 20 January 2002, 22:19:57 UTC |
75f0ba9 | Tom Lane | 20 January 2002, 05:45:18 UTC | Mention that 'make distclean' is a good idea when changing configure options. Document --with-pam and --enable-depend, do some minor copy-editing. | 20 January 2002, 05:45:18 UTC |
1a71271 | Bruce Momjian | 20 January 2002, 05:12:57 UTC | Add IN/EXISTS file. | 20 January 2002, 05:12:57 UTC |
e0764fd | Bruce Momjian | 20 January 2002, 04:56:14 UTC | Add > * Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS [exists] | 20 January 2002, 04:56:14 UTC |
0363192 | Peter Eisentraut | 18 January 2002, 21:25:00 UTC | Update from Kova'cs Zolta'n | 18 January 2002, 21:25:00 UTC |
0c8429c | Bruce Momjian | 18 January 2002, 21:17:07 UTC | Add missing literal endtag. | 18 January 2002, 21:17:07 UTC |
0dd19ad | Tom Lane | 18 January 2002, 20:56:17 UTC | Add info about how to enable large-file support, so that pg_dump won't choke at 2Gb of output. From Andrew Sullivan. | 18 January 2002, 20:56:17 UTC |
74c8c09 | Bruce Momjian | 18 January 2002, 20:46:37 UTC | Add: > * Use thread-safe crypt() in libpq, if available | 18 January 2002, 20:46:37 UTC |
a724463 | Bruce Momjian | 18 January 2002, 20:39:04 UTC | Improve non-thread-safe mention of libpq's crypt. | 18 January 2002, 20:39:04 UTC |
9600cca | Bruce Momjian | 18 January 2002, 20:32:54 UTC | Improve description of autocommit behavior in ecpg manual pages. | 18 January 2002, 20:32:54 UTC |
69f909b | Bruce Momjian | 18 January 2002, 19:17:05 UTC | You might want to run pg_indent on pg_backup_db.c however ... tom lane | 18 January 2002, 19:17:05 UTC |
83b5ae6 | Dave Cramer | 18 January 2002, 17:21:51 UTC | Fixes to getImportedKeys/getExportedKeys from Jason Davies Previous versions did not correctly identify primary/foreign keys | 18 January 2002, 17:21:51 UTC |
bb698c2 | Tom Lane | 18 January 2002, 17:13:51 UTC | Fix pg_restore to handle the 'set max oid' entry correctly in archives dumped by pg_dump -o. Per bug report posted by Bruce; fix is from Philip Warner, reviewed by Tom Lane. | 18 January 2002, 17:13:51 UTC |
3dfe802 | Tom Lane | 18 January 2002, 16:14:54 UTC | Add missing 'else', per report from sugita@sra.co.jp. | 18 January 2002, 16:14:54 UTC |
2ab3a88 | Michael Meskes | 18 January 2002, 15:51:00 UTC | Accept subsequent commits. This should have been just a warning anyway. I cannot see a reason why it should be an error. | 18 January 2002, 15:51:00 UTC |
85bc361 | Bruce Momjian | 18 January 2002, 04:38:46 UTC | Enable /contrib/pg_upgrade, mention little testing. | 18 January 2002, 04:38:46 UTC |
1d174c3 | Tom Lane | 18 January 2002, 01:05:43 UTC | Explain privileges required for LOCK. Minor wordsmithing too. | 18 January 2002, 01:05:43 UTC |
9ad7379 | Tom Lane | 18 January 2002, 01:04:53 UTC | Point out that superusers bypass privilege checking. Minor wordsmithing. | 18 January 2002, 01:04:53 UTC |
b7bf03c | Tom Lane | 16 January 2002, 23:51:56 UTC | Fix misstatements added by Bruce. | 16 January 2002, 23:51:56 UTC |
d781138 | Bruce Momjian | 16 January 2002, 23:09:09 UTC | Add more comments to tqual.c for visibility functions. | 16 January 2002, 23:09:09 UTC |
cf97080 | Tom Lane | 16 January 2002, 20:29:02 UTC | TOAST needs to do at least minimal time-qual checking in order not to mess up after an aborted VACUUM FULL, per today's pghackers discussion. Add a suitable HeapTupleSatisfiesToast routine. Remove useless special- case test in HeapTupleSatisfiesVisibility macro for xmax = BootstrapTransactionId; perhaps that was needed at one time, but it's a waste of cycles now, not to mention actively wrong for SnapshotAny. Along the way, add some much-needed comments to tqual.c, and simplify toast_fetch_datum, which no longer needs to assume it may see chunks out-of-order. | 16 January 2002, 20:29:02 UTC |
0f2d949 | Tom Lane | 16 January 2002, 17:34:42 UTC | Fix init_irels to close the pg_internal.init file before returning. This saves one open file descriptor per backend, and avoids an annoying NOTICE on Cygwin (which has trouble deleting open files). Bug appears to date back to original coding of init_irels, circa 1992. | 16 January 2002, 17:34:42 UTC |
d66b108 | Tom Lane | 15 January 2002, 22:33:20 UTC | If we fail to rename pg_internal.init into place, delete the useless temporary file. This seems to be a known failure mode under Cygwin, so we might as well expend the extra line of code to be tidy. | 15 January 2002, 22:33:20 UTC |
aa00e61 | Tom Lane | 15 January 2002, 22:14:17 UTC | Add more sanity-checking to PageAddItem and PageIndexTupleDelete, to prevent spreading of corruption when page header pointers are bad. Merge PageZero into PageInit, since it was never used separately, and remove separate memset calls used at most other PageInit call points. Remove IndexPageCleanup, which wasn't used at all. | 15 January 2002, 22:14:17 UTC |
685a66c | Tom Lane | 15 January 2002, 16:52:47 UTC | Fix typo that caused equalTriggerDescs() to return false in cases where the two trigger sets were logically equal, but not in the same order. Caught by Holger Krug (hkrug@rationalizer.com). | 15 January 2002, 16:52:47 UTC |
2843a13 | Barry Lind | 15 January 2002, 07:37:33 UTC | Applied patch submitted by Ryouichi Matsuda (r-matuda@sra.co.jp) that fixed a problem with leading zeros being lost on fractional seconds when setting a timestamp value on a PreparedStatement. | 15 January 2002, 07:37:33 UTC |
d013dbe | Barry Lind | 15 January 2002, 06:55:13 UTC | Applied patch from Ryouichi Matsuda <r-matuda@sra.co.jp> where the jdbc driver was not properly handling timestamptz datatype when using the getObject() method on ResultSet. Fix adds this datatype to the object mappings. | 15 January 2002, 06:55:13 UTC |
eb410b6 | Bruce Momjian | 15 January 2002, 05:41:55 UTC | Manual page improvements. | 15 January 2002, 05:41:55 UTC |
08147fa | Bruce Momjian | 15 January 2002, 05:10:57 UTC | More cleanups. | 15 January 2002, 05:10:57 UTC |
7e1d820 | Tom Lane | 15 January 2002, 05:05:49 UTC | pg_upgrade doesn't live here anymore. Remove dangling references. | 15 January 2002, 05:05:49 UTC |
a73517c | Bruce Momjian | 15 January 2002, 05:03:53 UTC | Keep pg_upgrade as disabled. | 15 January 2002, 05:03:53 UTC |
19cba1a | Bruce Momjian | 15 January 2002, 05:03:25 UTC | More wording improvements. | 15 January 2002, 05:03:25 UTC |
fff9816 | Bruce Momjian | 15 January 2002, 04:55:26 UTC | More updates. | 15 January 2002, 04:55:26 UTC |
50c9557 | Bruce Momjian | 15 January 2002, 04:52:33 UTC | Remove old pg_upgrade script, from Tom. | 15 January 2002, 04:52:33 UTC |
8e76187 | Bruce Momjian | 15 January 2002, 04:50:37 UTC | More cleanups with ideas from Peter. | 15 January 2002, 04:50:37 UTC |
86beaf4 | Bruce Momjian | 15 January 2002, 04:05:24 UTC | Add Peter's portability and option suggestions. | 15 January 2002, 04:05:24 UTC |
ebf57dd | Bruce Momjian | 14 January 2002, 22:54:44 UTC | Update permissions? | 14 January 2002, 22:54:44 UTC |
2004337 | Tom Lane | 14 January 2002, 17:55:57 UTC | Reduce severity of 'XLogFlush: request is not satisfied' error condition, per my proposal of a couple days ago. This will eliminate the unable- to-restart-database class of problem that we have seen reported half a dozen times with 7.1.*. | 14 January 2002, 17:55:57 UTC |
eab6776 | Tom Lane | 14 January 2002, 17:49:56 UTC | Ensure that ecpg/test is cleaned by higher-level 'make clean'. | 14 January 2002, 17:49:56 UTC |
309cbe4 | Bruce Momjian | 14 January 2002, 17:45:43 UTC | Add README file. | 14 January 2002, 17:45:43 UTC |
0451c09 | Bruce Momjian | 14 January 2002, 17:42:42 UTC | Doc improvements. | 14 January 2002, 17:42:42 UTC |
15ca0a5 | Bruce Momjian | 14 January 2002, 17:32:36 UTC | Add manual page to /contrib. SGML from docs. | 14 January 2002, 17:32:36 UTC |
92a8bc9 | Bruce Momjian | 14 January 2002, 17:32:07 UTC | Move pg_upgrade to /contrib. Still need to make Peter's portability changes. | 14 January 2002, 17:32:07 UTC |
d43b364 | Bruce Momjian | 14 January 2002, 15:34:41 UTC | Small AIX fixes from Rick Flower. | 14 January 2002, 15:34:41 UTC |
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 |