aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Update copyright script to allow spaces around dash.Bruce Momjian2007-01-10
|
* In SGML Makefile, set proper targets for recursive calls.Bruce Momjian2007-01-10
|
* Update copyright yearTatsuo Ishii2007-01-10
|
* Add:Bruce Momjian2007-01-09
| | | | | | | | | > > * Improve merge join performance by allowing mark/restore of > tuple sources > > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00096.php >
* Update the UTF-8 RFC reference. RFC 2044 was obsoleted by RFC 2279,Bruce Momjian2007-01-09
| | | | | | which was obsoleted by RFC 3629. Michael Fuhr
* Build SGML documention output several times if necessary to have properBruce Momjian2007-01-09
| | | | indexes; add 'draft' option to disable it.
* Have log_temp_files be in kilobytes, remove trace call.Bruce Momjian2007-01-09
|
* Remove trace macro call from new log_temp_files, until it gets moreBruce Momjian2007-01-09
| | | | research.
* Enable another five tuple status bits by using the high bits of theBruce Momjian2007-01-09
| | | | | | nattr field, and rename the field. Heikki Linnakangas
* Done:Bruce Momjian2007-01-09
| | | | > * -Add ability to monitor the use of temporary sort files
* Add GUC log_temp_files to log the use of temporary files.Bruce Momjian2007-01-09
| | | | Bill Moran
* Marginal tweaks in the documentation for ORDER BY; in particular pointTom Lane2007-01-09
| | | | | out the common error that ORDER BY x, y DESC does not mean the same as ORDER BY x DESC, y DESC.
* Add a citation to Seltzer and Yigit's Usenix '91 paper about hash tableTom Lane2007-01-09
| | | | | | | | | | management. The paper clearly describes many of the ideas embodied in our current hashing code, but as far as I could find out there is not a direct code heritage. (Mike Olsen recalls discussion of this paper at Postgres meetings but believes it "informed the Postgres implementation probably just at the design level". Margo herself says she wasn't involved with Postgres' hash code.) Credit where credit is due 'n all that, even if fifteen years after the fact.
* Fix vcbuild to allow building without OpenSSL and/or zlib. MagnusTom Lane2007-01-09
|
* vcbuild documentation from Magnus and Dave.Tom Lane2007-01-09
|
* Done:Bruce Momjian2007-01-09
| | | | | | | | | | | < * Allow the creation of indexes with mixed ascending/descending > * -Allow the creation of indexes with mixed ascending/descending < < This is possible now by creating an operator class with reversed sort < operators. One complexity is that NULLs would then appear at the start < of the result set, and this might affect certain sort types, like < merge join. <
* pltcl regression test needs to actually create an opclass, not just one ↵Tom Lane2007-01-09
| | | | operator.
* Support ORDER BY ... NULLS FIRST/LAST, and add ASC/DESC/NULLS FIRST/NULLS LASTTom Lane2007-01-09
| | | | | | | | | | | | per-column options for btree indexes. The planner's support for this is still pretty rudimentary; it does not yet know how to plan mergejoins with nondefault ordering options. The documentation is pretty rudimentary, too. I'll work on improving that stuff later. Note incompatible change from prior behavior: ORDER BY ... USING will now be rejected if the operator is not a less-than or greater-than member of some btree opclass. This prevents less-than-sane behavior if an operator that doesn't actually define a proper sort ordering is selected.
* Prevent duplicate attribute names in XMLELEMENT.Peter Eisentraut2007-01-08
|
* Tweak joinlist creation to avoid generating useless one-element subproblemsTom Lane2007-01-08
| | | | | | | | | | when collapsing of JOIN trees is stopped by join_collapse_limit. For instance a list of 11 LEFT JOINs with limit 8 now produces something like ((1 2 3 4 5 6 7 8) 9 10 11 12) instead of (((1 2 3 4 5 6 7 8) (9)) 10 11 12) The latter structure is really only required for a FULL JOIN. Noted while studying an example from Shane Ambler.
* Remove cost_hashjoin's very ancient hack to discourage (once, entirely forbid)Tom Lane2007-01-08
| | | | | | | | | | | hash joins with the estimated-larger relation on the inside. There are several cases where doing that makes perfect sense, and in cases where it doesn't, the regular cost computation really ought to be able to figure that out. Make some marginal tweaks in said computation to try to get results approximating reality a bit better. Per an example from Shane Ambler. Also, fix an oversight in the original patch to add seq_page_cost: the costs of spilling a hash join to disk should be scaled by seq_page_cost.
* Some fine-tuning of xmlpi in corner cases:Peter Eisentraut2007-01-07
| | | | | | - correct error codes - do syntax checks in correct order - strip leading spaces of argument
* Check and document minimum required version of libxml.Peter Eisentraut2007-01-07
|
* Indent comments in makefiles better so they don't appear in the output.Peter Eisentraut2007-01-07
|
* Allow XML fragment to contain a XML declaration. For that, we need a smallPeter Eisentraut2007-01-07
| | | | | hand-crafted parser for the XML declaration, because libxml doesn't seem to allow this.
* Remove:Bruce Momjian2007-01-06
| | | | < * %Allow the identifier length to be increased via a configure option
* Updates for MONEY data type:Bruce Momjian2007-01-06
| | | | | | | | | < * Improve the MONEY data type > * -Make 64-bit version of the MONEY data type > * Add locale-aware MONEY type, and support multiple currencies < Change the MONEY data type to use DECIMAL internally, with special < locale-aware output formatting. < http://archives.postgresql.org/pgsql-hackers/2006-09/msg01107.php
* Done:Bruce Momjian2007-01-06
| | | | > * -Allow user-defined types to accept 'typmod' parameters
* Add:Bruce Momjian2007-01-06
| | | | | | | > > * Make consistent use of long/short command options --- pg_ctl needs > long ones, pg_config doesn't have short ones, postgres doesn't have > enough long ones, etc.
* Add:Bruce Momjian2007-01-06
| | | | | | | | > o Consider parsing the -c string into individual queries so each > is run in its own transaction > > o Consider disallowing multiple queries in PQexec() as an > additional barrier to SQL injection attacks
* Apply fix so pow() and exp() ERANGE is used only if result is not 0.Bruce Momjian2007-01-06
|
* Already done in 8.2:Bruce Momjian2007-01-06
| | | | | < * Allow CREATE INDEX to take an additional parameter for use with < special index types
* Move INDEX inheritance out into a separate section:Bruce Momjian2007-01-06
| | | | | | | | | | | | | | | | | | | | | | | | | | | | < * Allow inherited tables to inherit index, UNIQUE constraint, and primary < key, foreign key < * UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from < inherited table: INSERT INTO inherit_table (unique_index_col) VALUES < (dup) should fail < < The main difficulty with this item is the problem of creating an index < that can span more than one table. < < * Allow SELECT ... FOR UPDATE on inherited tables > * Inheritance > > o Allow inherited tables to inherit indexes, UNIQUE constraints, > and primary/foreign keys > o Honor UNIQUE INDEX on base column in INSERTs/UPDATEs > on inherited table, e.g. INSERT INTO inherit_table > (unique_index_col) VALUES (dup) should fail > > The main difficulty with this item is the problem of > creating an index that can span multiple tables. > > o Allow SELECT ... FOR UPDATE on inherited tables > > >
* Done:Bruce Momjian2007-01-06
| | | | > * -Allow the pg_xlog directory location to be specified during initdb
* Allow initdb to specify the pg_xlog directory.Bruce Momjian2007-01-06
| | | | Euler Taveira de Oliveira
* Replace xmlroot with a properly functioning version that parses the value,Peter Eisentraut2007-01-06
| | | | | | | | | sets the items, and serializes the value back (rather than adding an arbitrary number of XML preambles as before). The libxml memory management via palloc had to be disabled because it crashes when libxml tries to access memory that was helpfully freed earlier by PostgreSQL. This needs further thought.
* Fix filtered_base_yylex() to save and restore base_yylval and base_yyllocTom Lane2007-01-06
| | | | | properly when doing a lookahead. The lack of this was causing various interesting misbehaviors when one tries to use "with" as a plain identifier.
* Document problems with release links in early branches.Bruce Momjian2007-01-06
|
* Check for ERANGE in exp() as well.Bruce Momjian2007-01-06
| | | | Improve release docs for ecpg regression tests.
* Improve dpow() check for ERANGE overflow for HPPA.Bruce Momjian2007-01-06
|
* Put back ERANGE test in dpow(). There are platforms that need this,Tom Lane2007-01-06
| | | | like my HPPA ...
* Document that we need to update the ecpg regression files when we updateBruce Momjian2007-01-06
| | | | the library version number.
* Update ecpg regresison output for new library version number.Bruce Momjian2007-01-05
|
* Minor copy-editing for release note updates.Tom Lane2007-01-05
|
* Update CVS HEAD for 2007 copyright. Back branches are typically notBruce Momjian2007-01-05
| | | | back-stamped for this.
* Update copyright script, report year usedBruce Momjian2007-01-05
|
* Modify copyright script to pull current year from `date`.Bruce Momjian2007-01-05
|
* Update Japanese FAQ.Bruce Momjian2007-01-05
|
* Stamp major release 8.3.0, and increment library version numbers.Bruce Momjian2007-01-05
|
* Update for release 8.2.1.Bruce Momjian2007-01-05
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 08:16:37 +0000