aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Fix problems with cached tuple descriptors disappearing while still in useTom Lane2006-06-16
| | | | | | | | | | by creating a reference-count mechanism, similar to what we did a long time ago for catcache entries. The back branches have an ugly solution involving lots of extra copies, but this way is more efficient. Reference counting is only applied to tupdescs that are actually in caches --- there seems no need to use it for tupdescs that are generated in the executor, since they'll go away during plan shutdown by virtue of being in the per-query memory context. Neil Conway and Tom Lane
* 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 to locale TODO.detail.Bruce Momjian2006-06-16
|
* 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
|
* Test for POSIX_FADV_DONTNEED to use posix_fadvise().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
|
* Use posix_fadvise() to avoid kernel caching of WAL contents on WAL fileBruce Momjian2006-06-15
| | | | | | close. ITAGAKI Takahiro
* 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 the limit on the number of entries allowed in catcaches, andTom Lane2006-06-15
| | | | | | | | | | | | | | | | | | remove the infrastructure needed to enforce the limit, ie, the global LRU list of cache entries. On small-to-middling databases this wins because maintaining the LRU list is a waste of time. On large databases this wins because it's better to keep more cache entries (we assume such users can afford to use some more per-backend memory than was contemplated in the Berkeley-era catcache design). This provides a noticeable improvement in the speed of psql \d on a 10000-table database, though it doesn't make it instantaneous. While at it, use per-catcache settings for the number of hash buckets per catcache, rather than the former one-size-fits-all value. It's a bit silly to be using the same number of hash buckets for, eg, pg_am and pg_attribute. The specific values I used might need some tuning, but they seem to be in the right ballpark based on CATCACHE_STATS results from the standard regression tests.
* Add to locale TODO.detail.Bruce Momjian2006-06-14
|
* 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
* Add COPY views patch URL:Bruce Momjian2006-06-14
| | | | > http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php
* Add:Bruce Momjian2006-06-14
| | | | | | | > > o Add API for 64-bit large object access > > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00781.php
* Keep TODO.detail until item is done:Bruce Momjian2006-06-14
| | | | | < o %Allow pg_dump to use multiple -t and -n switches > o %Allow pg_dump to use multiple -t and -n switches [pg_dump]
* Add URL, remove TODO.detail:Bruce Momjian2006-06-14
| | | | | | | | < o %Allow pg_dump to use multiple -t and -n switches [pg_dump] > o %Allow pg_dump to use multiple -t and -n switches > > http://archives.postgresql.org/pgsql-patches/2006-01/msg00190.php >
* Add locale/encoding references:Bruce Momjian2006-06-14
| | | | | | < Right now only one encoding is allowed per database. > Right now only one encoding is allowed per database. [locale] > * Add CREATE COLLATE? [locale]
* Add locale TODO.detail emails.Bruce Momjian2006-06-14
|
* Update link to TODO.detail:Bruce Momjian2006-06-14
| | | | | < o Check WSACancelBlockingCall() for interrupts (win32intr) > o Check WSACancelBlockingCall() for interrupts [win32intr]
* Add:Bruce Momjian2006-06-14
| | | | | | | | > o Fix problem when cascading referential triggers make changes on > cascaded tables, seeing the tables in an intermediate state > > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
* Added:Bruce Momjian2006-06-14
| | | | | | | > > * Add URL to more complete multi-byte regression tests > > http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php
* Add entry:Bruce Momjian2006-06-14
| | | | | | > * Allow user-defined types to accept 'typmod' parameters > http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00012.php
* Further thoughts about lo_export/lo_import error handling: if one ofTom Lane2006-06-14
| | | | | | | the lower-level large object functions fails, it will have already set a suitable error message --- probably something from the backend --- and it is not useful to overwrite that with a generic 'error while reading large object' message. So remove redundant messages.
* Clean up psql's control-C handling to avoid longjmp'ing out of randomTom Lane2006-06-14
| | | | | | | | | places --- that risks corrupting data structures, losing sync with the backend, etc. We now longjmp only from calls to readline, fgets, and fread, which we assume are coded to protect themselves against interrupts at undesirable times. This requires adding explicit tests for cancel_pressed in long-running loops, but on the whole it's far cleaner. Martijn van Oosterhout and Tom Lane.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 18:36:16 +0000