summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2004-01-24Fix problems with dropped columns in pltcl triggers, per report from Patrick ↵Tom Lane
Samson.
2004-01-24Example of a function taking a composite type should show how to call it.Tom Lane
2004-01-23Revise GEQO planner to make use of some heuristic knowledge about SQL, namelyTom Lane
that it's good to join where there are join clauses rather than where there are not. Also enable it to generate bushy plans at need, so that it doesn't fail in the presence of multiple IN clauses containing sub-joins. These changes appear to improve the behavior enough that we can substantially reduce the default pool size and generations count, thereby decreasing the runtime, and yet get as good or better plans as we were getting in 7.4. Consequently, adjust the default GEQO parameters. I also modified the way geqo_effort is used so that it affects both population size and number of generations; it's now useful as a single control to adjust the GEQO runtime-vs-plan-quality tradeoff. Bump geqo_threshold to 12, since even with these changes GEQO seems to be slower than the regular planner at 11 relations.
2004-01-23Add MySQL mention of licensing difference.Bruce Momjian
2004-01-22Minor improvements to the trigger documentation, and a few SGML fixes.Neil Conway
2004-01-21Repair error apparently introduced in the initial coding of GUC: theTom Lane
default value for geqo_effort is supposed to be 40, not 1. The actual 'genetic' component of the GEQO algorithm has been practically disabled since 7.1 because of this mistake. Improve documentation while at it.
2004-01-20Implement '\copy from -' to support reading copy data from the sameTom Lane
source the \copy came from. Also, fix prompting logic so that initial and per-line prompts appear for all cases of reading from an interactive terminal. Patch by Mark Feit, with some kibitzing by Tom Lane.
2004-01-20Remove no-longer-relevant note about forcing the type of an integerTom Lane
constant. Per Kris Jurka.
2004-01-20This is a patch to support readline prompts which contain non-printingTom Lane
characters, as for fancy colorized prompts. This was nearly a direct lift from bash-2.05b's lib/readline/display.c, per guidance from Chet Ramey. Reece Hart
2004-01-19Remove JDBC from the build system and documentation, too.Tom Lane
2004-01-19Improve discussion of consistent-snapshot backup technique. HaphazardTom Lane
editing of this text had left nearly contradictory statements in adjacent paragraphs ...
2004-01-15Some refinement of XSLT processing: The result now looks just about as goodPeter Eisentraut
as the result of the SGML-based tool chain.
2004-01-13Make rule and stylesheet to try out XSLT for DocBook processingPeter Eisentraut
2004-01-11Put See Also links back in alphabetical order.Peter Eisentraut
2004-01-11Minor documentation improvements.Neil Conway
2004-01-11Add CREATE TRIGGER, CREATE INDEX, and CREATE SEQUENCE to the list ofNeil Conway
expressions supported by CREATE SCHEMA. Also added the beginning of some regression tests for CREATE SCHEMA; plenty more work is needed here.
2004-01-10Implement "WITH / WITHOID OIDS" clause for CREATE TABLE AS. This isNeil Conway
intended to allow application authors to insulate themselves from changes to the default value of 'default_with_oids' in future releases of PostgreSQL. This patch also fixes a bug in the earlier implementation of the 'default_with_oids' GUC variable: code in gram.y should not examine the value of GUC variables directly due to synchronization issues.
2004-01-10Allow BEGIN WORK to specify transaction isolation level, like STARTBruce Momjian
TRANSACTION.
2004-01-09Allow libpq to do thread-safe SIGPIPE handling. This allows it toBruce Momjian
ignore SIGPIPE from send() in libpq, but terminate on any other SIGPIPE, unless the user installs their own signal handler. This is a minor fix because the only time you get SIGPIPE from libpq's send() is when the backend dies.
2004-01-09German FAQ update.Bruce Momjian
Ian Barwick
2004-01-08Update Russian FAQ.Bruce Momjian
Viktor Vislobokov
2004-01-06Apply the core parts of Dennis Bjorklund's patch to allow functionTom Lane
parameters to be declared with names. pg_proc has a column to store names, and CREATE FUNCTION can insert data into it, but that's all as yet. I need to do more work on the pg_dump and plpgsql portions of the patch before committing those, but I thought I'd get the bulky changes in before the tree drifts under me. initdb forced due to pg_proc change.
2004-01-06Favor Freenode rather than EFnet in IRC listing. Freenode is more popular.Bruce Momjian
2004-01-06Make the 'wal_debug' GUC variable a boolean (rather than an integer), andNeil Conway
hide it behind #ifdef WAL_DEBUG blocks.
2004-01-05Remove an old and out-of-date SGML comment from this file: we alreadyNeil Conway
have WAL, outer joins, and TOAST.
2004-01-05Fix (yet another) instance of incorrect markup for a GUC variable.Neil Conway
2004-01-05Update for 7.4.1 as newest version.Bruce Momjian
2004-01-04Correct gettext URL.Peter Eisentraut
2003-12-30Recommend SHOW, instead of pg_controldata, for checking LC_COLLATE andTom Lane
LC_CTYPE settings of a database.
2003-12-26Be a little more consistent about which terms are uppercased inTom Lane
index entries.
2003-12-26Fixed docs to clearly note that ecpg is originally a C precompiler and C++ ↵Michael Meskes
stuff is not 100%.
2003-12-25> > I have no idea if this in Oracle or not. But it's something IBruce Momjian
> > needed, and other people in the past asked about it too. > > It is in Oracle, but you aren't exactly on the spot. It should be > > IYYY - 4 digits ('2003') > IYY - 3 digits ('003') > IY - 2 digits ('03') > I - 1 digit ('3') Here is an updated patch that does that. Kurt Roeckx
2003-12-23Supress non-temp schemas from psql \dn display.Bruce Momjian
2003-12-23Mop-up for HAS_TEST_AND_SET refactoring. Un-break two or three platformsTom Lane
that were broken, try to make layout of s_lock.h entries consistent, use HAVE_SPINLOCKS in preference to HAS_TEST_AND_SET everywhere outside s_lock.h itself.
2003-12-21Fix broken markup, adjust 7.4.1 release date, re-sync HEAD with branch.Tom Lane
2003-12-21Update 7.4.1 release notes in preparation for release.Bruce Momjian
2003-12-21Back out:Bruce Momjian
> Attached is a patch that addressed all the discussed issues > that did not break backward compatability, including the > ability to output ISO-8601 compliant intervals by setting > datestyle to iso8601basic.
2003-12-20Another markup fix for recent patch.Bruce Momjian
2003-12-20Fix broken markup.Bruce Momjian
2003-12-20In my mind there were two categories of open issuesBruce Momjian
a) ones that are 100% backward (such as the comment about outputting this format) and b) ones that aren't (such as deprecating the current postgresql shorthand of '1Y1M'::interval = 1 year 1 minute in favor of the ISO-8601 'P1Y1M'::interval = 1 year 1 month. Attached is a patch that addressed all the discussed issues that did not break backward compatability, including the ability to output ISO-8601 compliant intervals by setting datestyle to iso8601basic. Interval values can now be written as ISO 8601 time intervals, using the "Format with time-unit designators". This format always starts with the character 'P', followed by a string of values followed by single character time-unit designators. A 'T' separates the date and time parts of the interval. Ron Mayer
2003-12-197.4.1 release note improvementsPeter Eisentraut
2003-12-18Please find enclosed a patch exemplifying typical use of the AREBruce Momjian
Class-Shorthand Escapes<C2><AE>. I believe it will help intrepid regex users. :) David Fetter
2003-12-17Restore information schema upgrade instructions of Peter.Bruce Momjian
2003-12-16Add example for converting epoch back to timestamp.Peter Eisentraut
2003-12-16Mention ecpg SET CONNECTION is not thread-aware.Bruce Momjian
2003-12-15Override some of the changes in DocBook DSSSL stylesheets 1.78 to restorePeter Eisentraut
previous behavior of <literal>, <envar>, <acronym>, and others.
2003-12-15Update HISTORY and release notes for 7.4.1.Bruce Momjian
2003-12-14Fix two typos in the documentation for PREPARE.Neil Conway
2003-12-14This patch fixes a few more uppercase GUC vars. I also removed anNeil Conway
example from the RESET reference page because it seemed completely redundant.
2003-12-14This patch makes some improvements and adds some additional detailNeil Conway
to the documentation on routine database maintainence activities. I also corrected a bunch of SGML markup.
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-07 12:42:30 +0000