aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Show database access privileges in psql's \l command. For \l+, also showTom Lane2008-03-30
| | | | | | database size, when available to the current user. Andrew Gilligan
* Display incoming as well as outgoing foreign-key constraints in psql'sTom Lane2008-03-30
| | | | | | \d output for a table. Kenneth D'Souza, some changes by myself.
* Enable 64-bit integer datetimes by default, per previous discussion.Neil Conway2008-03-30
| | | | | | This requires a working 64-bit integer type. If such a type cannot be found, "--disable-integer-datetimes" can be used to switch back to the previous floating point-based datetime implementation.
* Improve description of \du and \dg, per suggestion fromTom Lane2008-03-29
| | | | Harald Armin Massa.
* Improve psql's tab completion to handle completing attribute names in casesTom Lane2008-03-29
| | | | | | | | | | where the relation name was schema-qualified, for example UPDATE foo.bar SET <tab> Also support cases where the relation name was quoted unnecessarily, for example UPDATE "foo" SET <tab> Greg Sabino Mullane, slightly simplified by myself.
* Revert my erroneous fix for Taiki Yamaguchi's DISTINCT MAX() bug.Tom Lane2008-03-29
| | | | Whatever we do about that, this isn't the path to the solution.
* Done:Bruce Momjian2008-03-28
| | | | > * -Add ability to trigger on TRUNCATE
* Clarify documentation on PITR and warm standby on the fact that the standbyHeikki Linnakangas2008-03-28
| | | | | | | restore_command should report failure on non-existent .backup and .history files. Tidy up some related text along the way. Patch by Markus Bertheau, with some editing by Simon Riggs and myself.
* Add to TODO:Bruce Momjian2008-03-28
| | | | | | | | | > > o Add CASE capability to language (already in SQL) > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00696.php > >
* Add:Bruce Momjian2008-03-28
| | | | | | | | > * Allow one transaction to see tuples using the snapshot of another > transaction > > This would assist multiple backends in working together. > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00400.php
* Department of second thoughts: the rule that ORDER BY and DISTINCT areTom Lane2008-03-28
| | | | | | | | | useless for an ungrouped-aggregate query holds regardless of whether optimize_minmax_aggregates succeeds. So we might as well apply the optimization in any case. I'll leave 8.3 as it was, since this version is a tad more invasive than my earlier patch.
* Support statement-level ON TRUNCATE triggers. Simon RiggsTom Lane2008-03-28
|
* Add to TODO:Bruce Momjian2008-03-27
| | | | | | | | | > > * Consider being smarter about memory and external files used during > sorts > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg01101.php > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00045.php
* Add URL for:Bruce Momjian2008-03-27
| | | | | | | * Consider allowing control of upper/lower case folding of unquoted identifiers > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00849.php
* When we have successfully optimized a MIN or MAX aggregate into an indexscan,Tom Lane2008-03-27
| | | | | | | | | | the query result must be exactly one row (since we don't do this when there's any GROUP BY). Therefore any ORDER BY or DISTINCT attached to the query is useless and can be dropped. Aside from saving useless cycles, this protects us against problems with matching the hacked-up tlist entries to sort clauses, as seen in a bug report from Taiki Yamaguchi. We might need to work harder if we ever try to optimize grouped queries with this approach, but this solution will do for now.
* Remove ipcclean utility command --- didn't work on all Unixes and onBruce Momjian2008-03-27
| | | | Windows. Users should use their operating system tools instead.
* Sorry, copied wrong files.Michael Meskes2008-03-27
|
* - Moved from PQsetdbLogin to PQconnectDB.Michael Meskes2008-03-27
| | | | | - Correctly parse connect options. - Changed regression tests accordingly.
* Reduce the need for frontend programs to include "postgres.h" by refactoringTom Lane2008-03-27
| | | | | | | | | | | | inclusions in src/include/catalog/*.h files. The main idea here is to push function declarations for src/backend/catalog/*.c files into separate headers, rather than sticking them into the corresponding catalog definition file as has been done in the past. This commit only carries out that idea fully for pg_proc, pg_type and pg_conversion, but that's enough for the moment --- if pg_list.h ever becomes unsafe for frontend code to include, we'll need to work a bit more. Zdenek Kotala
* Move the HTSU_Result enum definition into snapshot.h, to avoid includingAlvaro Herrera2008-03-26
| | | | | | tqual.h into heapam.h. This makes all inclusion of tqual.h explicit. I also sorted alphabetically the includes on some source files.
* Rename snapmgmt.c/h to snapmgr.c/h, for consistency with other files.Alvaro Herrera2008-03-26
| | | | Per complaint from Tom Lane.
* Fix bad spelling and worse grammar in recent doc commits. PropagateTom Lane2008-03-26
| | | | pg_dump --ignore-version comments into pg_dumpall and pg_restore pages.
* Separate snapshot management code from tuple visibility code, create aAlvaro Herrera2008-03-26
| | | | | | | | | | | | | snapmgmt.c file for the former. The header files have also been reorganized in three parts: the most basic snapshot definitions are now in a new file snapshot.h, and the also new snapmgmt.h keeps the definitions for snapmgmt.c. tqual.h has been reduced to the bare minimum. This patch is just a first step towards managing live snapshots within a transaction; there is no functionality change. Per my proposal to pgsql-patches on 20080318191940.GB27458@alvh.no-ip.org and subsequent discussion.
* Include \password in the psql help.Magnus Hagander2008-03-26
| | | | | While at it, change the order of the documented options to be alphabetically again.
* Improve documentation for odd array slice behavior.Bruce Momjian2008-03-26
|
* Strengthen warnings about using pg_dump's -i option.Bruce Momjian2008-03-26
|
* Update TODO:Bruce Momjian2008-03-26
| | | | | | < o Consider invalidating the cache or keeping seperate cached < copies when search_path changes > o Consider keeping seperate cached copies when search_path changes
* Added to TODO:Bruce Momjian2008-03-26
| | | | | | | | > > * Consider transaction start/end performance improvements > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00948.php > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00361.php
* Fix core dump in contrib/xml2's xpath_table() when the input query returnsTom Lane2008-03-26
| | | | a NULL value. Per bug #4058.
* Update documentation for recent DTrace changes. Patch from Robert Lor.Neil Conway2008-03-25
|
* Simplify and standardize conversions between TEXT datums and ordinary CTom Lane2008-03-25
| | | | | | | | | | | | | | | | | | | | strings. This patch introduces four support functions cstring_to_text, cstring_to_text_with_len, text_to_cstring, and text_to_cstring_buffer, and two macros CStringGetTextDatum and TextDatumGetCString. A number of existing macros that provided variants on these themes were removed. Most of the places that need to make such conversions now require just one function or macro call, in place of the multiple notational layers that used to be needed. There are no longer any direct calls of textout or textin, and we got most of the places that were using handmade conversions via memcpy (there may be a few still lurking, though). This commit doesn't make any serious effort to eliminate transient memory leaks caused by detoasting toasted text objects before they reach text_to_cstring. We changed PG_GETARG_TEXT_P to PG_GETARG_TEXT_PP in a few places where it was easy, but much more could be done. Brendan Jurd and Tom Lane
* Done:Bruce Momjian2008-03-25
| | | | > * -Avoid tuple some tuple copying in sort routines
* Add a new tuplestore API function, tuplestore_putvalues(). This isNeil Conway2008-03-25
| | | | | | | identical to tuplestore_puttuple(), except it operates on arrays of Datums + nulls rather than a fully-formed HeapTuple. In several places that use the tuplestore API, this means we can avoid creating a HeapTuple altogether, saving a copy.
* Update TODO wording:Bruce Momjian2008-03-25
| | | | * Simplify integer cross-data-type operators
* Reword Win32 rint() item, per Tom.Alvaro Herrera2008-03-25
|
* Add URLs to previous discussions, per Simon.Alvaro Herrera2008-03-25
|
* added ECPGget_PGconn to exports.txtMichael Meskes2008-03-25
|
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | | > > * Add SQL-standard array_agg() and unnest() array functions > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01017.php >
* Add to pl/pgsql TODO:Bruce Momjian2008-03-25
| | | | | | | | > > o Consider invalidating the cache or keeping seperate cached > copies when search_path changes > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01009.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > * Add more cross-data-type operators > > http://archives.postgresql.org/pgsql-bugs/2008-01/msg00189.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | > * Detect deadlocks involving LockBufferForCleanup() > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php
* Add to psql TODO:Bruce Momjian2008-03-25
| | | | | | | | | > > o Improve display if enums > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00826.php > >
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > o Fix port/rint.c to be spec-compliant > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00808.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > * Consider sorting entries before inserting into btree index > > http://archives.postgresql.org/pgsql-general/2008-01/msg01010.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | | > > * Improve detection of shared memory segments being used by other > FreeBSD jails > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00656.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | | | > > * Move pgfoundry's xlogdump to /contrib and have it rely more closely > on the WAL backend code > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00035.php >
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > * Have resource managers report the duration of their status changes > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg01468.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > * Be more aggressive about creating WAL files > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg01325.php
* Add:Bruce Momjian2008-03-25
| | | | | | | > o Prevent concurrent CREATE TABLE table1 from sometimes returning > a cryptic error message > > http://archives.postgresql.org/pgsql-bugs/2007-10/msg00169.php
* Add to TODO:Bruce Momjian2008-03-25
| | | | | | | > > * Have /contrib/dblink reuse unnamed connections > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00895.php
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 14:17:18 +0000