hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-04-12 09:17:01 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 1449e6f981 Update upgrade FAQ info. Bruce Momjian 2007-02-23 19:06:22 +00:00
  • b950596ffd Update Solaris FAQ. Bruce Momjian 2007-02-23 18:38:19 +00:00
  • 7031dd6869 Add psql \prompt capability. Bruce Momjian 2007-02-23 18:20:59 +00:00
  • cc77005df7 Change Agg and Group nodes so that Vars contained in their targetlists and quals have varno OUTER, rather than zero, to indicate a reference to an output of their lefttree subplan. This is consistent with the way that every other upper-level node type does it, and allows some simplifications in setrefs.c and EXPLAIN. Tom Lane 2007-02-22 23:44:25 +00:00
  • 3c5985b473 Fix bug I introduced in recent patch to make hash joins discard null tuples immediately: ExecHashGetHashValue failed to restore the caller's memory context before taking the failure exit. Tom Lane 2007-02-22 22:49:27 +00:00
  • eab6b8b27e Turn the rangetable used by the executor into a flat list, and avoid storing useless substructure for its RangeTblEntry nodes. (I chose to keep using the same struct node type and just zero out the link fields for unneeded info, rather than making a separate ExecRangeTblEntry type --- it seemed too fragile to have two different rangetable representations.) Tom Lane 2007-02-22 22:00:26 +00:00
  • 849000c782 Remove extra tab. Bruce Momjian 2007-02-21 23:22:42 +00:00
  • 7c656baf15 Remove tabs from SGML reference files, so their addition can be detected in the future. Bruce Momjian 2007-02-21 23:21:12 +00:00
  • 8c98fd6e7f Update upgrade wording. Bruce Momjian 2007-02-21 22:54:11 +00:00
  • 50c7e83cd7 Update new optional VACUUM FULL hint for translations, per Alvaro. Bruce Momjian 2007-02-21 22:47:45 +00:00
  • 3aa37600aa Move increase FSM warning to after lazy_truncate_heap() because the function might reduce the number of free pages in the table. Recommend VACUUM FULL only if 20% free. Bruce Momjian 2007-02-21 22:15:21 +00:00
  • 6f519ad01c btree source code cleanups: Bruce Momjian 2007-02-21 20:02:17 +00:00
  • 526b1d6979 Update FAQ about minor updates. Bruce Momjian 2007-02-21 19:48:02 +00:00
  • 9bc6af8026 Update Japanese FAQ. Bruce Momjian 2007-02-21 17:23:49 +00:00
  • bded8fdd8d Update URL in German FAQ for bug form, per Schima, Fabian Bruce Momjian 2007-02-21 16:49:37 +00:00
  • 9395aa5392 Update Chinese FAQs to have two versions, a traditional Chinese version (Taiwan) and a Simplified version (China (PRC)). Bruce Momjian 2007-02-21 16:42:43 +00:00
  • 28ebe6b5d0 Update Chinese FAQs to have two versions, a traditional Chinese version (Taiwan) and a Simplified version (China (PRC)). Bruce Momjian 2007-02-21 16:42:36 +00:00
  • c1958e5bd4 Fix typo, per Dave Page. Bruce Momjian 2007-02-21 16:09:01 +00:00
  • 3986d713ac Update minor release text. Bruce Momjian 2007-02-21 16:08:05 +00:00
  • 6765df9174 Add configure --enable-profiling to enable GCC profiling. Patches from Korry Douglas and Nikhil S Bruce Momjian 2007-02-21 15:12:39 +00:00
  • 879caf1369 Update upgrade text. Bruce Momjian 2007-02-21 15:07:35 +00:00
  • 49cc503f54 Revert changes to process pg_proc.h entries without OIDs. We're not supposed to have such entries, and want to be notified when we do... Leave the plain bugfix in genbki. Magnus Hagander 2007-02-21 12:28:27 +00:00
  • f8e9fb2d87 Update URL for set-returning functions. Bruce Momjian 2007-02-21 03:50:57 +00:00
  • afc7e0d848 Allow pltcl args to spi_prepare and plpython args to plpy.prepare to be standard type aliases as well as those known in pg_type. Similar to recent change in plperl. Andrew Dunstan 2007-02-21 03:27:32 +00:00
  • 80ab3e0d34 Add URL for: Bruce Momjian 2007-02-21 01:08:58 +00:00
  • 272b6ef20d Prevent BLCKSZ < 1024, and have initdb test shared buffers based on the BLCKSZ value. Bruce Momjian 2007-02-20 23:49:38 +00:00
  • 4816b0f452 Add: Bruce Momjian 2007-02-20 23:39:03 +00:00
  • 57352df66d Fix markup. Bruce Momjian 2007-02-20 23:14:19 +00:00
  • e152949ee2 Change $(CC) to $(COMPILER) on Solaris gcc so -m64 is passed into the shared link line. Bruce Momjian 2007-02-20 22:45:57 +00:00
  • a64e85eb68 Add: Bruce Momjian 2007-02-20 22:29:28 +00:00
  • 6e6dab8c87 Add URL for: Bruce Momjian 2007-02-20 22:23:05 +00:00
  • 916ecf2d5d Add: Bruce Momjian 2007-02-20 21:22:35 +00:00
  • 664009ecb1 Update "encode" documentation to mention that 'escape' only changes null bytes and backslashes, remove "ASCII" mention. Backpatch to 8.2.X. Bruce Momjian 2007-02-20 19:59:18 +00:00
  • b92767d525 Update "encode" documentation to mention that 'escape' only changes null bytes and backslashes, remove "ASCII" mention. Backpatch to 8.2.X. Bruce Momjian 2007-02-20 19:59:04 +00:00
  • 298de77d51 Update pgpass Win32 wording. Bruce Momjian 2007-02-20 19:35:17 +00:00
  • 6f9027372b Update information_schema documentation to match system tables. Backpatch to 8.2.X. Bruce Momjian 2007-02-20 18:47:34 +00:00
  • 8e1ccad519 Update information_schema documentation to match system tables. Backpatch to 8.2.X. Bruce Momjian 2007-02-20 18:47:25 +00:00
  • ddd8817f45 Wording improvement. Bruce Momjian 2007-02-20 18:18:05 +00:00
  • 57bcfe0065 More clearly document that most PostgreSQL utilities support libpq environment variables. Backpatch to 8.2.X. Bruce Momjian 2007-02-20 18:11:17 +00:00
  • 571df93cff More clearly document that most PostgreSQL utilities support libpq environment variables. Backpatch to 8.2.X. Bruce Momjian 2007-02-20 18:10:59 +00:00
  • ecba519d4e Adjust user-facing documentation to explain why we don't check pgpass file permissions on Windows. Tom Lane 2007-02-20 17:47:04 +00:00
  • 9cbd0c155d Remove the Query structure from the executor's API. This allows us to stop storing mostly-redundant Query trees in prepared statements, portals, etc. To replace Query, a new node type called PlannedStmt is inserted by the planner at the top of a completed plan tree; this carries just the fields of Query that are still needed at runtime. The statement lists kept in portals etc. now consist of intermixed PlannedStmt and bare utility-statement nodes --- no Query. This incidentally allows us to remove some fields from Query and Plan nodes that shouldn't have been there in the first place. Tom Lane 2007-02-20 17:32:18 +00:00
  • 71b0cf2f6b Remove, item not needed for Win32: Bruce Momjian 2007-02-20 15:21:42 +00:00
  • 2d848857ee Add comment that on Win32, we don't need to check the .pgpass file permission, per Magnus. Bruce Momjian 2007-02-20 15:20:51 +00:00
  • b16dab66a7 Remove "History" sections for pg_dump and pg_restore. I don't think anyone cares because the last history change was for PostgreSQL 7.1. Bruce Momjian 2007-02-20 15:01:17 +00:00
  • 44764fba1b Spell check on array patch. Bruce Momjian 2007-02-20 14:54:51 +00:00
  • ff0d71e263 Spell check on array patch. Bruce Momjian 2007-02-20 14:54:47 +00:00
  • bfc53d7da4 Add for WIN32: Bruce Momjian 2007-02-20 14:48:47 +00:00
  • 0586e9b682 Update array slice documentation to be clearer. Bruce Momjian 2007-02-20 14:34:29 +00:00
  • 1b52359d90 Update array slice documentation to be clearer. Bruce Momjian 2007-02-20 14:34:25 +00:00
  • 265124e7e0 Add: Bruce Momjian 2007-02-20 14:17:24 +00:00
  • 7194ab3f55 Comment-out documentation for IS OF because it doesn't conform to the ISO SQL behavior. Backpatch removal to 8.2.X. Bruce Momjian 2007-02-20 14:05:02 +00:00
  • 8272fc3f7b Comment-out documentation for IS OF because it doesn't conform to the ISO SQL behavior. Backpatch removal to 8.2.X. Bruce Momjian 2007-02-20 14:04:50 +00:00
  • 28b96f2a30 Identify schema of inherited table in psql \d when necessary. Peter Eisentraut 2007-02-20 10:23:38 +00:00
  • 63e03ba923 Add missing OIDs to pg_proc. Peter Eisentraut 2007-02-20 10:00:25 +00:00
  • 2673961659 Remove item: Bruce Momjian 2007-02-20 03:47:03 +00:00
  • d9341ce1b8 Document IS [NOT] OF, which was added in 7.3. Bruce Momjian 2007-02-20 00:25:16 +00:00
  • 6126d3e70b Document IS [NOT] OF, which was added in 7.3. Bruce Momjian 2007-02-20 00:25:05 +00:00
  • 077d753a57 Add FAQ text about Makefile.custom: Bruce Momjian 2007-02-19 23:45:38 +00:00
  • c62de15bec Document that to_char('J'/Julian) is midnight-based, per report that Julian technically is noon to noon. Bruce Momjian 2007-02-19 22:51:44 +00:00
  • 9772e0007c Wording improvement. Bruce Momjian 2007-02-19 22:10:52 +00:00
  • c2039e4477 Update PQfree() documentation to be clearer, backpatch to 8.2.X. Bruce Momjian 2007-02-19 22:06:30 +00:00
  • e3285f32e8 Update PQfree() documentation to be clearer, backpatch to 8.2.X. Bruce Momjian 2007-02-19 22:06:23 +00:00
  • 4acc4aa871 Update wording: Bruce Momjian 2007-02-19 21:08:48 +00:00
  • bba9ec141f Add: Bruce Momjian 2007-02-19 21:07:25 +00:00
  • 6042bb498c Add newlines. Bruce Momjian 2007-02-19 20:42:33 +00:00
  • 5855d2b593 Add: Bruce Momjian 2007-02-19 20:41:40 +00:00
  • c7116a4112 Add: Bruce Momjian 2007-02-19 20:06:56 +00:00
  • 11fa6f59da Clarify documentation that initdb -A or editing pg_hba.conf is required if you do not trust local users. Bruce Momjian 2007-02-19 18:57:18 +00:00
  • 70007b4dd5 Clarify documentation for "day of the week" handling for to_char() and EXTRACT(). Bruce Momjian 2007-02-19 18:20:06 +00:00
  • 107062e008 Done: Bruce Momjian 2007-02-19 17:58:32 +00:00
  • 3e803f7273 Add "isodow" option to EXTRACT() and date_part() where Sunday = 7. Bruce Momjian 2007-02-19 17:41:39 +00:00
  • 27d6ee04b8 Done: Bruce Momjian 2007-02-19 17:21:24 +00:00
  • 68c7cb5ed5 Done: Bruce Momjian 2007-02-19 16:36:17 +00:00
  • 7c2e6f31be Fix pg_dump on win32 to properly dump files larger than 2Gb when using binary dump formats. Magnus Hagander 2007-02-19 15:05:21 +00:00
  • 74096ed1fd Fix pg_dump on win32 to properly dump files larger than 2Gb when using binary dump formats. Magnus Hagander 2007-02-19 15:05:06 +00:00
  • bc959b7bd2 Parse pg_proc.h with entries without OIDs. Magnus Hagander 2007-02-19 14:05:42 +00:00
  • 7c5e5439d2 Get rid of some old and crufty global variables in the planner. When this code was last gone over, there wasn't really any alternative to globals because we didn't have the PlannerInfo struct being passed all through the planner code. Now that we do, we can restructure things to avoid non-reentrancy. I'm fooling with this because otherwise I'd have had to add another global variable for the planned compact range table list. Tom Lane 2007-02-19 07:03:34 +00:00
  • 90c301aaa9 Improve plpgsql's error message when a datatype declaration is omitted. Per example from Jeff Ross. Tom Lane 2007-02-19 03:18:51 +00:00
  • b8c3267792 Put function expressions and values lists into FunctionScan and ValuesScan plan nodes, so that the executor does not need to get these items from the range table at runtime. This will avoid needing to include these fields in the compact range table I'm expecting to make the executor use. Tom Lane 2007-02-19 02:23:12 +00:00
  • 59a5f8bb18 Fix portal management code to support non-default command completion tags for portals using PORTAL_UTIL_SELECT strategy. This is currently significant only for FETCH queries, which are supposed to include a count in the tag. Seems it's been broken since 7.4, but nobody noticed before Knut Lehre. Tom Lane 2007-02-18 19:49:49 +00:00
  • 34f92d2c77 Fix portal management code to support non-default command completion tags for portals using PORTAL_UTIL_SELECT strategy. This is currently significant only for FETCH queries, which are supposed to include a count in the tag. Seems it's been broken since 7.4, but nobody noticed before Knut Lehre. Tom Lane 2007-02-18 19:49:42 +00:00
  • 355451be0e Fix portal management code to support non-default command completion tags for portals using PORTAL_UTIL_SELECT strategy. This is currently significant only for FETCH queries, which are supposed to include a count in the tag. Seems it's been broken since 7.4, but nobody noticed before Knut Lehre. Tom Lane 2007-02-18 19:49:35 +00:00
  • 812a929a85 Fix portal management code to support non-default command completion tags for portals using PORTAL_UTIL_SELECT strategy. This is currently significant only for FETCH queries, which are supposed to include a count in the tag. Seems it's been broken since 7.4, but nobody noticed before Knut Lehre. Tom Lane 2007-02-18 19:49:30 +00:00
  • f1f2b2711a Fix portal management code to support non-default command completion tags for portals using PORTAL_UTIL_SELECT strategy. This is currently significant only for FETCH queries, which are supposed to include a count in the tag. Seems it's been broken since 7.4, but nobody noticed before Knut Lehre. Tom Lane 2007-02-18 19:49:25 +00:00
  • aa728d5f4b Document limitation of SPI_execute() using multiple queries in a single string. Bruce Momjian 2007-02-18 01:47:40 +00:00
  • 9f6ed2f47f Update wording: Bruce Momjian 2007-02-18 01:34:35 +00:00
  • 0e461f275b Add: Bruce Momjian 2007-02-18 01:32:55 +00:00
  • 9b9cd9c205 Update "Conflicting lock modes" to show as conflict, add current/requested headings, add link to table from text. Bruce Momjian 2007-02-18 01:21:49 +00:00
  • 49451ae03e Add code so that when COPY_PARSE_PLAN_TREES is defined, the copy and equal functions are checked for raw parse trees as well as post-analysis trees. This was never very important before, but the upcoming plan cache control module will need to be able to do copyObject() on raw parse trees. Tom Lane 2007-02-17 19:33:32 +00:00
  • 4fe1a12c54 Remove rint() for to_char MS and US output. We can't us rint() because we can't overflow to the next higher units, and we might print the lower units for MS. Bruce Momjian 2007-02-17 03:11:32 +00:00
  • 37a22932f2 Add: Bruce Momjian 2007-02-17 02:01:02 +00:00
  • f7a51b7a0d Cleanup of to_char() patch. Bruce Momjian 2007-02-17 01:51:42 +00:00
  • c6ed4ead01 Add: > > o Allow row and record variables to be set to NULL constants, > and allow NULL tests on such variables > > Because a row is not scalar, do not allow assignment > from NULL-valued scalars. Bruce Momjian 2007-02-17 01:35:41 +00:00
  • 0bc81a5b58 Remove installation mention that integer timestamps is less stable that floating point. Bruce Momjian 2007-02-17 01:26:24 +00:00
  • 89a624439e Create AVG() aggregates for int8 and NUMERIC which do not compute X^2, as a performance enhancement. Bruce Momjian 2007-02-17 00:55:58 +00:00
  • 72a070a365 Teach find_nonnullable_rels to handle OR cases: if every arm of an OR forces a particular relation nonnullable, then we can say that the OR does. This is worth a little extra trouble since it may allow reduction of outer joins to plain joins. Tom Lane 2007-02-16 23:32:08 +00:00
  • 46bd3bff62 Add: Bruce Momjian 2007-02-16 22:20:02 +00:00
  • 9f28ac0dd3 Fix new RI operator selection code to do the right thing when working with an opclass for a generic type such as ANYARRAY. The original coding failed to check that PK and FK columns were of the same array type. Per discussion with Tom Dunstan. Also, make the code a shade more readable by not trying to economize on variables. Tom Lane 2007-02-16 22:04:02 +00:00
  • 1d722cf18c Reduce the amount of memory "clobbered" for every process title change, on platforms that need this. This is done by only writing past the previously stored message, if it was longer. Bruce Momjian 2007-02-16 21:34:04 +00:00