aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add CREATE/ALTER/DROP OPERATOR FAMILY commands, also COMMENT ON OPERATORTom Lane2007-01-23
| | | | | | FAMILY; and add FAMILY option to CREATE OPERATOR CLASS to allow adding a class to a pre-existing family. Per previous discussion. Man, what a tedious lot of cutting and pasting ...
* Remove newline from error message because URL is gone.Bruce Momjian2007-01-23
|
* Back out use of FormatMessage(), does error values, not exceptionBruce Momjian2007-01-23
| | | | | values. Point to /include/ntstatus.h for an exception list, rather than a URL.
* Print meaningfull error text for abonormal process exit on Win32, ratherBruce Momjian2007-01-23
| | | | than hex codes, using FormatMessage().
* Update my email address in FAQ.Bruce Momjian2007-01-22
|
* Put back planner's ability to cache the results of mergejoinscansel(),Tom Lane2007-01-22
| | | | | | | | | | which I had removed in the first cut of the EquivalenceClass rewrite to simplify that patch a little. But it's still important --- in a four-way join problem mergejoinscansel() was eating about 40% of the planning time according to gprof. Also, improve the EquivalenceClass code to re-use join RestrictInfos rather than generating fresh ones for each join considered. This saves some memory space but more importantly improves the effectiveness of caching planning info in RestrictInfos.
* Use errhint() for WIN32 SIGTERM message, where possible.Bruce Momjian2007-01-22
|
* Uppercase hex value.Bruce Momjian2007-01-22
|
* When system() fails in Win32, report it as an exception, print theBruce Momjian2007-01-22
| | | | exception value in hex, and give a URL where the value can be looked-up.
* Update documenation instructions. on how to delete template1.Bruce Momjian2007-01-22
|
* Adjust pgbench so it won't spit up on non-select queries returningTom Lane2007-01-22
| | | | | tuples, which is entirely possible with custom scripts (consider RETURNING, EXPLAIN, etc).
* Add COST and ROWS options to CREATE/ALTER FUNCTION, plus underlying pg_procTom Lane2007-01-22
| | | | | | | | | | | | columns procost and prorows, to allow simple user adjustment of the estimated cost of a function call, as well as control of the estimated number of rows returned by a set-returning function. We might eventually wish to extend this to allow function-specific estimation routines, but there seems to be consensus that we should try a simple constant estimate first. In particular this provides a relatively simple way to control the order in which different WHERE clauses are applied in a plan node, which is a Good Thing in view of the fact that the recent EquivalenceClass planner rewrite made that much less predictable than before.
* Remove some unused variablesPeter Eisentraut2007-01-21
|
* Put back libpq link, but make sure that libpq's in-tree directory isPeter Eisentraut2007-01-21
| | | | mentioned before the system directories.
* Refactor some lsyscache routines to eliminate duplicate code and saveTom Lane2007-01-21
| | | | a couple of syscache lookups in make_pathkey_from_sortinfo().
* Add bitmap index URL:Bruce Momjian2007-01-20
| | | | | > > http://archives.postgresql.org/pgsql-hackers/2006-12/msg01107.php
* Simplify pg_am representation of ordering-capable access methods:Tom Lane2007-01-20
| | | | | | | provide just a boolean 'amcanorder', instead of fields that specify the sort operator strategy numbers. We have decided to require ordering-capable AMs to use btree-compatible strategy numbers, so the old fields are overkill (and indeed misleading about what's allowed).
* Add URL for dead space map:Bruce Momjian2007-01-20
| | | | | | > > http://archives.postgresql.org/pgsql-hackers/2006-12/msg01188.php > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00121.php
* Update docs for recent change to setseed() return value.Neil Conway2007-01-20
|
* Make setseed() return void, rather than an int4 without any use. PerNeil Conway2007-01-20
| | | | pgsql-patches discussion of September 20, 2006. Bump the catversion.
* Add documentation of memory and time units to postgresql.conf.Bruce Momjian2007-01-20
| | | | Backpatch to 8.2.X for new initdbs.
* Don't use 'int' where you mean 'bool'.Tom Lane2007-01-20
|
* Update documentation about postgresqlconf to mention default units thatBruce Momjian2007-01-20
| | | | | | | | match the postgresql.conf file. Also add units to descriptions that lacked them. Wording improvements. Mention pg_settings.unit as the way to find the default units for setting. Backpatch to 8.2.X.
* Fix broken markup.Tom Lane2007-01-20
|
* List disabled triggers separately in psql's "\d <table>" output.Neil Conway2007-01-20
| | | | | Previously, disabled triggers were not displayed any differently than enabled ones, which was quite misleading. Patch from Brendan Jurd.
* Refactor planner's pathkeys data structure to create a separate, explicitTom Lane2007-01-20
| | | | | | | | | | | | | | representation of equivalence classes of variables. This is an extensive rewrite, but it brings a number of benefits: * planner no longer fails in the presence of "incomplete" operator families that don't offer operators for every possible combination of datatypes. * avoid generating and then discarding redundant equality clauses. * remove bogus assumption that derived equalities always use operators named "=". * mergejoins can work with a variety of sort orders (e.g., descending) now, instead of tying each mergejoinable operator to exactly one sort order. * better recognition of redundant sort columns. * can make use of equalities appearing underneath an outer join.
* Refactor the index AM API slightly: move currentItemData andNeil Conway2007-01-20
| | | | | | | currentMarkData from IndexScanDesc to the opaque structs for the AMs that need this information (currently gist and hash). Patch from Heikki Linnakangas, fixes by Neil Conway.
* Update build time estimate.Peter Eisentraut2007-01-20
|
* Remove remains of old depend target.Peter Eisentraut2007-01-20
|
* Regression tests for large objects. Patch from Jeremy Drake.Neil Conway2007-01-20
|
* Modify max_fsm_pages in postgresql.conf.sample to show a typical value,Bruce Momjian2007-01-20
| | | | rather than a value too high.
* Teach psql's \lo slash commands to respect quiet mode, and to outputNeil Conway2007-01-20
| | | | HTML in HTML mode. Patch from Jeremy Drake.
* Document that to remove template1, datistemplate must be 'false'.Bruce Momjian2007-01-20
| | | | Backpatch to 8.2.
* The libpq library directory was mentioned here in the wrong place, whichPeter Eisentraut2007-01-20
| | | | | might lead to a previously installed libpq being used instead. But we don't actually have to link with libpq here at all, so remove it.
* Only build ecpg test code when the test is to be performed, in line withPeter Eisentraut2007-01-20
| | | | other test code.
* Move code that places LOG error level between ERROR and PANIC into newBruce Momjian2007-01-20
| | | | function is_log_level_output(), for code clarity.
* Fix xmlconcat regression testPeter Eisentraut2007-01-20
|
* Fix xmlconcat by properly merging the XML declarations. Add aggregatePeter Eisentraut2007-01-20
| | | | function xmlagg.
* Add wiki URL:Bruce Momjian2007-01-20
| | | | | | < first. > first. There is also a developer's wiki at > http://developer.postgresql.org.
* Add missing copyright blurb, make ruleutils.c use the standard layoutNeil Conway2007-01-20
| | | | for its header comment.
* Add items:Bruce Momjian2007-01-19
| | | | | | | | | | | > o Allow multiple vacuums so large tables do not starve small > tables > > http://archives.postgresql.org/pgsql-general/2007-01/msg00031.php > > o Improve control of auto-vacuum > > http://archives.postgresql.org/pgsql-hackers/2006-12/msg00876.php
* Fix pg_regress breakage for PL and contrib tests, by not requiring thatAlvaro Herrera2007-01-19
| | | | "input" and "output" dirs be necessarily present.
* Add URL for:Bruce Momjian2007-01-19
| | | | | * Add Globally/Universally Unique Identifier (GUID/UUID) > http://archives.postgresql.org/pgsql-general/2007-01/msg00853.php
* Add support for converting binary values (i.e. bytea) into xml values,Peter Eisentraut2007-01-19
| | | | | with new GUC parameter "xmlbinary" that controls the output encoding, as per SQL/XML standard.
* Change the sed rules in the regression test for pg_regress hackery to createAlvaro Herrera2007-01-19
| | | | | | | the generated files, to help Visual C++ to run these tests. The tests still pass in VPATH and normal builds. Patch from Magnus Hagander, editorialized by me.
* Optionally use xml2-config to detect installation locations of libxml.Peter Eisentraut2007-01-18
|
* Clean up encoding issues in the xml type: In text mode, encodingPeter Eisentraut2007-01-18
| | | | | declarations are ignored and removed, in binary mode they are honored as specified by the XML standard.
* Add a note pointing out that is_pseudo_constant_clause() doesn't checkTom Lane2007-01-17
| | | | | for aggregates. This is OK for current uses but could burn somebody someday...
* Extend yesterday's patch so that the bgwriter is also told to forgetTom Lane2007-01-17
| | | | pending fsyncs during DROP DATABASE. Obviously necessary in hindsight :-(
* Tweak the width_bucket() regression tests to avoid an unnecessaryNeil Conway2007-01-17
| | | | | dependency on the platform's floating point implementation. Per report from Stefan Kaltenbrunner.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-02 10:33:31 +0000