4138c38 | Peter Eisentraut | 09 December 2005, 22:16:16 UTC | Translation updates | 09 December 2005, 22:16:16 UTC |
499dad0 | Tom Lane | 09 December 2005, 20:49:38 UTC | Stamp 8.0.5. | 09 December 2005, 20:49:38 UTC |
9e12765 | Tom Lane | 09 December 2005, 20:40:38 UTC | Add release notes for back branches (7.3 and up). Also minor improvements to 8.1.1 release notes. | 09 December 2005, 20:40:38 UTC |
bd760bf | Peter Eisentraut | 08 December 2005, 20:45:26 UTC | Documentation fix: s/event_object_name/event_object_table/g | 08 December 2005, 20:45:26 UTC |
929f852 | Tom Lane | 08 December 2005, 19:19:45 UTC | Fix bgwriter's failure to release buffer pins and open files after an error. This probably explains bug #2099 and could also account for mysterious VACUUM hangups. | 08 December 2005, 19:19:45 UTC |
9a40b55 | Teodor Sigaev | 06 December 2005, 18:22:21 UTC | Fix stupid bug with sizeof | 06 December 2005, 18:22:21 UTC |
7563a16 | Tom Lane | 06 December 2005, 16:50:55 UTC | In a nestloop inner indexscan, it's OK to use pushed-down baserestrictinfo clauses even if it's an outer join. This is a corner case since such clauses could only arise from weird OUTER JOIN ON conditions, but worth fixing. Per example from Ron at cheapcomplexdevices.com. | 06 December 2005, 16:50:55 UTC |
8178871 | Tom Lane | 05 December 2005, 04:14:07 UTC | Add regression test to see if the min/max values of int8 convert correctly. | 05 December 2005, 04:14:07 UTC |
91ab1fe | Tom Lane | 03 December 2005, 20:16:50 UTC | Fix out-of-order inclusion of -L switches from LDFLAGS on AIX and HPUX. Per example from Dirk Pirschel. | 03 December 2005, 20:16:50 UTC |
b0be566 | Tom Lane | 02 December 2005, 23:14:02 UTC | Fix obsolete description of -h option, per Andreas Schmidt. | 02 December 2005, 23:14:02 UTC |
eeae797 | Tom Lane | 01 December 2005, 20:24:49 UTC | Retry in FileRead and FileWrite if Windows returns ERROR_NO_SYSTEM_RESOURCES. Also add a retry for Unixen returning EINTR, which hasn't been reported as an issue but at least theoretically could be. Patch by Qingqing Zhou, some minor adjustments by me. | 01 December 2005, 20:24:49 UTC |
64c09ad | Tom Lane | 01 December 2005, 17:56:54 UTC | Check for overflow in strtol() while parsing datetime inputs. Michael Fuhr. | 01 December 2005, 17:56:54 UTC |
a4a51d5 | Tom Lane | 30 November 2005, 23:10:34 UTC | Rearrange code in pg_atoi() to avoid assuming that isspace() cannot change errno. No reported bugs here, but why take a chance? | 30 November 2005, 23:10:34 UTC |
f9bdaee | Michael Meskes | 30 November 2005, 12:51:07 UTC | - Made several variables "const char *" instead of "char *" as proposed by Qingqing Zhou <zhouqq@cs.toronto.edu>. - Replaced all strdup() calls by ECPGstrdup(). | 30 November 2005, 12:51:07 UTC |
acd3a4f | Tom Lane | 18 November 2005, 23:08:28 UTC | Fix performance issue in exprTypmod(): for a COALESCE expression, it recursed twice on its first argument, leading to exponential time spent on a deep nest of COALESCEs ... such as a deeply nested FULL JOIN would produce. Per report from Matt Carter. | 18 November 2005, 23:08:28 UTC |
f583cbc | Bruce Momjian | 16 November 2005, 03:56:08 UTC | Properly document return value of strpos(). | 16 November 2005, 03:56:08 UTC |
a99f293 | Bruce Momjian | 16 November 2005, 03:44:51 UTC | Update error message and documentation for fsync test. | 16 November 2005, 03:44:51 UTC |
4bc4ce0 | Bruce Momjian | 16 November 2005, 01:34:11 UTC | Update test_fsync to honor -f. Backpatch to 8.0.X. | 16 November 2005, 01:34:11 UTC |
c7d40ff | Tom Lane | 13 November 2005, 19:12:05 UTC | Force the second argument of SUBSTRING(foo FOR bar) to be int4, to avoid surprising results when it's some other numeric type. This doesn't solve the generic problem of surprising implicit casts to text, but it's a low-impact way of making sure this particular case behaves sanely. Per gripe from Harald Fuchs and subsequent discussion. | 13 November 2005, 19:12:05 UTC |
55b5a42 | Tom Lane | 10 November 2005, 00:31:49 UTC | When in transaction-aborted state, reject Bind message for portals containing anything but transaction-exiting commands (ROLLBACK etc). We already rejected Parse and Execute in such cases, so there seems little point in allowing Bind. This prevents at least an Assert failure, and probably worse things, since there's a lot of infrastructure that doesn't work when not in a live transaction. We can also simplify the Bind logic a bit by rejecting messages with a nonzero number of parameters, instead of the former kluge to silently substitute NULL for each parameter. Per bug #2033 from Joel Stevenson. | 10 November 2005, 00:31:49 UTC |
d70d39f | Tom Lane | 09 November 2005, 17:44:22 UTC | Fix misspelling of 'listen_addresses', per Devrim. | 09 November 2005, 17:44:22 UTC |
39edcf5 | Tom Lane | 05 November 2005, 03:05:05 UTC | Repair an error introduced by log_line_prefix patch: it is not acceptable to assume that the string pointer passed to set_ps_display is good forever. There's no need to anyway since ps_status.c itself saves the string, and we already had an API (get_ps_display) to return it. I believe this explains Jim Nasby's report of intermittent crashes in elog.c when %i format code is in use in log_line_prefix. While at it, repair a previously unnoticed problem: on some platforms such as Darwin, the string returned by get_ps_display was blank-padded to the maximum length, meaning that lock.c's attempt to append " waiting" to it never worked. | 05 November 2005, 03:05:05 UTC |
56f68ed | Bruce Momjian | 05 November 2005, 01:36:42 UTC | Backpatch FAQ's for 8.0.X. | 05 November 2005, 01:36:42 UTC |
6d8476a | Tom Lane | 04 November 2005, 18:35:51 UTC | Ensure that we only create one ConsoleCtrlHandler per psql process, so as to avoid performance issues and possible ultimate crash on long psql scripts. Per Merlin Moncure. | 04 November 2005, 18:35:51 UTC |
0c1a3f9 | Teodor Sigaev | 03 November 2005, 18:15:47 UTC | Fix incorrect header size macros | 03 November 2005, 18:15:47 UTC |
09048b9 | Tom Lane | 03 November 2005, 00:23:43 UTC | Fix longstanding race condition in transaction log management: there was a very narrow window in which SimpleLruReadPage or SimpleLruWritePage could think that I/O was needed when it wasn't (and indeed the buffer had already been assigned to another page). This would result in an Assert failure if Asserts were enabled, and probably in silent data corruption if not. Reported independently by Jim Nasby and Robert Creager. I intend a more extensive fix when 8.2 development starts, but this is a reasonably low-impact patch for the existing branches. | 03 November 2005, 00:23:43 UTC |
0622b1d | Andrew Dunstan | 01 November 2005, 15:32:52 UTC | Provide a --no-locale option for pg_regress and a corresponding NOLOCALE=1 setting for the regression makefile, allowing Windows users to force locale settings since Windows does not get its locale from the environment. Per Petr Jelinek. | 01 November 2005, 15:32:52 UTC |
c3d5615 | Bruce Momjian | 26 October 2005, 13:43:28 UTC | Properly update the 'group' flatfile when modifying the user, in case they were added to a group. Also fix visibility of our own changes when creating the group file. This fixes: test=> CREATE GROUP g1; CREATE GROUP test=> CREATE USER u1 IN GROUP g1; CREATE USER test=> \! cat /u/pg/data/global/pg_group "g1" "u1" test=> CREATE USER u2 IN GROUP g1; CREATE USER test=> \! cat /u/pg/data/global/pg_group "g1" "u1" "u2" test=> ALTER USER u2 RENAME TO u3; ALTER USER test=> \! cat /u/pg/data/global/pg_group "g1" "u1" "u3" [ this code does not exist in CVS head.] Per report from Dennis Vshivkov | 26 October 2005, 13:43:28 UTC |
8f03406 | Bruce Momjian | 26 October 2005, 13:20:47 UTC | Update AIX FAQ, backpatch. | 26 October 2005, 13:20:47 UTC |
15b46f1 | Tom Lane | 25 October 2005, 20:30:35 UTC | Fix longstanding bug that would sometimes let the planner generate a bad plan for an outer join; symptom is bogus error "RIGHT JOIN is only supported with merge-joinable join conditions". Problem was that select_mergejoin_clauses did its tests in the wrong order. We need to force left join not right join for a merge join when there are non-mergeable join clauses; but the test for this only accounted for mergejoinability of the clause operator, and not whether the left and right Vars were of the proper relations. Per report from Jean-Pierre Pelletier. | 25 October 2005, 20:30:35 UTC |
ea19eb9 | Tom Lane | 20 October 2005, 20:06:03 UTC | Postpone pg_timezone_initialize() until after creation of postmaster.pid, since it can take a fair amount of time and this can confuse boot scripts that expect postmaster.pid to appear quickly. Move initialization of SSL library and preloaded libraries to after that point, too, just for luck. Per reports from Tony Caduto and others. | 20 October 2005, 20:06:03 UTC |
0929009 | Tom Lane | 20 October 2005, 16:14:39 UTC | Prevent core dump in contrib version of autovacuum when a table has been dropped. Per report from daveg (not his patch, though). | 20 October 2005, 16:14:39 UTC |
fd5efff | Tom Lane | 19 October 2005, 22:51:26 UTC | Back-patch fix for proper labeling of whole-row Datums generated from subquery results. | 19 October 2005, 22:51:26 UTC |
98658dd | Tom Lane | 14 October 2005, 16:41:13 UTC | Pass a strdup'd ident string to openlog(), to ensure that reallocation of GUC memory doesn't cause us to start emitting a bogus ident string. Per report from Han Holl. Also some trivial code cleanup in write_syslog. | 14 October 2005, 16:41:13 UTC |
7df6dfd | Bruce Momjian | 14 October 2005, 01:50:23 UTC | [ Backpatch to 8.0.X.] Also I fixed a bug in a bug fix I committed a few weeks ago. he check for a varchar pointer was incomplete. Michael Meskes | 14 October 2005, 01:50:23 UTC |
00de66a | Tom Lane | 12 October 2005, 17:18:15 UTC | Fix longstanding bug found by Atsushi Ogawa: _bt_check_unique would mark the wrong buffer dirty when trying to kill a dead index entry that's on a page after the one it started on. No risk of data corruption, just inefficiency, but still a bug. | 12 October 2005, 17:18:15 UTC |
592ca3c | Neil Conway | 11 October 2005, 22:59:11 UTC | Fix typo in sample pg_hba.conf; per IRC report from Bernhard Neuhauser. | 11 October 2005, 22:59:11 UTC |
d30c134 | Tom Lane | 11 October 2005, 16:45:00 UTC | Fix oversight in 8.0 modification of RestrictInfo data structures. A RestrictInfo representing an OR clause now contains two versions of the contained expression, one with sub-RestrictInfos and one without. clause_selectivity() should descend to the version with sub-RestrictInfos so that it has a chance of caching its results for the OR's sub-clauses. Failing to do so resulted in redundant planner effort. | 11 October 2005, 16:45:00 UTC |
20f5a32 | Neil Conway | 06 October 2005, 21:21:27 UTC | Backpatch merge_db() example for PL/PgSQL to 8.0. Patch from David Fetter, fixes by Neil Conway. | 06 October 2005, 21:21:27 UTC |
ce150c4 | Bruce Momjian | 05 October 2005, 11:51:27 UTC | Update Japanese FAQ. Jun Kuwamura | 05 October 2005, 11:51:27 UTC |
b0db380 | Bruce Momjian | 05 October 2005, 11:27:10 UTC | Update version number in faq. | 05 October 2005, 11:27:10 UTC |
2a3f44b | Bruce Momjian | 04 October 2005, 14:18:43 UTC | Update FAQ's in 8.0.X branch. (very small changes) | 04 October 2005, 14:18:43 UTC |
610a7c6 | Bruce Momjian | 04 October 2005, 14:17:44 UTC | Add FAQ_hungarian.html to 8.0.X branch. | 04 October 2005, 14:17:44 UTC |
3dfec7f | Tom Lane | 03 October 2005, 23:43:29 UTC | COPY's test for read-only transaction was backward; it prohibited COPY TO where it should prohibit COPY FROM. Found by Alon Goldshuv. | 03 October 2005, 23:43:29 UTC |
73a71f5 | Tom Lane | 03 October 2005, 17:07:18 UTC | Stamp release 8.0.4. | 03 October 2005, 17:07:18 UTC |
65ae842 | Tom Lane | 03 October 2005, 16:04:51 UTC | Update release notes for pending back-branch releases. | 03 October 2005, 16:04:51 UTC |
e168406 | Tom Lane | 03 October 2005, 02:45:25 UTC | Preserve tuple OIDs during ATRewriteTable. Per gripe from Duncan Crombie. | 03 October 2005, 02:45:25 UTC |
7aef1bf | Tom Lane | 28 September 2005, 21:17:24 UTC | Repair planning bug introduced in 7.4: outer-join ON clauses that referenced only the inner-side relation would be considered as potential equijoin clauses, which is wrong because the condition doesn't necessarily hold above the point of the outer join. Per test case from Kevin Grittner (bug#1916). | 28 September 2005, 21:17:24 UTC |
92cdd00 | Alvaro Herrera | 28 September 2005, 13:11:00 UTC | Translation updates for the 8.0 branch | 28 September 2005, 13:11:00 UTC |
0326d70 | Bruce Momjian | 28 September 2005, 11:33:42 UTC | Update Russian FAQ. Victor Vislobokov | 28 September 2005, 11:33:42 UTC |
341c339 | Bruce Momjian | 23 September 2005, 21:02:37 UTC | Backpatch to 8.0.X: In several places PL/Python was calling PyObject_Str() and then PyString_AsString() without checking if the former had returned NULL to indicate an error. PyString_AsString() doesn't expect a NULL argument, so passing one causes a segmentation fault. This patch adds checks for NULL and raises errors via PLy_elog(), which prints details of the underlying Python exception. The patch also adds regression tests for these checks. All tests pass on my Solaris 9 box running HEAD and Python 2.4.1. | 23 September 2005, 21:02:37 UTC |
9516724 | Bruce Momjian | 22 September 2005, 22:14:11 UTC | Update FAQ's in 8.0.X branch. | 22 September 2005, 22:14:11 UTC |
b3af584 | Bruce Momjian | 20 September 2005, 18:59:15 UTC | Return proper value for psql -f filename failure if filename open fails. Backpatch to 8.0.X. | 20 September 2005, 18:59:15 UTC |
b4d107a | Teodor Sigaev | 15 September 2005, 11:56:58 UTC | Update Snowball. I have to update it because of old version doesn't available on Snowball's site and new version of stemmers can't be compiled with old interface. | 15 September 2005, 11:56:58 UTC |
8080e8e | Tom Lane | 12 September 2005, 22:20:30 UTC | Ensure that any memory leaked during an error inside the bgwriter is recovered. I did not see any actual leak while testing this in CVS tip, but 8.0 definitely has a problem with leaking the space temporarily palloc'd by BufferSync(). In any case this seems a good idea to forestall similar problems in future. Per report from Arjen van der Meijden. | 12 September 2005, 22:20:30 UTC |
3926b6e | Neil Conway | 12 September 2005, 18:49:08 UTC | Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr. | 12 September 2005, 18:49:08 UTC |
39f2746 | Michael Meskes | 12 September 2005, 11:58:33 UTC | Fixed transaction command handling to not ignore savepoints and to correctly check for errors. | 12 September 2005, 11:58:33 UTC |
3e71145 | Tom Lane | 11 September 2005, 00:36:35 UTC | Avoid changing stdin/stdout to binary mode on Windows unless that is really the source or destination of the archive. I think this will resolve recent complaints that password prompting is broken in pg_restore on Windows. Note that password prompting and reading from stdin is an unworkable combination on Windows ... but that was true anyway. | 11 September 2005, 00:36:35 UTC |
16acb8b | Tom Lane | 08 September 2005, 16:49:18 UTC | Update regression tests for new USA timezone data. Mea culpa for not realizing that the regression tests could be affected. | 08 September 2005, 16:49:18 UTC |
694da28 | Tom Lane | 07 September 2005, 21:39:41 UTC | Update timezone data files to release 2005m of the zic database. Among other changes, this reflects the recently passed change in USA daylight savings rules. | 07 September 2005, 21:39:41 UTC |
57fd3d2 | Peter Eisentraut | 03 September 2005, 07:41:58 UTC | Translation update | 03 September 2005, 07:41:58 UTC |
13ff51b | Teodor Sigaev | 30 August 2005, 07:57:48 UTC | Fix missing rows in query update a=.. where a... with GiST index on column 'a' | 30 August 2005, 07:57:48 UTC |
846ed05 | Tom Lane | 29 August 2005, 00:41:44 UTC | Sigh, looks like you need '.set mips2' before you can access MIPS SYNC instruction. | 29 August 2005, 00:41:44 UTC |
9f70dce | Tom Lane | 28 August 2005, 18:26:07 UTC | Add a SYNC instruction to the S_UNLOCK sequence for MIPS. | 28 August 2005, 18:26:07 UTC |
5677c28 | Tom Lane | 27 August 2005, 16:22:58 UTC | Get the MIPS assembler syntax right. Also add a separate sync command; the reference I consulted yesterday said SC does a SYNC, but apparently this is not true on newer MIPS processors, so be safe. | 27 August 2005, 16:22:58 UTC |
9a6f363 | Bruce Momjian | 27 August 2005, 14:13:31 UTC | Fix typo: sql_information_info -> sql_implementation_info Robert Treat | 27 August 2005, 14:13:31 UTC |
51aebb0 | Tom Lane | 26 August 2005, 22:04:53 UTC | Another try at the inlined MIPS spinlock code. Can't test this myself, but for sure it's not any more broken than the prior version. | 26 August 2005, 22:04:53 UTC |
8c3cf25 | Tom Lane | 26 August 2005, 14:48:13 UTC | Back-port recent MIPS and M68K spinlock improvements to 8.0 branch. | 26 August 2005, 14:48:13 UTC |
08e12b8 | Tom Lane | 25 August 2005, 19:45:06 UTC | Back-patch fixes for problems with VACUUM destroying t_ctid chains too soon, and with insufficient paranoia in code that follows t_ctid links. This patch covers the 8.0 branch. | 25 August 2005, 19:45:06 UTC |
5576a61 | Michael Meskes | 24 August 2005, 10:35:12 UTC | - Check for NULL before checking whether argument is an array. - Removed stray character from string quoting. - Fixed check to report missing varchar pointer implementation. | 24 August 2005, 10:35:12 UTC |
9b4296a | Tom Lane | 23 August 2005, 13:31:19 UTC | Fix broken lrand48() implementation, per Merlin Moncure. | 23 August 2005, 13:31:19 UTC |
01bc28d | Tom Lane | 20 August 2005, 19:19:31 UTC | Invoke mksafefunc and mkunsafefunc with :: decoration. This seems a good idea on consistency grounds, whether or not it really fixes bug #1831. Michael Fuhr | 20 August 2005, 19:19:31 UTC |
f468542 | Tom Lane | 17 August 2005, 20:20:22 UTC | Remove unnecessary configure test for inet_ntop(), per Andrew Dunstan. | 17 August 2005, 20:20:22 UTC |
96fc1a4 | Tom Lane | 16 August 2005, 00:48:29 UTC | Reject operator names >= NAMEDATALEN characters. These will not work anyway, and in assert-enabled builds you are likely to get an assertion failure. Backpatch as far as 7.3; 7.2 seems not to have the problem. | 16 August 2005, 00:48:29 UTC |
ab64863 | Tom Lane | 15 August 2005, 19:40:43 UTC | array_in() and array_recv() need to be more paranoid about validating their OID parameter. It was possible to crash the backend with select array_in('{123}',0,0); because that would bypass the needed step of initializing the workspace. These seem to be the only two places with a problem, though (record_in and record_recv don't have the issue, and the other array functions aren't depending on user-supplied input). Back-patch as far as 7.4; 7.3 does not have the bug. | 15 August 2005, 19:40:43 UTC |
497f118 | Tom Lane | 15 August 2005, 19:05:30 UTC | int_array_enum function should be using fcinfo->flinfo->fn_extra for working state, not fcinfo->context. Silly oversight on my part in last go-round of fixes. | 15 August 2005, 19:05:30 UTC |
0c9f005 | Bruce Momjian | 12 August 2005, 21:38:00 UTC | This patch fixes the event type used to log output from the stderr-in-service or output-from-syslogger-in-service code. Previously everything was flagged as ERRORs there, which caused all instances to log "LOG: logger shutting down" as error... Please apply for 8.1. I'd also like it considered for 8.0 since logging non-errors as errors can be cause for alarm amongst people who actually look at their logs... Magnus Hagander | 12 August 2005, 21:38:00 UTC |
18b15c3 | Bruce Momjian | 12 August 2005, 21:23:18 UTC | [ backpatched to 8.0.X.] > >> 3) I restarted the postmaster both times. I got this error > both times. > >> :25: ERROR: could not load library "C:/Program > >> Files/PostgreSQL/8.0/lib/testtrigfuncs.dll": dynamic load error > > > Yes. We really need to look at fixing that error message. I had > > forgotten it completely :-( > > > Bruce, you think we can sneak that in after feature freeze? I would > > call it a bugfix :-) > > Me too. That's been on the radar for awhile --- please do > send in a patch. Here we go, that wasn't too hard :-) Apart from adding the error handling, it does one more thing: it changes the errormode when loading the DLLs. Previously if a DLL was broken, or referenced other DLLs that couldn't be found, a popup dialog box would appear on the screen. Which had to be clicked before the backend could continue. This patch also disables the popup error message for DLL loads. I think this is something we should consider doing for the entire backend - disable those popups, and say we deal with it ourselves. What do you other win32 hackers thinnk about this? In the meantime, this patch fixes the error msgs. Please apply for 8.1 and please consider a backpatch to 8.0. Magnus Hagander | 12 August 2005, 21:23:18 UTC |
66c2f44 | Bruce Momjian | 12 August 2005, 00:29:22 UTC | Backpatch fseeko fix for seeking from end of file. | 12 August 2005, 00:29:22 UTC |
18e6159 | Bruce Momjian | 11 August 2005, 13:54:10 UTC | Backpatch new CVS home page URL. | 11 August 2005, 13:54:10 UTC |
1c09a3c | Tom Lane | 08 August 2005, 23:39:14 UTC | Fix crash when reading 'timezone = unknown' from postgresql.conf during SIGHUP; it's not OK for an assign_hook to return a non-malloc'd string. Problem was introduced during timezone library rewrite. | 08 August 2005, 23:39:14 UTC |
4cf0fea | Tom Lane | 07 August 2005, 18:47:38 UTC | Fix count_usable_fds() to stop trying to open files once it reaches max_files_per_process. Going further than that is just a waste of cycles, and it seems that current Cygwin does not cope gracefully with deliberately running the system out of FDs. Per Andrew Dunstan. | 07 August 2005, 18:47:38 UTC |
668448d | Tom Lane | 02 August 2005, 15:14:56 UTC | rmtree() reported the wrong pathname if final rmdir failed. | 02 August 2005, 15:14:56 UTC |
ae1d34f | Tom Lane | 02 August 2005, 01:35:23 UTC | Back-port several small portability fixes to get contrib building cleanly on AIX in the 8.0 branch. Rocco Altier | 02 August 2005, 01:35:23 UTC |
61dc3df | Bruce Momjian | 30 July 2005, 03:39:40 UTC | Update AIX FAQ. Chris Browne | 30 July 2005, 03:39:40 UTC |
81f2d97 | Tom Lane | 29 July 2005, 21:40:26 UTC | Back-patch fix for NOT-below-a-NOT case. | 29 July 2005, 21:40:26 UTC |
f4bbe13 | Neil Conway | 27 July 2005, 05:15:03 UTC | Avoid crashing pg_dump if we can't connect to the database server, and no database has been explicitly specified. Per gripe from Omar Kilani. | 27 July 2005, 05:15:03 UTC |
4ee7e82 | Tom Lane | 22 July 2005, 19:12:33 UTC | Fix compare_fuzzy_path_costs() to behave a bit more sanely. The original coding would ignore startup cost differences of less than 1% of the estimated total cost; which was OK for normal planning but highly not OK if a very small LIMIT was applied afterwards, so that startup cost becomes the name of the game. Instead, compare startup and total costs fuzzily but independently. This changes the plan selected for two queries in the regression tests; adjust expected-output files for resulting changes in row order. Per reports from Dawid Kuroczko and Sam Mason. | 22 July 2005, 19:12:33 UTC |
ea72596 | Tom Lane | 18 July 2005, 21:37:23 UTC | It appears that Darwin (OS X) does not cope well with C functions that have the same name as the containing shared library --- as best I can tell, the compiler internally creates a function of that name, and does not warn you about the conflict. Fix buildfarm failure in back branches by renaming tsearch() trigger function at the C level. | 18 July 2005, 21:37:23 UTC |
2486a88 | Tom Lane | 18 July 2005, 19:18:19 UTC | Back-patch fix for erroneous backslashing of LIKE pattern. | 18 July 2005, 19:18:19 UTC |
183b1bf | Tom Lane | 18 July 2005, 15:53:46 UTC | MemSet() must not cast its pointer argument to int32* until after it has checked that the pointer is actually word-aligned. Casting a non-aligned pointer to int32* is technically illegal per the C spec, and some recent versions of gcc actually generate bad code for the memset() when given such a pointer. Per report from Andrew Morrow. | 18 July 2005, 15:53:46 UTC |
f6cb719 | Tom Lane | 17 July 2005, 18:29:13 UTC | Make pg_regress accept a command-line option for the temporary installation's port number, and use a default value for it that is dependent on the configuration-time DEF_PGPORT. Should make the world safe for running parallel 'make check' in different branches. Back-patch as far as 7.4 so that this actually is useful. | 17 July 2005, 18:29:13 UTC |
091c97f | Tom Lane | 17 July 2005, 04:05:49 UTC | Back-patch recent changes to alter the order of -L flags inserted from LDFLAGS versus those built into the Makefiles. This looks like it will fix several buildfarm failures in the back branches. | 17 July 2005, 04:05:49 UTC |
123e25b | Tom Lane | 15 July 2005, 18:40:20 UTC | Check for out-of-range varoattno in deparse_context_for_subplan. I have seen this case in CVS tip due to new "physical tlist" optimization for subqueries. I believe it probably can't happen in existing releases, but the check is not going to hurt anything, so backpatch to 8.0 just in case. | 15 July 2005, 18:40:20 UTC |
1e31942 | Tom Lane | 15 July 2005, 17:09:50 UTC | Fix overenthusiastic optimization of 'x IN (SELECT DISTINCT ...)' and related cases: we can't just consider whether the subquery's output is unique on its own terms, we have to check whether the set of output columns we are going to use will be unique. Per complaint from Luca Pireddu and test case from Michael Fuhr. | 15 July 2005, 17:09:50 UTC |
35a0fc3 | Tom Lane | 13 July 2005, 15:26:06 UTC | Fix libpq memory leak during PQreset() --- closePGconn() was not freeing all transient state of the PGconn object. | 13 July 2005, 15:26:06 UTC |
18e64f6 | Tom Lane | 08 July 2005, 18:41:55 UTC | Fix config file lexer to not barf if postgresql.conf ends with a comment that has no terminating newline. Per report from maps.on at gmx.net. | 08 July 2005, 18:41:55 UTC |
a646e48 | Tom Lane | 08 July 2005, 15:24:53 UTC | Make libpq_gettext save and restore errno in a Windows-compatible way. Also, back-patch fix into back branches. | 08 July 2005, 15:24:53 UTC |
75aed9f | Bruce Momjian | 04 July 2005, 14:42:39 UTC | Backpatch to 8.0.X openssl portability fixes to pgcrypto. | 04 July 2005, 14:42:39 UTC |
0a056c3 | Bruce Momjian | 04 July 2005, 14:12:45 UTC | Fix date_trunct for December dates that are in the next year, e.g.: SELECT date_trunc('week', '2002-12-31'::date); Backpatch to 8.0.X. Per report from Nick Johnson. | 04 July 2005, 14:12:45 UTC |