Commit Graph

  • a7b7241059 Clarify URL: Bruce Momjian 2002-01-22 22:22:34 +00:00
  • f898e60ec9 Document SMP detection code. Bruce Momjian 2002-01-22 22:15:07 +00:00
  • e7e25b2d93 Re-group items. Bruce Momjian 2002-01-22 21:55:06 +00:00
  • 5b8016948e Break PERFORMANCE up into subsections. Bruce Momjian 2002-01-22 20:50:35 +00:00
  • fdf881d155 Add: Bruce Momjian 2002-01-22 20:40:27 +00:00
  • 859a9eb468 Update FAQ. Bruce Momjian 2002-01-22 20:24:14 +00:00
  • 04c8d4c660 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. Tom Lane 2002-01-22 19:02:40 +00:00
  • c64f083cf4 okay, sorry for delay all ... here is the tag for RC1 ... REL7_2_RC1 PostgreSQL Daemon 2002-01-22 17:55:30 +00:00
  • 2f383b2de6 Suppress bogus soname switch that RedHat RPMs put into tclConfig.sh. Tom Lane 2002-01-21 03:27:46 +00:00
  • bf43bed848 Spell-check and markup police Peter Eisentraut 2002-01-20 22:19:57 +00:00
  • 75f0ba9fe3 Mention that 'make distclean' is a good idea when changing configure options. Document --with-pam and --enable-depend, do some minor copy-editing. Tom Lane 2002-01-20 05:45:18 +00:00
  • 1a712718ca Add IN/EXISTS file. Bruce Momjian 2002-01-20 05:12:57 +00:00
  • e0764fdf28 Add Bruce Momjian 2002-01-20 04:56:14 +00:00
  • 0363192c69 Update from Kova'cs Zolta'n Peter Eisentraut 2002-01-18 21:25:00 +00:00
  • 0c8429ca31 Add missing literal endtag. Bruce Momjian 2002-01-18 21:17:07 +00:00
  • 0dd19ad21d Add info about how to enable large-file support, so that pg_dump won't choke at 2Gb of output. From Andrew Sullivan. Tom Lane 2002-01-18 20:56:17 +00:00
  • 74c8c09338 Add: Bruce Momjian 2002-01-18 20:46:37 +00:00
  • a724463c8a Improve non-thread-safe mention of libpq's crypt. Bruce Momjian 2002-01-18 20:39:04 +00:00
  • 9600ccad13 Improve description of autocommit behavior in ecpg manual pages. Bruce Momjian 2002-01-18 20:32:54 +00:00
  • 69f909ba10 You might want to run pg_indent on pg_backup_db.c however ... Bruce Momjian 2002-01-18 19:17:05 +00:00
  • 83b5ae65a0 Fixes to getImportedKeys/getExportedKeys from Jason Davies Previous versions did not correctly identify primary/foreign keys Dave Cramer 2002-01-18 17:21:51 +00:00
  • bb698c25c7 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. Tom Lane 2002-01-18 17:13:51 +00:00
  • 3dfe80243c Add missing 'else', per report from sugita@sra.co.jp. Tom Lane 2002-01-18 16:14:54 +00:00
  • 2ab3a88879 Accept subsequent commits. This should have been just a warning anyway. I cannot see a reason why it should be an error. Michael Meskes 2002-01-18 15:51:00 +00:00
  • 85bc36158d Enable /contrib/pg_upgrade, mention little testing. Bruce Momjian 2002-01-18 04:38:46 +00:00
  • 1d174c3086 Explain privileges required for LOCK. Minor wordsmithing too. Tom Lane 2002-01-18 01:05:43 +00:00
  • 9ad737978d Point out that superusers bypass privilege checking. Minor wordsmithing. Tom Lane 2002-01-18 01:04:53 +00:00
  • b7bf03c9ed Fix misstatements added by Bruce. Tom Lane 2002-01-16 23:51:56 +00:00
  • d781138235 Add more comments to tqual.c for visibility functions. Bruce Momjian 2002-01-16 23:09:09 +00:00
  • cf97080fa4 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. Tom Lane 2002-01-16 20:29:02 +00:00
  • 0f2d949c1e 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. Tom Lane 2002-01-16 17:34:42 +00:00
  • d66b10833f 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. Tom Lane 2002-01-15 22:33:20 +00:00
  • aa00e6134e 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. Tom Lane 2002-01-15 22:14:17 +00:00
  • 685a66cdfe 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). Tom Lane 2002-01-15 16:52:47 +00:00
  • 2843a13e51 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. Barry Lind 2002-01-15 07:37:33 +00:00
  • d013dbed75 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. Barry Lind 2002-01-15 06:55:13 +00:00
  • eb410b6bde Manual page improvements. Bruce Momjian 2002-01-15 05:41:55 +00:00
  • 08147fa7da More cleanups. Bruce Momjian 2002-01-15 05:10:57 +00:00
  • 7e1d82040e pg_upgrade doesn't live here anymore. Remove dangling references. Tom Lane 2002-01-15 05:05:49 +00:00
  • a73517cb8c Keep pg_upgrade as disabled. Bruce Momjian 2002-01-15 05:03:53 +00:00
  • 19cba1a775 More wording improvements. Bruce Momjian 2002-01-15 05:03:25 +00:00
  • fff981652e More updates. Bruce Momjian 2002-01-15 04:55:26 +00:00
  • 50c9557500 Remove old pg_upgrade script, from Tom. Bruce Momjian 2002-01-15 04:52:33 +00:00
  • 8e76187790 More cleanups with ideas from Peter. Bruce Momjian 2002-01-15 04:50:37 +00:00
  • 86beaf4fa0 Add Peter's portability and option suggestions. Bruce Momjian 2002-01-15 04:05:24 +00:00
  • ebf57dd082 Update permissions? Bruce Momjian 2002-01-14 22:54:44 +00:00
  • 2004337785 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.*. Tom Lane 2002-01-14 17:55:57 +00:00
  • eab6776358 Ensure that ecpg/test is cleaned by higher-level 'make clean'. Tom Lane 2002-01-14 17:49:56 +00:00
  • 309cbe494c Add README file. Bruce Momjian 2002-01-14 17:45:43 +00:00
  • 0451c09fd6 Doc improvements. Bruce Momjian 2002-01-14 17:42:42 +00:00
  • 15ca0a502c Add manual page to /contrib. SGML from docs. Bruce Momjian 2002-01-14 17:32:36 +00:00
  • 92a8bc9634 Move pg_upgrade to /contrib. Still need to make Peter's portability changes. Bruce Momjian 2002-01-14 17:32:07 +00:00
  • d43b364eb9 Small AIX fixes from Rick Flower. Bruce Momjian 2002-01-14 15:34:41 +00:00
  • da83ecb64e tag as beta 5 for *hopefully* a very very short beta cycle on this one? REL7_2_BETA5 PostgreSQL Daemon 2002-01-14 13:15:28 +00:00
  • 1b5d8e6d5c Fix recreation of sequence files for 7.2 also because of XID change from beta4 to beta5. Bruce Momjian 2002-01-13 17:52:00 +00:00
  • 7138a1e5fc - Fixed variable handling for struct members. - Removed check for array input. An attribut might store the complete array. Michael Meskes 2002-01-13 08:52:09 +00:00
  • 4b20cc1032 Now works for 7.1 databases. Bruce Momjian 2002-01-13 05:36:42 +00:00
  • 11b3e56223 Now tested on 7.2->7.2 migration; still disabled. Need 7.1 testing now. Bruce Momjian 2002-01-13 04:55:44 +00:00
  • 9be030fbeb Keep it disabled. Bruce Momjian 2002-01-13 01:22:27 +00:00
  • 5b2ebe95e9 Wow, it actually worked for the regression database. More testing needed. Bruce Momjian 2002-01-13 01:13:59 +00:00
  • f5bbcfb0b2 Bump catversion to ensure people apply recent timestamp and sequence fixes. Tom Lane 2002-01-12 18:09:04 +00:00
  • 47503f954c Update horology expected results (this variant extrapolated by yours truly; should be verified by someone with an appropriate system). Tom Lane 2002-01-12 18:07:34 +00:00
  • f171bd5219 Update horology expected results (this variant verified on HPUX). Tom Lane 2002-01-12 18:06:53 +00:00
  • 192061e45b 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. Thomas G. Lockhart 2002-01-12 04:38:38 +00:00
  • 0e1a5075fd 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. Tom Lane 2002-01-11 23:21:55 +00:00
  • 5c2d36c3dd Code review for latest changes. Tom Lane 2002-01-11 21:27:13 +00:00
  • c6fdf8bcfc More man pages improvements; also needed to test sgml build. Bruce Momjian 2002-01-11 20:48:47 +00:00
  • 3bb77555b1 Sync up. Bruce Momjian 2002-01-11 20:34:14 +00:00
  • 5ab0ad5c7e 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. Tom Lane 2002-01-11 20:07:03 +00:00
  • eb5e8bae26 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. Tom Lane 2002-01-11 18:16:04 +00:00
  • 051a4f233f Added Christof's fixes. Michael Meskes 2002-01-11 14:43:11 +00:00
  • 4e37786f2f More testing, more cleanups. Bruce Momjian 2002-01-11 06:48:41 +00:00
  • 37c9346ef2 pg_resetxlog specifies log location in hex; more pg_upgrade testing improvments. Bruce Momjian 2002-01-11 06:33:01 +00:00
  • ba3231a2a0 More cleanups. Bruce Momjian 2002-01-11 06:08:02 +00:00
  • d91b445117 *** empty log message *** Hiroshi Inoue 2002-01-11 06:01:47 +00:00
  • 3b3b730728 More updates for int8 sequence restoration. Old dump file not required anymore. Bruce Momjian 2002-01-11 05:54:59 +00:00
  • 6bd45e5264 Handle int4-int8 sequence migration without full data dump. Bruce Momjian 2002-01-11 04:39:19 +00:00
  • f43b5de649 Add a directory to save the changes until 7.3-tree is branched. Hiroshi Inoue 2002-01-11 02:50:01 +00:00
  • 5370cd6b03 More improvements using pg_resetxlog. still disabled. Bruce Momjian 2002-01-11 00:27:42 +00:00
  • 9ab1872ef4 Have pg_resetxlog -n return zero exit status. Bruce Momjian 2002-01-10 23:46:13 +00:00
  • 8ae53160da Update FAQ. Bruce Momjian 2002-01-10 23:41:49 +00:00
  • c309873680 Remove 7.1beta WAL handling from /contrib/pg_resetxlog. Bruce Momjian 2002-01-10 23:40:58 +00:00
  • e6aa4584ca Update FAQ. Bruce Momjian 2002-01-10 23:35:20 +00:00
  • b010afe0dd Update FAQ. Bruce Momjian 2002-01-10 23:35:19 +00:00
  • d356ec9a01 Update FAQ. Bruce Momjian 2002-01-10 23:34:14 +00:00
  • 775a61009e Update FAQ. Bruce Momjian 2002-01-10 23:33:35 +00:00
  • e8869056fa Update FAQ. Bruce Momjian 2002-01-10 23:32:11 +00:00
  • e19d7b7b95 Update FAQ. Bruce Momjian 2002-01-10 23:07:07 +00:00
  • 4c0e9b5efc Add new -l flag to set checkpoint location for /contrib/pg_resetxlog. Bruce Momjian 2002-01-10 20:09:06 +00:00
  • 0385ba1121 Temporary workaround for links within bibliography references fouling up footnote count. Peter Eisentraut 2002-01-10 18:22:44 +00:00
  • 872aad61ff Per Tom, do full reset on -x flag. Bruce Momjian 2002-01-10 18:08:29 +00:00
  • f6e603cffa Add new -x XID option to /contrib/pg_resetxlog for future pg_upgrade use. Bruce Momjian 2002-01-10 17:51:52 +00:00
  • 7955f98774 Include sqlca.h automatically. Michael Meskes 2002-01-10 10:42:54 +00:00
  • 7a0672b7b1 More pg_upgrade improvements. Almost done, except for max transaction setting. Bruce Momjian 2002-01-10 04:58:19 +00:00
  • 4d151d0b12 More improvements; still disabled. (Don't panic.) Bruce Momjian 2002-01-10 03:05:48 +00:00
  • 92a2598f97 The result of getopt() should be compared to -1, not EOF, per pgsql-hackers discussion of this date. Tom Lane 2002-01-10 01:11:45 +00:00
  • 4d72af6cb3 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. Tom Lane 2002-01-09 23:38:06 +00:00
  • 5461983d08 Update with new features. Still disabled. Bruce Momjian 2002-01-09 21:50:52 +00:00
  • 9facc585ad Fix use of 'char' to hold result of getc, per bug report forwarded by Oliver Elphick. A few other minor cleanups while at it. Tom Lane 2002-01-09 19:13:41 +00:00
  • 8ff263f362 Fix portability problem (result of getopt is int, not char). Tom Lane 2002-01-09 18:21:46 +00:00