aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > * Have /contrib/dblink reuse unnamed connections > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00895.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | > * Remove old-style routines for manipulating tuples > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00851.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | | > > * Create three versions of libpgport to simplify client code > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00154.php >
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > * Fix regular expression bug when using complex back-references > > http://archives.postgresql.org/pgsql-bugs/2007-10/msg00000.php
* Add to TODO:Bruce Momjian2008-03-24
| | | | | | | | | | > > * Allow xml arrays to be cast to other data types > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00981.php > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00231.php > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00471.php >
* When a relation has been proven empty by constraint exclusion, propagate thatTom Lane2008-03-24
| | | | | | | | knowledge up through any joins it participates in. We were doing that already in some special cases but not in the general case. Also, defend against zero row estimates for the input relations in cost_mergejoin --- this fix may have eliminated the only scenario in which that can happen, but be safe. Per report from Alex Solovey.
* Use new errdetail_log() mechanism to provide a less klugy way of reportingTom Lane2008-03-24
| | | | | large numbers of dependencies on a role that couldn't be dropped. Per a comment from Alvaro.
* Fix various infelicities that have snuck into usage of errdetail() andTom Lane2008-03-24
| | | | | | friends. Avoid double translation of some messages, ensure other messages are exposed for translation (and make them follow the style guidelines), avoid unsafe passing of an unpredictable message text as a format string.
* Add to TODO:Bruce Momjian2008-03-24
| | | | | | | > > * Research reducing deTOASTing in more places > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00895.php
* Adjust the recent patch for reporting of deadlocked queries so that we reportTom Lane2008-03-24
| | | | | | | | query texts only to the server log. This eliminates the issue of possible leaking of security-sensitive data in other sessions' queries. Since the log is presumed secure, we can now log the queries of all sessions involved in the deadlock, whether or not they belong to the same user as the one reporting the failure.
* Add a new ereport auxiliary function errdetail_log(), which works the same asTom Lane2008-03-24
| | | | | | | | errdetail except the string goes only to the server log, replacing the normal errdetail there. This provides a reasonably clean way of dealing with error details that are too security-sensitive or too bulky to send to the client. This commit just adds the infrastructure --- actual uses to follow.
* Add URL for:Bruce Momjian2008-03-24
| | | | | | * SMP scalability improvements > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00206.php
* Add URL to:Bruce Momjian2008-03-24
| | | | | | * SMP scalability improvements > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00361.php
* Add to TODO:Bruce Momjian2008-03-24
| | | | | | | > > * SMP scalability improvements > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00439.php
* Add URL:Bruce Momjian2008-03-24
| | | | | | | | | * Allow statistics last vacuum/analyze execution times to be displayed without requiring stats_row_level to be enabled > > http://archives.postgresql.org/pgsql-docs/2007-04/msg00028.php >
* Add to TODO:Bruce Momjian2008-03-24
| | | | | | | > * Improve reporting of UNION type mismatches > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00944.php > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00597.php
* Update wording:Bruce Momjian2008-03-24
| | | | | | | < o Allow pre/data/post files when dumping a single object, for < performance reasons > o Allow pre/data/post files when schema and data are dumped > separately, for performance reasons
* Update text:Bruce Momjian2008-03-23
| | | | | < o Support pgxs > o Support pgxs when using MSVC
* Add:Bruce Momjian2008-03-23
| | | | > http://archives.postgresql.org/pgsql-patches/2008-02/msg00176.php
* Re-add:Bruce Momjian2008-03-23
| | | | | | | > > * Avoid tuple some tuple copying in sort routines > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php
* Add:Bruce Momjian2008-03-23
| | | | | | | > > * Sort large UPDATE/DELETEs so it is done in heap order > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01119.php
* Add URL for:Bruce Momjian2008-03-23
| | | | | | | | | * Do async I/O for faster random read-ahead of data Async I/O allows multiple I/O requests to be sent to the disk with results coming back asynchronously. > http://archives.postgresql.org/pgsql-patches/2008-01/msg00170.php
* Done:Bruce Momjian2008-03-23
| | | | | | | < < * Avoid tuple some tuple copying in sort routines < < http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php
* Avoid a useless tuple copy within nodeMaterial. Neil ConwayTom Lane2008-03-23
|
* Add to pg_dump TODO:Bruce Momjian2008-03-23
| | | | | | | | > o Allow pre/data/post files when dumping a single object, for > performance reasons > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00205.php >
* Create a function quote_nullable(), which works the same as quote_literal()Tom Lane2008-03-23
| | | | | | | | | except that it returns the string 'NULL', rather than a SQL null, when called with a null argument. This is often a much more useful behavior for constructing dynamic queries. Add more discussion to the documentation about how to use these functions. Brendan Jurd
* Add to Win3 TODO:Bruce Momjian2008-03-23
| | | | | | | | > > o Fix MSVC NLS support, like for to_char() > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00485.php > http://archives.postgresql.org/pgsql-patches/2008-02/msg00038.php
* Add to TODO:Bruce Momjian2008-03-23
| | | | | | | | > > * Improve WAL concurrency by increasing lock granularity > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg00556.php >
* Add to Win32 TODOBruce Momjian2008-03-22
| | | | | > > o Support pgxs
* Add to TODO:Bruce Momjian2008-03-22
| | | | | | | > > * Avoid tuple some tuple copying in sort routines > > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01206.php
* Add URL for TODO:Bruce Momjian2008-03-22
| | | | | | o Add checks to prevent a CREATE RULE views on inherited tables > http://archives.postgresql.org/pgsql-general/2008-03/msg00077.php
* Refactor to_char/to_date formatting code; primarily, replace DCH_processorTom Lane2008-03-22
| | | | | with two new functions DCH_to_char and DCH_from_char that have less confusing APIs. Brendan Jurd
* Add to TODO:Bruce Momjian2008-03-22
| | | | | | | > > o Add checks to prevent a CREATE RULE views on inherited tables > > http://archives.postgresql.org/pgsql-general/2008-02/msg01420.php
* Add server side lo_import(filename, oid) function.Tatsuo Ishii2008-03-22
|
* Add URL for:Bruce Momjian2008-03-22
| | | | | | * Simplify ability to create partitioned tables > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00387.php
* Add URL for:Bruce Momjian2008-03-22
| | | | | | * Simplify ability to create partitioned tables > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00248.php
* Add TODO:Bruce Momjian2008-03-22
| | | | | | | > > * Improve performance of shared invalidation queue for multiple CPUs > > http://archives.postgresql.org/pgsql-performance/2008-01/msg00023.php
* Add URLs for:Bruce Momjian2008-03-22
| | | | | | | | | | | | * Simplify ability to create partitioned tables This would allow creation of partitioned tables without requiring creation of triggers or rules for INSERT/UPDATE/DELETE, and constraints for rapid partition selection. Options could include range and hash partition selection. > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00028.php > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00413.php
* Remove TypeName struct's timezone flag, which has been write-only storageTom Lane2008-03-21
| | | | | for a very long time --- in current usage it's entirely redundant with the name field.
* Give an explicit error for serial[], rather than silently ignoringTom Lane2008-03-21
| | | | the array decoration as the code had been doing.
* Report the current queries of all backends involved in a deadlockTom Lane2008-03-21
| | | | | | | | | | | | | | | (if they'd be visible to the current user in pg_stat_activity). This might look like it's subject to race conditions, but it's actually pretty safe because at the time DeadLockReport() is constructing the report, we haven't yet aborted our transaction and so we can expect that everyone else involved in the deadlock is still blocked on some lock. (There are corner cases where that might not be true, such as a statement timeout triggering in another backend before we finish reporting; but at worst we'd report a misleading activity string, so it seems acceptable considering the usefulness of reporting the queries.) Original patch by Itagaki Takahiro, heavily modified by me.
* Add:Bruce Momjian2008-03-21
| | | | | | | | > > * Convert single quotes to apostrophes in the PDF documentation > > http://archives.postgresql.org/pgsql-docs/2007-12/msg00059.php >
* Add:Bruce Momjian2008-03-21
| | | | | | | > > * Fix inconsistent precedence of =, >, and < compared to <>, >=, and <= > > http://archives.postgresql.org/pgsql-bugs/2007-12/msg00145.php
* Add:Bruce Momjian2008-03-21
| | | | | | | | > > o Prevent SSL from sending network packets to avoid interference > with Win32 signal emulation > > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00455.php
* Corrected version number.Michael Meskes2008-03-21
|
* Document that soft-mounting NFS is not recommended.Bruce Momjian2008-03-21
|
* More README src cleanups.Bruce Momjian2008-03-21
|
* Adjust pgstatindex() to give correct answers for indexes larger thanTom Lane2008-03-21
| | | | | 2^31 blocks. Also fix pg_relpages() for the same case. Tatsuhito Kasahara
* Generate dummy probes.h for MSVC builds.Andrew Dunstan2008-03-21
|
* Get rid of a bunch of #ifdef HAVE_INT64_TIMESTAMP conditionals by inventingTom Lane2008-03-21
| | | | | | | | | | a new typedef TimeOffset to represent an intermediate time value. It's either int64 or double as appropriate, and in most usages will be measured in microseconds or seconds the same as Timestamp. We don't call it Timestamp, though, since the value doesn't necessarily represent an absolute time instant. Warren Turkal
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 18:08:00 +0000