summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2007-05-18Mark some intermediate targets as .PRECIOUS, to replace the recently removedPeter Eisentraut
.SECONDARY target. This makes experimentation with the PDF builds easier.
2007-05-18Done:Bruce Momjian
< * Fix problem with excessive logging during SSL disconnection > * -Fix problem with excessive logging during SSL disconnection
2007-05-17dded to TODO:Bruce Momjian
> > * Support scoped IPv6 addresses > > http://archives.postgresql.org/pgsql-bugs/2007-05/msg00111.php
2007-05-17Tweaks for SGML markup.Neil Conway
2007-05-17Add URL for:Bruce Momjian
* Implement the SQL standard mechanism whereby REVOKE ROLE revokes only the privilege granted by the invoking role, and not those granted by other roles > > http://archives.postgresql.org/pgsql-bugs/2007-05/msg00010.php
2007-05-17Add, per Alvaro:Bruce Momjian
> > * Implement the SQL standard mechanism whereby REVOKE ROLE revokes only > the privilege granted by the invoking role, and not those granted > by other roles
2007-05-17Add:Bruce Momjian
> > * Fix problem with excessive logging during SSL disconnection > > http://archives.postgresql.org/pgsql-bugs/2006-12/msg00122.php > http://archives.postgresql.org/pgsql-bugs/2007-05/msg00065.php
2007-05-15Fix a bunch of bad grammar in the docs: "<link>, which see for moreNeil Conway
information" is un-good English.
2007-05-15Various fixes for the SGML docs. Consistently use spaces before/afterNeil Conway
parentheses in syntax descriptions. Consistently use the present tense when describing the basic purpose of each "DROP" command. Add a few more hyperlinks.
2007-05-15Update comments for PG_DETOAST_PACKED and VARDATA_ANY on a structuresBruce Momjian
that require alignment. Add a paragraph to the "User-Defined Types" chapter on using these macros since it seems like they're a hit. Gregory Stark
2007-05-15Make a few marginal improvements to the documentation for the AVNeil Conway
launcher daemon.
2007-05-15Add a note to the documentation to clarify that even whenNeil Conway
"autovacuum = off", the system may still periodically start autovacuum processes to prevent XID wraparound. Patch from David Fetter, with editorializing.
2007-05-15Add URLs for:Bruce Momjian
* Add support for SQL-standard GENERATED/IDENTITY columns > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00344.php > http://archives.postgresql.org/pgsql-patches/2007-05/msg00076.php
2007-05-14Update instructions on creating TODO entry.Bruce Momjian
2007-05-13Mark as done, add URL for other item:Bruce Momjian
< o Add support for arrays of complex types > > http://archives.postgresql.org/pgsql-patches/2007-05/msg00114.php > > o -Add support for arrays of complex types
2007-05-12Add:Bruce Momjian
> * Have configure choose integer datetimes by default > > http://archives.postgresql.org/pgsql-patches/2007-05/msg00046.php
2007-05-12Add:Bruce Momjian
> o Allow data to be passed in native language formats, rather > than only text > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php
2007-05-12Fix the problem that creating a user-defined type named _foo, followed by oneTom Lane
named foo, would work but the other ordering would not. If a user-specified type or table name collides with an existing auto-generated array name, just rename the array type out of the way by prepending more underscores. This should not create any backward-compatibility issues, since the cases in which this will happen would have failed outright in prior releases. Also fix an oversight in the arrays-of-composites patch: ALTER TABLE RENAME renamed the table's rowtype but not its array type.
2007-05-11Fix my oversight in enabling domains-of-domains: ALTER DOMAIN ADD CONSTRAINTTom Lane
needs to check the new constraint against columns of derived domains too. Also, make it error out if the domain to be modified is used within any composite-type columns. Eventually we should support that case, but it seems a bit painful, and not suitable for a back-patch. For the moment just let the user know we can't do it. Backpatch to 8.2, which is the only released version that allows nested domains. Possibly the other part should be back-patched further.
2007-05-11Improvements to the SGML docs for TRUNCATE and CLUSTER.Neil Conway
2007-05-11Support arrays of composite types, including the rowtypes of regular tablesTom Lane
and views (but not system catalogs, nor sequences or toast tables). Get rid of the hardwired convention that a type's array type is named exactly "_type", instead using a new column pg_type.typarray to provide the linkage. (It still will be named "_type", though, except in odd corner cases such as maximum-length type names.) Along the way, make tracking of owner and schema dependencies for types more uniform: a type directly created by the user has these dependencies, while a table rowtype or auto-generated array type does not have them, but depends on its parent object instead. David Fetter, Andrew Dunstan, Tom Lane
2007-05-08Add an explicit comment about POSIX time zone names having the reverseTom Lane
sign convention from everyplace else in Postgres. I don't suppose that this will stop people from being confused, but at least we can say that it's documented.
2007-05-07Grammar correctionPeter Eisentraut
2007-05-07Doc tweak: add an xref.Neil Conway
2007-05-05Done:Bruce Momjian
< Last updated: Sat May 5 10:47:39 EDT 2007 > Last updated: Sat May 5 11:39:57 EDT 2007 < * Flush cached query plans when the dependent objects change, < when the cardinality of parameters changes dramatically, or > * -Flush cached query plans when the dependent objects change or < < A more complex solution would be to save multiple plans for different < cardinality and use the appropriate plan based on the EXECUTE values. < < * Track dependencies in function bodies and recompile/invalidate < < This is particularly important for references to temporary tables < in PL/PgSQL because PL/PgSQL caches query plans. The only workaround < in PL/PgSQL is to use EXECUTE. One complexity is that a function < might itself drop and recreate dependent tables, causing it to < invalidate its own query plan. < < * Invalidate prepared queries, like INSERT, when the table definition > * -Track dependencies in function bodies and recompile/invalidate > * -Invalidate prepared queries, like INSERT, when the table definition
2007-05-05Move item:Bruce Momjian
< * Invalidate prepared queries, like INSERT, when the table definition < is altered > > * Invalidate prepared queries, like INSERT, when the table definition > is altered
2007-05-05Done:Bruce Momjian
> o -Allow multiple vacuums so large tables do not starve small
2007-05-05Wording update to FAQ_DEV..Bruce Momjian
2007-05-05Add note to FAQ_DEV that regression tests might need to be added.Bruce Momjian
2007-05-05In developer's FAQ, update list API, from Tom Lane.Bruce Momjian
2007-05-05Add FAQ item about how patches are reviewed.Bruce Momjian
2007-05-05Done:Bruce Momjian
> * -Allow ORDER BY ... LIMIT # to select high/low value without sort or < < Right now, if no index exists, ORDER BY ... LIMIT # requires we sort < all values to return the high/low value. Instead The idea is to do a < sequential scan to find the high/low value, thus avoiding the sort. < MIN/MAX already does this, but not for LIMIT > 1. <
2007-05-04Make clearer how arguments and return values in pl/perl are escaped. This is ↵Andrew Dunstan
to clarify the situation that Theo Schlossnagle recently reported on -bugs.
2007-05-03Fix a few more double words in docs.Alvaro Herrera
2007-05-03Fix some typos in the documentation. Patch from Brian Gough. BackportNeil Conway
the relevant fixes to 8.2 as well.
2007-04-29Update to 8.4:Bruce Momjian
< * Make standard_conforming_strings the default in 8.3? > * Make standard_conforming_strings the default in 8.4?
2007-04-29Pl/pgsql MOVE done:Bruce Momjian
< o Add support for MOVE and SCROLL cursors < < PL/pgSQL cursors should support the same syntax as < backend cursors. < > o -Add support for MOVE cursors > o Add support for SCROLL cursors
2007-04-29Support for MOVE in PL/PgSQL. Initial patch from Magnus, some improvementsNeil Conway
by Pavel Stehule, and reviewed by Neil Conway.
2007-04-28Add support for IN as alternative to FROM in PL/PgSQL's FETCH statement,Neil Conway
for consistency with the backend's FETCH command. Patch from Pavel Stehule, reviewed by Neil Conway.
2007-04-27Remove no-longer-true statement from the docs. Since the default configNeil Conway
now enables row-level stats, the out of the box stats volume is no longer particularly low.
2007-04-26Consistency tweaks for a table in the SGML docs: we don't terminateNeil Conway
table entries describing functions with periods.
2007-04-26Minor tweak for DISCARD ref page.Neil Conway
2007-04-26Rename the newly-added commands for discarding session state.Neil Conway
RESET SESSION, RESET PLANS, and RESET TEMP are now DISCARD ALL, DISCARD PLANS, and DISCARD TEMP, respectively. This is to avoid confusion with the pre-existing RESET variants: the DISCARD commands are not actually similar to RESET. Patch from Marko Kreen, with some minor editorialization.
2007-04-25Minor consistency tweak for SGML docs.Neil Conway
2007-04-25Remove tabs from installation.sgml.Bruce Momjian
2007-04-25Update Japanese FAQs.Bruce Momjian
Jun Kuwamura
2007-04-24Fix typo.Bruce Momjian
2007-04-24Update FAQ item:Bruce Momjian
<H3 id="item3.6">3.6) What is the upgrade process for PostgreSQL?</H3> to reference both versioning and specific upgrade instructions.
2007-04-23Fix newly-introduced documentation typo.Neil Conway
2007-04-22Done:Bruce Momjian
> o -Allow commenting of variables in postgresql.conf to restore them
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-25 22:18:11 +0000