summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2008-07-21Code review for array_fill patch: fix inadequate check for array size overflowTom Lane
and bogus documentation (dimension arrays are int[] not anyarray). Also the errhint() messages seem to be really errdetail(), since there is nothing heuristic about them. Some other trivial cosmetic improvements.
2008-07-20Add a pg_dump option --lock-wait-timeout to allow failing the dump if unableTom Lane
to acquire shared table locks within a specified amount of time. David Gould
2008-07-18Properly document archive/restore command examples on Windows.Bruce Momjian
ITAGAKI Takahiro
2008-07-18Implement SQL-spec RETURNS TABLE syntax for functions.Tom Lane
(Unlike the original submission, this patch treats TABLE output parameters as being entirely equivalent to OUT parameters -- tgl) Pavel Stehule
2008-07-18Add URL for:Bruce Momjian
* Implement SQL:2003 window functions > http://archives.postgresql.org/pgsql-hackers/2008-07/msg00232.php
2008-07-17Add to TODO:Bruce Momjian
> > * Reduce locking requirements for creating a trigger > > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00635.php >
2008-07-16Add URL for:Bruce Momjian
* Implement SQL:2003 window functions > > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00380.php >
2008-07-16Add a "provariadic" column to pg_proc to eliminate the remarkably expensiveTom Lane
need to deconstruct proargmodes for each pg_proc entry inspected by FuncnameGetCandidates(). Fixes function lookup performance regression caused by yesterday's variadic-functions patch. In passing, make pg_proc.probin be NULL, rather than a dummy value '-', in cases where it is not actually used for the particular type of function. This should buy back some of the space cost of the extra column.
2008-07-16Add to TODO:Bruce Momjian
> > o Add external tool to auto-tune some postgresql.conf parameters > > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00000.php >
2008-07-16Support "variadic" functions, which can accept a variable number of argumentsTom Lane
so long as all the trailing arguments are of the same (non-array) type. The function receives them as a single array argument (which is why they have to all be the same type). It might be useful to extend this facility to aggregates, but this patch doesn't do that. This patch imposes a noticeable slowdown on function lookup --- a follow-on patch will fix that by adding a redundant column to pg_proc. Pavel Stehule
2008-07-16Add array_fill() to create arrays initialized with a value.Bruce Momjian
Pavel Stehule
2008-07-15Fix alignment of SGML array docs.Bruce Momjian
2008-07-15Add Swedish_Sweden.1252 Windows locale example to docs.Bruce Momjian
2008-07-15Add to TODO:Bruce Momjian
> > o Reduce PITR WAL file size by removing full page writes and > by removing trailing bytes to improve compression
2008-07-15Add TODO:Bruce Momjian
> > * Consider decreasing the I/O caused by updating tuple hint bits > > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00847.php >
2008-07-15Done:Bruce Momjian
> o -Have psql show current values for a sequence
2008-07-15Clarify that locale names on Windows are more verbose.Bruce Momjian
Report from Martin Saschek
2008-07-14Add to TODO:Bruce Momjian
> * Improve ability to modify views via ALTER TABLE > > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00691.php
2008-07-14Done:Bruce Momjian
< * Add temporal versions of generate_series() > * -Add temporal versions of generate_series()
2008-07-14Add URL for:Bruce Momjian
* Consider allowing control of upper/lower case folding of unquoted identifiers > http://archives.postgresql.org/pgsql-hackers/2008-07/msg00415.php
2008-07-14Done, per Simon:Bruce Momjian
< o Fix server restart problem when the server was shutdown during > o -Fix server restart problem when the server was shutdown during
2008-07-14Create a type-specific typanalyze routine for tsvector, which collects statsTom Lane
on the most common individual lexemes in place of the mostly-useless default behavior of counting duplicate tsvectors. Future work: create selectivity estimation functions that actually do something with these stats. (Some other things we ought to look at doing: using the Lossy Counting algorithm in compute_minimal_stats, and using the element-counting idea for stats on regular arrays.) Jan Urbanski
2008-07-12Fix a couple of stray misuses of "binary compatible".Tom Lane
2008-07-11Multi-column GIN indexes. Teodor SigaevTom Lane
2008-07-11Allow binary-coercible types for cast function arguments and return types.Peter Eisentraut
Document return type of cast functions. Also change documentation to prefer the term "binary coercible" in its present sense instead of the previous term "binary compatible".
2008-07-10Add unchangeable GUC "variables" segment_size, wal_block_size, andTom Lane
wal_segment_size to make those configuration parameters available to clients, in the same way that block_size was previously exposed. Bernd Helmle, with comments from Abhijit Menon-Sen and some further tweaking by me.
2008-07-07Added documentation for function xmlagg.Peter Eisentraut
2008-07-03Add a function pg_get_keywords() to let clients find out the set of keywordsTom Lane
known to the SQL parser. Dave Page
2008-07-03Don't print the name of the database in psql \z.Peter Eisentraut
2008-07-03Fix psql's \d and allied commands to work with all server versions back to 7.4.Tom Lane
Guillaume Lelarge, with some additional fixes by me.
2008-07-01Documentation patch by Kevin L. McBride explaining GUC lock variables,Bruce Momjian
which are available if LOCK_DEBUG is defined.
2008-07-01Add URL for:Bruce Momjian
* Add database and transaction-level triggers
2008-07-01Add to TODO:Bruce Momjian
> * Fix TRUNCATE ... RESTART IDENTITY so its affect on sequences is rolled > back on transaction abort
2008-06-30Add psql TODO:Bruce Momjian
> o Add "auto" expanded mode that outputs in expanded format if > "wrapped" mode can't wrap the output to the screen width > > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00417.php >
2008-06-30Add psql TODO item:Bruce Momjian
> o Add option to wrap column values at whitespace boundaries, > rather than chopping them at a fixed width. > Currently, "wrapped" format chops values into fixed > widths. Perhaps the word wrapping could use the same > algorithm documented in the W3C specification. > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00404.php > http://www.w3.org/TR/CSS21/tables.html#auto-table-layout
2008-06-30Turn PGBE_ACTIVITY_SIZE into a GUC variable, track_activity_query_size.Heikki Linnakangas
As the buffer could now be a lot larger than before, and copying it could thus be a lot more expensive than before, use strcpy instead of memcpy to copy the query string, as was already suggested in comments. Also, only copy the PgBackendStatus struct and string if the slot is in use. Patch by Thomas Lee, with some changes by me.
2008-06-27Mention actual function names in documentation of how to pass binaryBruce Momjian
values to libpq.
2008-06-27Add to TODO:Bruce Momjian
> > * Fix system views like pg_stat_all_tables to use set-returning > functions, rather than views of per-column functions
2008-06-27Clarify plpgsql documentation by not treating IF THEN ELSE IF ... as aTom Lane
truly distinct version of IF. Per suggestion from Marko Kreen.
2008-06-26Use SGML table to show backslash string escapes, rather than have themBruce Momjian
appear in a paragraph. Andy Anderson
2008-06-26Add MERGE TODO URL:Bruce Momjian
> http://archives.postgresql.org/pgsql-hackers/2008-04/msg01890.php
2008-06-26Add TODO about security:Bruce Momjian
* Improve server security options http://archives.postgresql.org/pgsql-hackers/2008-04/msg01875.php http://archives.postgresql.org/pgsql-hackers/2008-05/msg00000.php
2008-06-26More FAQ URL updates from Curtis Gallant.Bruce Momjian
2008-06-26Update FAQ URLs as suggested by Curtis Gallant.Bruce Momjian
2008-06-26Add to TODO:Bruce Momjian
> > * Improve LDAP authentication configuration options > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg01745.php
2008-06-26Remove use of postmaster.opts.default by pg_ctl.Bruce Momjian
2008-06-24TODO item done:Bruce Momjian
< o Prevent pg_dump/pg_restore from being affected by > o -Prevent pg_dump/pg_restore from being affected by
2008-06-23Add TODO:Bruce Momjian
> > o Allow COPY to report errors sooner > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg01169.php
2008-06-23Add URL for Merge.Bruce Momjian
2008-06-23Backup wording improvement.Bruce Momjian
Joshua D. Drake
generated by cgit v1.2.3 (git 2.46.0) at 2025-12-06 11:25:25 +0000