aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
* Update my info:Bruce Momjian2006-06-25
| | | | > * Bruce is Bruce Momjian <bruce@momjian.us> of EnterpriseDB
* Add:Bruce Momjian2006-06-25
| | | | | | < * Reuse index tuples that point to rows that are not visible to anyone? > * Reuse index tuples that point to heap tuples that are not visible to > anyone?
* Update entry:Bruce Momjian2006-06-24
| | | | | | | | | | | | | < * Allow heap reuse of UPDATEd rows if old and new versions are on the < same heap page? > * Allow heap reuse of UPDATEd rows if no indexed columns are changed, > and old and new versions are on the same heap page? < This is possible for same-page updates because a single index row < can point to both old and new values. > While vacuum handles DELETEs fine, updating of non-indexed columns, like > counters, are difficult for VACUUM to handle efficiently. This method > is possible for same-page updates because a single index row can be > used to point to both old and new values.
* Add UPDATE entry for row reuse.Bruce Momjian2006-06-24
| | | | | | | | | | > > * Allow heap reuse of UPDATEd rows if old and new versions are on the > same heap page? > > This is possible for same-page updates because a single index row > can point to both old and new values. > http://archives.postgresql.org/pgsql-hackers/2006-06/msg01305.php
* Some editorial work on the documentation of the current-date/timeTom Lane2006-06-19
| | | | functions.
* Take the statistics collector out of the loop for monitoring backends'Tom Lane2006-06-19
| | | | | | | current commands; instead, store current-status information in shared memory. This substantially reduces the overhead of stats_command_string and also ensures that pg_stat_activity is fully up to date at all times. Per my recent proposal.
* Update my email address.Bruce Momjian2006-06-18
|
* Merge postmaster and postgres command into just postgres. postmasterPeter Eisentraut2006-06-18
| | | | | symlink is kept for now for compatibility. To call single-user mode, use postgres --single.
* Code review for SELECT INTO STRICT patch: use saner choices of errorTom Lane2006-06-16
| | | | SQLSTATEs, fix some documentation problems.
* Clean up after someone's curious idea that it'd be good to stripTom Lane2006-06-16
| | | | | leading zeroes from the SQLSTATE codes. They're strings, people, not numbers.
* docs for DROP ... IF EXISTS for the following cases:Andrew Dunstan2006-06-16
| | | | language, tablespace, trigger, rule, opclass, function, aggregate. operator, and cast.
* Add:Bruce Momjian2006-06-16
| | | | | | | > o Allow PL/python to composite types and result sets > once buggy assert-enabled versions of python can be detected > > http://archives.postgresql.org/pgsql-patches/2006-04/msg00087.php
* Add:Bruce Momjian2006-06-16
| | | | | | | > > * Fix CREATE CAST on DOMAINs > > http://archives.postgresql.org/pgsql-hackers/2006-05/msg00072.php
* Document issues with non-default tablespaces and pg_dumpall restores.Bruce Momjian2006-06-16
| | | | Backpatch documentation addition to 8.1.X.
* Add URL for ISO dates:Bruce Momjian2006-06-16
| | | | > http://archives.postgresql.org/pgsql-bugs/2006-04/msg00248.php
* Add URL for currency type:Bruce Momjian2006-06-16
| | | | > http://archives.postgresql.org/pgsql-general/2005-08/msg01432.php
* Add URL for updatable views:Bruce Momjian2006-06-16
| | | | > http://archives.postgresql.org/pgsql-hackers/2006-03/msg00586.php
* Add:Bruce Momjian2006-06-16
| | | | | > * Consider shrinking expired tuples to just their headers > http://archives.postgresql.org/pgsql-patches/2006-03/msg00142.php
* Add URL to:Bruce Momjian2006-06-16
| | | | | * Auto-fill the free space map by scanning the buffer cache or by checking pages written by the background writer
* Add URL for freespace map filling.Bruce Momjian2006-06-16
| | | | | | > > http://archives.postgresql.org/pgsql-hackers/2006-02/msg01125.php >
* >Bruce Momjian2006-06-16
| | | | | | > * Add support for public SYNONYMS > > http://archives.postgresql.org/pgsql-hackers/2006-03/msg00519.php
* > o Add PL/Python tracebacksBruce Momjian2006-06-16
| | | | | > > http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php
* Add:Bruce Momjian2006-06-16
| | | | | | | > o Fix problems with RETURN NEXT on tables with > dropped/added columns after function creation > > http://archives.postgresql.org/pgsql-patches/2006-02/msg00165.php
* Add URL for:Bruce Momjian2006-06-16
| | | | | | > * Allow protocol-level BIND parameter values to be logged > > http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
* Add URL for ISO date/time syntax:Bruce Momjian2006-06-16
| | | | | | > > http://archives.postgresql.org/pgsql-hackers/2006-01/msg00250.php >
* Add LDAP documentation missed in code patch.Bruce Momjian2006-06-16
| | | | Magnus Hagander
* Update preload_library magic block wording.Bruce Momjian2006-06-16
|
* Fix:Bruce Momjian2006-06-16
| | | | | < get_employee_salary(emp_id AS 12345, tax_year AS 2001) > get_employee_salary(12345 AS emp_id, 2001 AS tax_year)
* Update magic block wording for preloaded libraries.Bruce Momjian2006-06-16
|
* Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if more orBruce Momjian2006-06-15
| | | | | | | | | less than one row is returned by the SELECT, for Oracle PL/SQL compatibility. Improve SELECT INTO documentation. Matt Miller
* Fix to_ascii() markup error.Bruce Momjian2006-06-15
|
* Add mention that preload_libraries check the magic block, soBruce Momjian2006-06-15
| | | | non-PostgreSQL libraries cannot be loaded using this capability.
* Update syntax suggestion:Bruce Momjian2006-06-15
| | | | | < get_employee_salary(emp_id => 12345, tax_year => 2001) > get_employee_salary(emp_id AS 12345, tax_year AS 2001)
* Move list of supported to_ascii() encodings from footnote to mainBruce Momjian2006-06-15
| | | | | | description. Nis Jorgensen
* Add:Bruce Momjian2006-06-15
| | | | | | | > > o Fix memory leak from exceptions > > http://archives.postgresql.org/pgsql-performance/2006-06/msg00305.php
* Clarify dynamic pl/pgsql item and add URLs. Restructure server-sideBruce Momjian2006-06-15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | section into PL/pgSQL and non-PL/pgSQL sections: < o Fix PL/pgSQL RENAME to work on variables other than OLD/NEW < o Allow function parameters to be passed by name, < get_employee_salary(emp_id => 12345, tax_year => 2001) < o Add Oracle-style packages < o Add table function support to pltcl, plpython < o Add capability to create and call PROCEDURES < o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[] < o Allow function argument names to be statements from PL/PgSQL < o Add MOVE to PL/pgSQL < o Add support for polymorphic arguments and return types to < languages other than PL/PgSQL < o Add support for OUT and INOUT parameters to languages other < than PL/PgSQL < o Add single-step debugging of PL/PgSQL functions < o Allow PL/PgSQL to support WITH HOLD cursors < o Allow PL/PgSQL RETURN to return row or record functions < < http://archives.postgresql.org/pgsql-patches/2005-11/msg00045.php > o PL/pgSQL > o Fix RENAME to work on variables other than OLD/NEW > o Allow function parameters to be passed by name, > get_employee_salary(emp_id => 12345, tax_year => 2001) > o Add Oracle-style packages > o Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] > o Allow listing of record column names, and access to > record columns via variables, e.g. columns := r.(*), > tval2 := r.(colname) > > http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php > http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php > http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php > > o Add MOVE > o Add single-step debugging of functions > o Add support for WITH HOLD cursors > o Allow PL/RETURN to return row or record functions > > http://archives.postgresql.org/pgsql-patches/2005-11/msg00045.php > > > o Other > o Add table function support to pltcl, plpython > o Add support for polymorphic arguments and return types to > languages other than PL/PgSQL > o Add capability to create and call PROCEDURES > o Add support for OUT and INOUT parameters to languages other > than PL/PgSQL
* Add:Bruce Momjian2006-06-15
| | | | | | > o Allow PL/PgSQL RETURN to return row or record functions > > http://archives.postgresql.org/pgsql-patches/2005-11/msg00045.php
* Done, removed:Bruce Momjian2006-06-15
| | | | | | | | < < * Consider padding the spinlock structure to have spinlock registers < on different CPU cache line < < http://archives.postgresql.org/pgsql-hackers/2005-10/msg00498.php
* Remove, done:Bruce Momjian2006-06-14
| | | | | | | < < * Add support for WIN1253 (Greek) encoding < < http://archives.postgresql.org/pgsql-bugs/2005-12/msg00000.php
* Add:Bruce Momjian2006-06-14
| | | | | | | > > * Add support for WIN1253 (Greek) encoding > > http://archives.postgresql.org/pgsql-bugs/2005-12/msg00000.php
* Add URL to ILIKE encoding fix:Bruce Momjian2006-06-14
| | | | > http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php
* Add:Bruce Momjian2006-06-14
| | | | | | | > > * Consider increasing internal areas when shared buffers is increased > > http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php
* Already done:Bruce Momjian2006-06-14
| | | | | | | < < o Properly mark all libpq-exported functions with "PQ" < < http://archives.postgresql.org/pgsql-hackers/2005-10/msg00696.php
* Done by Peter:Bruce Momjian2006-06-14
| | | | | | < * Improve the information schema to be more standards-compliant: < < http://archives.postgresql.org/pgsql-bugs/2005-10/msg00028.php
* Add:Bruce Momjian2006-06-14
| | | | | | | > > o Properly mark all libpq-exported functions with "PQ" > > http://archives.postgresql.org/pgsql-hackers/2005-10/msg00696.php
* Add:Bruce Momjian2006-06-14
| | | | | | | | > > * Consider padding the spinlock structure to have spinlock registers > on different CPU cache line > > http://archives.postgresql.org/pgsql-hackers/2005-10/msg00498.php
* Add item, not fixed:Bruce Momjian2006-06-14
| | | | | | | | > > * Fix ILIKE and regular expressions to handle case insensitivity > properly in multibyte encodings > > http://archives.postgresql.org/pgsql-bugs/2005-10/msg00001.php
* Remove, already in back branches:Bruce Momjian2006-06-14
| | | | | | | | | | | | | | < < o Add new version of PQescapeString() that doesn't double backslashes < that are part of a client-only multibyte sequence < < Single-quote is not a valid byte in any supported client-only < encoding. This requires using mblen() to determine if the < backslash is inside or outside a multi-byte sequence. < < o Add new version of PQescapeString() that doesn't double < backslashes when standard_conforming_strings is true and < non-E strings are used
* Done:Bruce Momjian2006-06-14
| | | | > o -Port contrib/xml2
* Add information schema item:Bruce Momjian2006-06-14
| | | | | | | | | | | | > * Improve the information schema to be more standards-compliant: > > http://archives.postgresql.org/pgsql-bugs/2005-10/msg00028.php > * Add URL to more complete multi-byte regression tests > > http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php < * Add URL to more complete multi-byte regression tests < < http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-07 23:35:18 +0000