aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Some editorial work on the documentation of the current-date/timeTom Lane2006-06-19
| | | | functions.
* Do not use already free'ed errmsg, bug found by Joachim WielandMichael Meskes2006-06-19
| | | | <joachim.wieland@credativ.de>
* 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
|
* Don't try to call posix_fadvise() unless <fcntl.h> supplies a declarationTom Lane2006-06-18
| | | | | | | | for it. Hopefully will fix core dump evidenced by some buildfarm members since fadvise patch went in. The actual definition of the function is not ABI-compatible with compiler's default assumption in the absence of any declaration, so it's clearly unsafe to try to call it without seeing a declaration.
* Fix saveHistory() to not emit bogus complaint during psql exit when usingTom Lane2006-06-18
| | | | | Darwin's libedit; per my proposal last August. Also, suppress cast-away- const warnings.
* Increase timeout in statement_timeout test from 1 second to 2 seconds.Tom Lane2006-06-18
| | | | | | | | | We have once or twice seen failures suggesting that control didn't get to the exception block before the timeout elapsed, which is unlikely but not impossible in a parallel regression test (with a dozen other backends competing for cycles). This change doesn't completely prevent the problem of course, but it should reduce the probability enough that we don't see it anymore. Per buildfarm results.
* 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.
* Fix a couple of obvious problems in DROP IF EXISTS patch.Tom Lane2006-06-16
|
* 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
* DROP ... IF EXISTS for the following cases:Andrew Dunstan2006-06-16
| | | | language, tablespace, trigger, rule, opclass, function, aggregate. operator, and cast.
* 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
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 19:01:18 +0000