Commit Graph

  • bc8f725a4a Done: Bruce Momjian 2002-08-27 04:30:24 +00:00
  • a4965520f6 Add to mmap discussion. Bruce Momjian 2002-08-27 04:09:01 +00:00
  • a77d34f0b8 This patch updates the lock listing code to use Joe Conway's new anonymous return type SRF code. It gets rid of the superflous 'pg_locks_result' that Bruce/Tom had commented on. Otherwise, no changes in functionality. Bruce Momjian 2002-08-27 04:00:28 +00:00
  • bda45958a8 This is a 2 line patch to src/interfaces/perl5/GNUMakefile that fixes the 'override CPPFLAGS' to include the source directory during compile, and makes the install target look in the proper place for the man page. Bruce Momjian 2002-08-27 03:57:11 +00:00
  • dd912c6977 This patches replaces a few more usages of strcpy() and sprintf() when copying into a fixed-size buffer (in this case, a buffer of NAMEDATALEN bytes). AFAICT nothing to worry about here, but worth fixing anyway... Bruce Momjian 2002-08-27 03:56:35 +00:00
  • e0a77f56e3 Cleanup of SGML Bruce Momjian 2002-08-27 03:55:17 +00:00
  • c0ad595386 I attach a little patch to make CLUSTER set and reset the indisclustered bit on the indexes. Bruce Momjian 2002-08-27 03:38:28 +00:00
  • b7e272429c Add to skip list in check_guc Bruce Momjian 2002-08-27 03:06:16 +00:00
  • fd9d665908 Comment cleanup. Bruce Momjian 2002-08-27 03:02:31 +00:00
  • fc67e1fb94 Script cleanups. Bruce Momjian 2002-08-27 03:01:13 +00:00
  • f20ec2e8f8 Clean up script. Bruce Momjian 2002-08-27 02:54:39 +00:00
  • 1051346fb7 Add check_guc utility to compare guc.c and postgresql.conf.sample. Bruce Momjian 2002-08-27 02:52:42 +00:00
  • e46afb588d Fix units in postgresql.conf. Bruce Momjian 2002-08-27 02:50:41 +00:00
  • 90997ddaac Add OS X link line example for external functions. Bruce Momjian 2002-08-26 23:22:47 +00:00
  • 543539bb35 Add discussion of pre-write pages to WAL. Bruce Momjian 2002-08-26 23:14:15 +00:00
  • 52b784a728 Add: Bruce Momjian 2002-08-26 23:13:37 +00:00
  • 3109e33eb8 Add: Bruce Momjian 2002-08-26 23:02:21 +00:00
  • 9ede612245 Add units to postgresql.conf file. Bruce Momjian 2002-08-26 22:23:07 +00:00
  • c6b67cac6b Remove: Bruce Momjian 2002-08-26 22:02:20 +00:00
  • 9072329da8 *** empty log message *** Bruce Momjian 2002-08-26 22:01:50 +00:00
  • 6f8d160be3 Add to selfjoin DELETE todo. Bruce Momjian 2002-08-26 21:52:00 +00:00
  • 80d5040fd7 Add: Bruce Momjian 2002-08-26 21:35:32 +00:00
  • 566cde8cdc Add delete selfjoin item. Bruce Momjian 2002-08-26 21:35:01 +00:00
  • 89f4f4a8e5 Add info on disabled triggers. Bruce Momjian 2002-08-26 20:03:10 +00:00
  • 339982c850 Add: Bruce Momjian 2002-08-26 20:02:45 +00:00
  • 5d6758fd24 Increase WIDTH_THRESHOLD from 256 to 1K. This addresses recent observation that ANALYZE would not gather any stats for a CHAR(255) column. I still think a width threshold is appropriate for the reasons mentioned in the code, but we can loosen it at least. Tom Lane 2002-08-26 18:45:57 +00:00
  • 5cabcfccce Modify array operations to include array's element type OID in the array header, and to compute sizing and alignment of array elements the same way normal tuple access operations do --- viz, using the tupmacs.h macros att_addlength and att_align. This makes the world safe for arrays of cstrings or intervals, and should make it much easier to write array-type-polymorphic functions; as examples see the cleanups of array_out and contrib/array_iterator. By Joe Conway and Tom Lane. Tom Lane 2002-08-26 17:54:02 +00:00
  • 8009c27592 Add 'return' file. Bruce Momjian 2002-08-26 17:40:27 +00:00
  • c7f3263dfb Add return tuple count item to TODO. Bruce Momjian 2002-08-26 17:40:00 +00:00
  • 50bbb3a11d Add: Bruce Momjian 2002-08-26 17:39:31 +00:00
  • d87677022b Add anther sequential scan email. Bruce Momjian 2002-08-26 17:14:29 +00:00
  • 43e740b317 Add mention of 1 terrabyte databases. Bruce Momjian 2002-08-26 01:05:43 +00:00
  • f5615ed45d *** empty log message *** Bruce Momjian 2002-08-26 01:04:44 +00:00
  • e21e02ab12 Add raw file discussion to performance TODO.detail. Bruce Momjian 2002-08-26 01:04:13 +00:00
  • 7e3f2449d8 Done: Bruce Momjian 2002-08-26 00:52:40 +00:00
  • 11825dd96e Add to tablespaces discussion. Bruce Momjian 2002-08-26 00:22:53 +00:00
  • 15f335eab9 Add to tablespaces file. Bruce Momjian 2002-08-26 00:19:33 +00:00
  • 39e331be72 Add Bob Devine's name to the optimizer README. Bruce Momjian 2002-08-25 22:39:37 +00:00
  • a10353ab83 Add file describing error message format. Bruce Momjian 2002-08-25 20:36:14 +00:00
  • f82bab0952 Add: Bruce Momjian 2002-08-25 20:30:30 +00:00
  • 58de480999 Clean up comments to be careful about the distinction between variable- width types and varlena types, since with the introduction of CSTRING as a more-or-less-real type, these concepts aren't identical. I've tried to use varlena consistently to denote datatypes with typlen = -1, ie, they have a length word and are potentially TOASTable; while the term variable width covers both varlena and cstring (and, perhaps, someday other types with other rules for computing the actual width). No code changes in this commit except for renaming a couple macros. Tom Lane 2002-08-25 17:20:01 +00:00
  • d46172e4fa Update docs for 7.2.2 release info. Bruce Momjian 2002-08-25 14:34:24 +00:00
  • 58e47c40a0 Update Japanese FAQ, from Jun Kuwamura Bruce Momjian 2002-08-25 12:58:44 +00:00
  • 976246cc7e The cstring datatype can now be copied, passed around, etc. The typlen value '-2' is used to indicate a variable-width type whose width is computed as strlen(datum)+1. Everything that looks at typlen is updated except for array support, which Joe Conway is working on; at the moment it wouldn't work to try to create an array of cstring. Tom Lane 2002-08-24 15:00:47 +00:00
  • cf4d885c67 Done: Bruce Momjian 2002-08-24 11:24:58 +00:00
  • fe2dec75a9 Enhancements to how queries with bind values are stored internally and sent to the server. Previously we allocated a new String object for the entire final query we were sending to the database. If you had a big query, or especially if you had large bind values you ended up with essentially two copies in memory. This change will reuse the existing objects and therefore should take 1/2 the memory it does today for a given query. This restructuring will also allow in the future the ability to stream bytea data to the server instead of the current approach of pulling it all into memory. I also fixed a test that was failing on a 7.2 database. Also renamed some internal variables and some minor cleanup. Barry Lind 2002-08-23 20:45:49 +00:00
  • a2a3192802 Further cleanup around the edges of OPAQUE/pseudotype changes. Correct the declarations of some index access method support functions. Support SQL functions returning VOID. Tom Lane 2002-08-23 16:41:38 +00:00
  • cf7ee638a7 Adapt for SRF(Set Returning Function). Tatsuo Ishii 2002-08-23 08:19:49 +00:00
  • 6415ffe7af Not sure how I fixed it the first time, but here's a fix for another instance in which the docs mention that 'NAMEDATALEN == 32". Bruce Momjian 2002-08-23 04:27:19 +00:00
  • 77072f891b Add space.k> Bruce Momjian 2002-08-23 03:10:44 +00:00
  • ec2c71ad39 Add: Bruce Momjian 2002-08-23 03:10:15 +00:00
  • 52ee800ed3 Patch resolve ERROR problem for non-goog query_txt. Bruce Momjian 2002-08-23 02:56:36 +00:00
  • 2e0e430659 This patch updates the CREATE OPERATOR sgml docs for the new default settings of NAMEDATALEN. I looked through the docs for other references to NAMEDATALEN, but this is the only one I could find. Bruce Momjian 2002-08-23 02:54:18 +00:00
  • b5ccfc216a Update Russian FAQ. Bruce Momjian 2002-08-23 02:53:20 +00:00
  • 3d801dbb1c Add: Bruce Momjian 2002-08-23 02:46:39 +00:00
  • 30ab8da488 Update HISTORY with Neil's changes. REL7_2_2 Bruce Momjian 2002-08-23 02:33:06 +00:00
  • ebddac07a9 Very minor copy-editing. Tom Lane 2002-08-23 01:28:17 +00:00
  • 6bd8a1c2d3 Add note that explains that \df omits functions it thinks are I/O functions. Tom Lane 2002-08-23 01:27:44 +00:00
  • 41ff800bb2 Update reference to value of NAMEDATALEN. Someone needs to troll the docs and find the other obsolete statements that no doubt lurk. Tom Lane 2002-08-23 00:33:24 +00:00
  • ceb9e60e8e Update contrib regression tests for OPAQUE datatype changes. Tom Lane 2002-08-23 00:04:52 +00:00
  • 14a760882a Since the plpgsql test has been part of the standard regression tests for a good long while, I see no reason to maintain this original copy. Tom Lane 2002-08-22 23:33:43 +00:00
  • 40faa4a590 Transpose info from src/pl/plpgsql/test/README into standard regression test file. Tom Lane 2002-08-22 23:31:48 +00:00
  • 17e543ee97 Stamp the 7.2.2 release. Bruce Momjian 2002-08-22 23:26:26 +00:00
  • ec35e4592d Mark 7.2.2 as newest release. Bruce Momjian 2002-08-22 23:20:52 +00:00
  • 0540b2b59d Update FAQ. Bruce Momjian 2002-08-22 23:20:25 +00:00
  • 5a303f878e Remove all traces of the ODBC driver, which is now on GBorg as the psqlodbc project ... Marc G. Fournier 2002-08-22 22:43:14 +00:00
  • 5a2c7c3e10 Fix regression-test breakage from (unnecessary) rewrite of show_datestyle. Grumble. Tom Lane 2002-08-22 22:17:22 +00:00
  • 03a7625a3a Fix bit rot in pg_dump's ability to dump from 7.2 and 7.1 servers. Tom Lane 2002-08-22 21:35:50 +00:00
  • 19b3c55261 Fixed-size buffer in dumpClasses is not big enough anymore given the addition of a column list clause to the COPY command. Spotted by Martin Renters. Tom Lane 2002-08-22 21:29:34 +00:00
  • 8c905b0aa9 Back-patch fix to make partial indexes usable on relations other than the first one listed in a query. Per request from Oleg. Tom Lane 2002-08-22 16:20:38 +00:00
  • 5530b0c666 Improve wording of upgrade section. Bruce Momjian 2002-08-22 15:31:07 +00:00
  • 0f1112923c Code review for recent TRUNCATE changes. Tighten relation-kind check, tighten foreign-key check (a self-reference should not prevent TRUNCATE), improve error message, cause a relation's TOAST table to be truncated along with the relation. Tom Lane 2002-08-22 14:23:36 +00:00
  • cd9f392cd0 Apply Neil Conway's security patches to 7.2.X. Bruce Momjian 2002-08-22 05:27:41 +00:00
  • b4f24fed7a Commit updated repeat() patch, from Neil Conway Bruce Momjian 2002-08-22 05:05:19 +00:00
  • 090884bed3 Fix for documention: Bruce Momjian 2002-08-22 04:56:44 +00:00
  • d86dee3edd This patch should fix the problem. Doesn't include my previous patch for repeat(). Again, somewhat off-the-cuff, so I might have missed something... Bruce Momjian 2002-08-22 04:55:05 +00:00
  • cbe733d752 repeat() fix: Bruce Momjian 2002-08-22 04:54:20 +00:00
  • c76f5aa530 > > I had great difficulty in finding how to change the search path, so here > > is a patch to add some cross-referencing. Bruce Momjian 2002-08-22 04:52:17 +00:00
  • 47b37a6bfa # Disallow TRUNCATE on tables that are involved in referential constraints Bruce Momjian 2002-08-22 04:51:06 +00:00
  • dac22ee43c Add: Bruce Momjian 2002-08-22 04:47:31 +00:00
  • a334ae3f22 As suggested by Tom, this patch restricts the right-hand argument of bytealike to TEXT. Bruce Momjian 2002-08-22 04:45:11 +00:00
  • c7e7672937 Oops, we got duplicate oids from patches again; pick a unique one. Bruce Momjian 2002-08-22 04:41:06 +00:00
  • 89260124db Add: Bruce Momjian 2002-08-22 03:24:01 +00:00
  • f6353c6ee4 Remove libpq++ SGML documentation. Bruce Momjian 2002-08-22 03:17:38 +00:00
  • ff1793f036 Remove erroneous character from Makefile due to editor error. Bruce Momjian 2002-08-22 02:18:45 +00:00
  • da4683fbe1 Okay, libpq++ is moved to GBorg, and all traces of it have been removed from the core repository ... I haven't *moved* the libpq++ files out of the tree, mainly as we want to keep them in place for past branches ... Marc G. Fournier 2002-08-22 00:15:14 +00:00
  • b663f3443b Add a bunch of pseudo-types to replace the behavior formerly associated with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ... Tom Lane 2002-08-22 00:01:51 +00:00
  • 606c9b9d4f Add --help and --version options. Message cleanup. NLS. Peter Eisentraut 2002-08-21 22:24:34 +00:00
  • d46e3dc00f Changes made so new conversion Makefiles will build out of the source tree. Bruce Momjian 2002-08-21 21:33:55 +00:00
  • 41c92ace2f Move PO files into subdirectories separate from the source code. Peter Eisentraut 2002-08-21 20:42:27 +00:00
  • b7a5917a61 Add sys/types.h to common includes. Peter Eisentraut 2002-08-21 17:20:58 +00:00
  • 0f9f2feee4 Fix bad markup detected by Alvaro Herrera Bruce Momjian 2002-08-21 16:08:19 +00:00
  • cbe19208ee Fix markup, Alvaro Herrera. Bruce Momjian 2002-08-21 05:25:49 +00:00
  • 091ff0931d Use a non-duplicate OID for pg_lock_status. Tom Lane 2002-08-20 19:23:07 +00:00
  • 6faf8024fa Enable large file support. Peter Eisentraut 2002-08-20 17:54:45 +00:00
  • 0d6f613817 Increase buffer size in cash_words(). Pure paranoia; I don't think the code is broken, but any small change in the output format might overrun the buffer with the old size. Tom Lane 2002-08-20 16:46:29 +00:00
  • 9318fa8541 Update expected files for recent changes of domain tests. From Rod Taylor. Tom Lane 2002-08-20 16:37:03 +00:00
  • aa7fdbe364 MAde preproc.y compile with bison 1.49b. Michael Meskes 2002-08-20 12:23:36 +00:00
  • ebe1be1321 This patch improves the behavior of FOUND in PL/PgSQL. In Oracle, FOUND is set whenever a SELECT INTO returns > 0 rows, *or* when an INSERT, UPDATE, or DELETE affects > 0 rows. We implemented the first part of this behavior, but not the second. Bruce Momjian 2002-08-20 05:28:24 +00:00
  • 818a33e4d5 Cleanup. Bruce Momjian 2002-08-20 05:12:48 +00:00