aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
* Make XML building work silently on VPATH builds (untested on regular builds).Alvaro Herrera2008-06-10
|
* Update Japanese FAQ.Bruce Momjian2008-06-09
| | | | Jun Kuwamura
* Update release notes for ALTER AGGREGATE fix.Tom Lane2008-06-08
|
* Update release notes for 8.3.3 et al.Tom Lane2008-06-07
|
* Fix missing "not", per Frank Millman (bug #4212).Alvaro Herrera2008-06-05
|
* Draft release notes for upcoming back-branch updates.Tom Lane2008-06-04
|
* Marginal improvements to the documentation for PGOPTIONS.Tom Lane2008-06-01
|
* Done: -Remove psql newline patch when we find out why mingw outputs an ↵Andrew Dunstan2008-05-31
| | | | extra newline
* Copy refint.so and autoinc.so into the src/test/regress directory duringTom Lane2008-05-30
| | | | | | | | | | | | "make all", and then reference them there during the actual tests. This makes the handling of these files more parallel to that of regress.so, and in particular simplifies use of the regression tests outside the original build tree. The PGDG and Red Hat RPMs have been doing this via patches for a very long time. Inclusion of the change in core was requested by Jørgen Austvik of Sun, and I can't see any reason not to. I attempted to fix the MSVC scripts for this too, but they may need further tweaking ...
* Add description to:Bruce Momjian2008-05-29
| | | | | | | | * Add deferred trigger queue file < This item involves dumping large queues into files. > This item involves dumping large queues into files, or doing some > kind of join to process all the triggers, or some bulk operation.
* Add URL for:Bruce Momjian2008-05-29
| | | | | | * Add deferred trigger queue file > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00876.php
* Improve GRANT documentation to point out that UPDATE and DELETE typicallyTom Lane2008-05-28
| | | | | | require SELECT privilege as well, since you normally need to read existing column values within such commands. This behavior is according to spec, but we'd never documented it before. Per gripe from Volkan Yazici.
* Clarify description of typmod input function, per Jeff Davis.Tom Lane2008-05-27
|
* Alter the xxx_pattern_ops opclasses to use the regular equality operator ofTom Lane2008-05-27
| | | | | | | | | | | | | | | | | | | | | | | | | | | the associated datatype as their equality member. This means that these opclasses can now support plain equality comparisons along with LIKE tests, thus avoiding the need for an extra index in some applications. This optimization was not possible when the pattern opclasses were first introduced, because we didn't insist that text equality meant bitwise equality; but we do now, so there is no semantic difference between regular and pattern equality operators. I removed the name_pattern_ops opclass altogether, since it's really useless: name's regular comparisons are just strcmp() and are unlikely to become something different. Instead teach indxpath.c that btree name_ops can be used for LIKE whether or not the locale is C. This might lead to a useful speedup in LIKE queries on the system catalogs in non-C locales. The ~=~ and ~<>~ operators are gone altogether. (It would have been nice to keep them for backward compatibility's sake, but since the pg_amop structure doesn't allow multiple equality operators per opclass, there's no way.) A not-immediately-obvious incompatibility is that the sort order within bpchar_pattern_ops indexes changes --- it had been identical to plain strcmp, but is now trailing-blank-insensitive. This will impact in-place upgrades, if those ever happen. Per discussions a couple months ago.
* Done:Bruce Momjian2008-05-20
| | | | | < o Use LC_TIME for localized weekday/month names, rather than > o -Use LC_TIME for localized weekday/month names, rather than
* Make to_char()'s localized month/day names depend on LC_TIME, not LC_MESSAGES.Tom Lane2008-05-19
| | | | Euler Taveira de Oliveira
* Rewrite the warning about non-transaction-safety of TRUNCATE ... RESTARTTom Lane2008-05-17
| | | | | | IDENTITY to be more explicit about the possible hazards. Per gripe from Neil and subsequent discussion. Eventually we may be able to get rid of this warning, but for now it had better be there.
* Allow ALTER SEQUENCE START WITH to change the recorded start_value of aTom Lane2008-05-17
| | | | | sequence. This seems an obvious extension to the recent patch, and it makes the code noticeably cleaner and more orthogonal.
* Add a RESTART (without parameter) option to ALTER SEQUENCE, allowing aTom Lane2008-05-16
| | | | | | | | | | | | | | sequence to be reset to its original starting value. This requires adding the original start value to the set of parameters (columns) of a sequence object, which is a user-visible change with potential compatibility implications; it also forces initdb. Also add hopefully-SQL-compatible RESTART/CONTINUE IDENTITY options to TRUNCATE TABLE. RESTART IDENTITY executes ALTER SEQUENCE RESTART for all sequences "owned by" any of the truncated relations. CONTINUE IDENTITY is a no-op option. Zoltan Boszormenyi
* Update psql startup banner to be shorter, suggest "help" for help.Bruce Momjian2008-05-16
| | | | | | | | | | Add a few "help" entries. Move \g help entry into "General". Update psql version mismatch warning text. Joshua D. Drake
* Done in TODO:Bruce Momjian2008-05-16
| | | | > o -Have \l+ show database size, if permissions allow
* Add detection of psql pager to trigger on wide output. Also add pagerBruce Momjian2008-05-16
| | | | | detection for wrapped lines or lines with newlines that need pager to display.
* Extend GIN to support partial-match searches, and extend tsquery to supportTom Lane2008-05-16
| | | | | | prefix matching using this facility. Teodor Sigaev and Oleg Bartunov
* Done:Bruce Momjian2008-05-16
| | | | | | PL/pgSQL > o -Add CASE capability to language (already in SQL)
* Support SQL/PSM-compatible CASE statement in plpgsql.Tom Lane2008-05-15
| | | | Pavel Stehule
* Add support for tracking call counts and elapsed runtime for user-definedTom Lane2008-05-15
| | | | | | | | | | functions. Note that because this patch changes FmgrInfo, any external C functions you might be testing with 8.4 will need to be recompiled. Patch by Martin Pihlak, some editorialization by me (principally, removing tracking of getrusage() numbers)
* Remove odd duplicate wording in psql pager section.Bruce Momjian2008-05-14
|
* Improve plpgsql's RAISE command. It is now possible to attach DETAIL andTom Lane2008-05-13
| | | | | | | | | | | | | | HINT fields to a user-thrown error message, and to specify the SQLSTATE error code to use. The syntax has also been tweaked so that the Oracle-compatible case "RAISE exception_name" works (though you won't get a very nice error message if you just write that much). Lastly, support the Oracle-compatible syntax "RAISE" with no parameters to re-throw the current error from within an EXCEPTION block. In passing, allow the syntax SQLSTATE 'nnnnn' within EXCEPTION lists, so that there is a way to trap errors with custom SQLSTATE codes. Pavel Stehule and Tom Lane
* Todo done:Bruce Momjian2008-05-12
| | | | > * -Improve dead row detection during multi-statement transactions usage
* Document that "ROLLBACK TO savepoint" does not un-close cursors.Alvaro Herrera2008-05-12
|
* Add URL for:Bruce Momjian2008-05-10
| | | | | | o Allow an existing index to be marked as a table's primary key > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg00500.php
* Add to TODO:Bruce Momjian2008-05-10
| | | | > o Allow an existing index to be marked as a table's primary key
* Add URL for:Bruce Momjian2008-05-10
| | | | | | | | * Add column to pg_stat_activity that shows the progress of long-running commands like CREATE INDEX and VACUUM > > http://archives.postgresql.org/pgsql-patches/2008-04/msg00203.php >
* Add TODO item:Bruce Momjian2008-05-10
| | | | | | > o Clear table counters on TRUNCATE > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg00169.php
* TODOs done:Bruce Momjian2008-05-10
| | | | | > o -Prevent parent tables from altering or dropping constraints > o -Prevent child tables from altering or dropping constraints
* Change the rules for inherited CHECK constraints to be essentially the sameTom Lane2008-05-09
| | | | | | | | | | | | | | | | as those for inherited columns; that is, it's no longer allowed for a child table to not have a check constraint matching one that exists on a parent. This satisfies the principle of least surprise (rows selected from the parent will always appear to meet its check constraints) and eliminates some longstanding bogosity in pg_dump, which formerly had to guess about whether check constraints were really inherited or not. The implementation involves adding conislocal and coninhcount columns to pg_constraint (paralleling attislocal and attinhcount in pg_attribute) and refactoring various ALTER TABLE actions to be more like those for columns. Alex Hunsaker, Nikhil Sontakke, Tom Lane
* Add to TODO:Bruce Momjian2008-05-09
| | | | | | | > > * Improve the /contrib installation experience > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg00132.php
* Add psql '\pset format wrapped' mode to wrap output to screen width, orBruce Momjian2008-05-08
| | | | | | file/pipe output too if \pset columns' is set. Bryce Nesbitt
* Fix contrib/xml2 makefile to not override CFLAGS, and in passing make itTom Lane2008-05-08
| | | | auto-configure properly for libxslt present or not.
* Update TODO wording:Bruce Momjian2008-05-08
| | | | | | | | | < * Improve detection of shared memory segments being used by other < FreeBSD jails > * Improve detection of shared memory segments being used by others > by checking the SysV shared memory field 'nattch' > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00673.php
* Add to TODO:Bruce Momjian2008-05-08
| | | | | | > > o Add CREATE SCHEMA ... LIKE that copies a schema >
* Add to TODO:Bruce Momjian2008-05-08
| | | | | | > * Add database and transaction-level triggers > > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00451.php
* Remove OID/foreign key mention in psql variable interpolation docs.Bruce Momjian2008-05-08
|
* Add Simon Riggs' email address.Alvaro Herrera2008-05-07
|
* Move Client Authentication right after Server Configuration in docs.Bruce Momjian2008-05-07
| | | | Scott Marlowe
* Make the pg_stat_activity view call a SRF (pg_stat_get_activity())Magnus Hagander2008-05-07
| | | | | | | instead of calling a bunch of individual functions. This function can also be called directly, taking a PID as an argument, to return only the data for a single PID.
* Fix TODO typo.Bruce Momjian2008-05-07
|
* Add URL forBruce Momjian2008-05-07
| | | | | < * Consider increasing the number of default statistics target, and < reduce statistics target overhead
* Update TODO wording:Bruce Momjian2008-05-07
| | | | | | < o Allow dictionary to filter out only stop words > o Allow dictionaries to change the token that is passed on to > later dictionaries
* Add item, make text search section:Bruce Momjian2008-05-07
| | | | | | | | o Consider changing error to warning for strings larger than one megabyte http://archives.postgresql.org/pgsql-bugs/2008-02/msg00190.php http://archives.postgresql.org/pgsql-patches/2008-03/msg00062.php
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-20 03:56:40 +0000