aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Fix machine-dependent crash in sqlchar_to_unicode(). Get rid ofTom Lane2006-12-24
| | | | | | | bletcherous and unsafe manipulation of global encoding setting. Clean up libxml reporting mechanism a bit (it still looks like a dangling-pointer crash waiting to happen, though, not to mention being far less than sane from a localization standpoint).
* Code review for XML patch. Instill a bit of sanity in the location ofTom Lane2006-12-24
| | | | | | | the XmlExpr code in various lists, use a representation that has some hope of reverse-listing correctly (though it's still a de-escaping function shy of correctness), generally try to make it look more like Postgres coding conventions.
* Suppress various compiler warnings in new xml code.Tom Lane2006-12-23
|
* Remove unnecessary parentheses in if() statements.Bruce Momjian2006-12-23
|
* Change a VACUUM manual page word from 'deleted' to 'expired', so DELETEBruce Momjian2006-12-23
| | | | and UPDATE are clearly covered by the term.
* Document that CREATE TYPE names should not begin with an underscore,Bruce Momjian2006-12-23
| | | | rather than being disallowed.
* For GUC values, check for partial string matches on 'on' and 'off', butBruce Momjian2006-12-23
| | | | | | require at least two characters for uniqueness. This now matches the behavior of other boolean strings we support, per report from Gurjeet Singh.
* Restructure operator classes to allow improved handling of cross-data-typeTom Lane2006-12-23
| | | | | | | | | | | | | | | | cases. Operator classes now exist within "operator families". While most families are equivalent to a single class, related classes can be grouped into one family to represent the fact that they are semantically compatible. Cross-type operators are now naturally adjunct parts of a family, without having to wedge them into a particular opclass as we had done originally. This commit restructures the catalogs and cleans up enough of the fallout so that everything still works at least as well as before, but most of the work needed to actually improve the planner's behavior will come later. Also, there are not yet CREATE/DROP/ALTER OPERATOR FAMILY commands; the only way to create a new family right now is to allow CREATE OPERATOR CLASS to make one by default. I owe some more documentation work, too. But that can all be done in smaller pieces once this infrastructure is in place.
* Add a link to the developer's FAQ for my article about how companies canBruce Momjian2006-12-22
| | | | work effectively with open source communities.
* Slight adjustments to xml documentation to reflect functionality justBruce Momjian2006-12-22
| | | | added.
* Fix expected file.Peter Eisentraut2006-12-21
|
* Catalog version bump for SQL/XML changes.Peter Eisentraut2006-12-21
|
* Fix convertion for 'PFX flag N num'Teodor Sigaev2006-12-21
|
* Initial SQL/XML support: xml data type and initial set of functions.Peter Eisentraut2006-12-21
|
* 8.3 release schedule is year 2007, not 2006.Bruce Momjian2006-12-20
|
* Add timeline for next release to developer's FAQ.Bruce Momjian2006-12-19
|
* Item done.Bruce Momjian2006-12-19
| | | | | < o Improve xid wraparound detection by recording per-table rather < than per-database
* Interpret a dbName param to PQsetdbLogin as a conninfo string if it contains ↵Andrew Dunstan2006-12-19
| | | | an = sign. Tom Lane and Andrew Dunstan.
* Set pg_am.amstrategies to zero for index AMs that don't have fixedTom Lane2006-12-18
| | | | | | | operator strategy numbers, ie, GiST and GIN. This is almost cosmetic enough to not need a catversion bump, but since the opr_sanity regression test has to change in sync with the catalog entry, I figured I'd better do one.
* fix thinko in placement of TimeValStruct typedef in Windows case, as ↵Andrew Dunstan2006-12-18
| | | | reported by Magnus.
* Fix typo:Bruce Momjian2006-12-17
| | | | | < While PostgreSQL clients runs fine limited-resource environments, the > While PostgreSQL clients runs fine in limited-resource environments, the
* Move entry into CLUSTER section:Bruce Momjian2006-12-17
| | | | | < * Make CLUSTER preserve recently-dead tuples per MVCC requirements > o Make CLUSTER preserve recently-dead tuples per MVCC requirements
* enable \timing oputput for \copy commandsAndrew Dunstan2006-12-16
|
* Fix some planner bugs exposed by reports from Arjen van der Meijden. TheseTom Lane2006-12-15
| | | | | | | | | | | | | | | | | | | | | | | | are all in new-in-8.2 logic associated with indexability of ScalarArrayOpExpr (IN-clauses) or amortization of indexscan costs across repeated indexscans on the inside of a nestloop. In particular: Fix some logic errors in the estimation for multiple scans induced by a ScalarArrayOpExpr indexqual. Include a small cost component in bitmap index scans to reflect the costs of manipulating the bitmap itself; this is mainly to prevent a bitmap scan from appearing to have the same cost as a plain indexscan for fetching a single tuple. Also add a per-index-scan-startup CPU cost component; while prior releases were clearly too pessimistic about the cost of repeated indexscans, the original 8.2 coding allowed the cost of an indexscan to effectively go to zero if repeated often enough, which is overly optimistic. Pay some attention to index correlation when estimating costs for a nestloop inner indexscan: this is significant when the plan fetches multiple heap tuples per iteration, since high correlation means those tuples are probably on the same or adjacent heap pages.
* Put JST back into the default set of timezone abbreviations;Tom Lane2006-12-15
| | | | was removed in an unexplainable moment of brain fade.
* Back out double-run of PDF/PS output. Requires building bookindex.sgmlBruce Momjian2006-12-15
| | | | | | | | | properly. Remove SGML docs about openjade performance patch, and instead add comment in style sheet where indenting code is commented out. Backpatch to 8.2.X.
* TODO item not wanted:Bruce Momjian2006-12-15
| | | | | | | | | | | > > * Embedded server (not wanted) > > While PostgreSQL clients runs fine limited-resource environments, the > server requires multiple processes and a stable pool of resources to > run reliabily and efficiently. Stripping down the PostgreSQL server > to run in the same process address space as the client application > would add too much complexity and failure cases.
* Link to summary XML email, rather than thread top:Bruce Momjian2006-12-15
| | | | | | | < * Consider changing documentation from SGML to XML > * Consider changing documentation format from SGML to XML < http://archives.postgresql.org/pgsql-docs/2006-12/msg00033.php > http://archives.postgresql.org/pgsql-docs/2006-12/msg00152.php
* Document issues for SGML and XML:Bruce Momjian2006-12-15
| | | | | | | | > > * Consider changing documentation from SGML to XML > > http://archives.postgresql.org/pgsql-docs/2006-12/msg00033.php >
* Document patch needed to get PDF and PS output in a reasonable amount ofBruce Momjian2006-12-15
| | | | time.
* Remove unneeded tab in file.Bruce Momjian2006-12-15
|
* Run Jade twice when outputting Postscript and PDF so the index isBruce Momjian2006-12-15
| | | | | | correct, add comments about other multiple runs in the Makefile. Backpatch to 8.2.X.
* Make --with-ldap build on Unixware, per Olivier Prenant.Tom Lane2006-12-14
|
* Remove Windows port^W^Wobsolete template file.Peter Eisentraut2006-12-14
|
* Activate WIN32_STACK_RLIMIT override only on platforms where this isPeter Eisentraut2006-12-14
| | | | necessary.
* Put back yet another improperly-removed #include, per Mark Kirkwood.Tom Lane2006-12-13
|
* Update entry:Bruce Momjian2006-12-12
| | | | | | < * Have EXPLAIN ANALYZE highlight poor optimizer estimates > * Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and > actual row counts differ by a specified percentage
* Fix planner to do the right thing when a degenerate outer join (one whoseTom Lane2006-12-12
| | | | | | | joinclause doesn't use any outer-side vars) requires a "bushy" plan to be created. The normal heuristic to avoid joins with no joinclause has to be overridden in that case. Problem is new in 8.2; before that we forced the outer join order anyway. Per example from Teodor.
* Document that log_line_prefix %t does not print timezone on Win32.Bruce Momjian2006-12-12
|
* Oops, removed:Bruce Momjian2006-12-12
| | | | < * Allow REINDEX CONCURRENTLY
* Add:Bruce Momjian2006-12-12
| | | | > * Allow REINDEX CONCURRENTLY
* Allow augmenting CPPFLAGS from the configure command line. This generallyPeter Eisentraut2006-12-12
| | | | works, but some platform templates overwrote it without asking.
* Remove blank lines in HTML FAQ.Bruce Momjian2006-12-11
|
* Add FAQ entry to mention using COALESCE() for concatenation of possibleBruce Momjian2006-12-11
| | | | NULLs.
* Add a paramtypmod field to Param nodes. This is dead weight for ParamsTom Lane2006-12-10
| | | | | | | | | | representing externally-supplied values, since the APIs that carry such values only specify type not typmod. However, for PARAM_SUBLINK Params it is handy to carry the typmod of the sublink's output column. This is a much cleaner solution for the recently reported 'could not find pathkey item to sort' and 'failed to find unique expression in subplan tlist' bugs than my original 8.2-compatible patch. Besides, someday we might want to support typmods for external parameters ...
* Make separate targets for building printable documentation in A4 andPeter Eisentraut2006-12-10
| | | | US letter paper formats.
* Reorganize XSLT stylesheet support. Put common things into a separatePeter Eisentraut2006-12-10
| | | | | file (instead of repeating), add XSL-FO stylesheet and appropriate make rules.
* Add some information about increasing JadeTeX parameters.Peter Eisentraut2006-12-10
|
* Drop indentation of verbatim environments in print output. This increasedPeter Eisentraut2006-12-10
| | | | the build time by what seemed like infinity.
* Generalize Texinfo rules. Prevent them from overriding the PostScriptPeter Eisentraut2006-12-10
| | | | build rules.