summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2007-02-21Allow pltcl args to spi_prepare and plpython args to plpy.prepare to be ↵Andrew Dunstan
standard type aliases as well as those known in pg_type. Similar to recent change in plperl.
2007-02-21Add URL for:Bruce Momjian
o Allow row and record variables to be set to NULL constants, and allow NULL tests on such variables
2007-02-20Add:Bruce Momjian
> > * Consider decreasing the amount of memory used by PrivateRefCount > > http://archives.postgresql.org/pgsql-hackers/2006-11/msg00797.php > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php >
2007-02-20Fix markup.Bruce Momjian
2007-02-20Add:Bruce Momjian
> * Increase locking when DROPing objects so dependent objects cannot > get dropped while the DROP operation is happening > > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00937.php
2007-02-20Add URL for:Bruce Momjian
o Allow UPDATE/DELETE WHERE CURRENT OF cursor > http://archives.postgresql.org/pgsql-hackers/2007-01/msg01014.php
2007-02-20Add:Bruce Momjian
> > * Add missing operators for geometric data types > > Some geometric types do not have the full suite of geometric operators, > e.g. box @> point >
2007-02-20Update "encode" documentation to mention that 'escape' only changes nullBruce Momjian
bytes and backslashes, remove "ASCII" mention. Backpatch to 8.2.X.
2007-02-20Update pgpass Win32 wording.Bruce Momjian
2007-02-20Update information_schema documentation to match system tables.Bruce Momjian
Backpatch to 8.2.X.
2007-02-20Wording improvement.Bruce Momjian
2007-02-20More clearly document that most PostgreSQL utilities support libpqBruce Momjian
environment variables. Backpatch to 8.2.X.
2007-02-20Adjust user-facing documentation to explain why we don't check pgpassTom Lane
file permissions on Windows.
2007-02-20Remove, item not needed for Win32:Bruce Momjian
< o Check .pgpass file permissions >
2007-02-20Remove "History" sections for pg_dump and pg_restore. I don't thinkBruce Momjian
anyone cares because the last history change was for PostgreSQL 7.1.
2007-02-20Spell check on array patch.Bruce Momjian
2007-02-20Add for WIN32:Bruce Momjian
< > o Check .pgpass file permissions
2007-02-20Update array slice documentation to be clearer.Bruce Momjian
2007-02-20Add:Bruce Momjian
> * Fix IS OF so it matches the ISO specification, and add documentation > > http://archives.postgresql.org/pgsql-patches/2003-08/msg00060.php > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00060.php
2007-02-20Comment-out documentation for IS OF because it doesn't conform to theBruce Momjian
ISO SQL behavior. Backpatch removal to 8.2.X.
2007-02-20Remove item:Bruce Momjian
< o ARRAY[[1,2],[3,4]])[1] should return the same values as < ARRAY[[1,2],[3,4]])[1:1]; <
2007-02-20Document IS [NOT] OF, which was added in 7.3.Bruce Momjian
2007-02-19Add FAQ text about Makefile.custom:Bruce Momjian
<P><I>src/Makefile.custom</I> can be used to set environment variables, like <I>CUSTOM_COPT</I>, that are used for every compile.
2007-02-19Document that to_char('J'/Julian) is midnight-based, per report thatBruce Momjian
Julian technically is noon to noon.
2007-02-19Wording improvement.Bruce Momjian
2007-02-19Update PQfree() documentation to be clearer, backpatch to 8.2.X.Bruce Momjian
2007-02-19Update wording:Bruce Momjian
< * Consider allowing configuration of TOAST thresholds > * Allow user configuration of TOAST thresholds
2007-02-19Add:Bruce Momjian
> * Consider allowing configuration of TOAST thresholds > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00213.php >
2007-02-19Add newlines.Bruce Momjian
2007-02-19Add:Bruce Momjian
> * Allow UPDATEs on only non-referential integrity columns not to conflict > with referential integrity locks > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00073.php
2007-02-19Add:Bruce Momjian
> * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause > > http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php > http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php >
2007-02-19Clarify documentation that initdb -A or editing pg_hba.conf is requiredBruce Momjian
if you do not trust local users.
2007-02-19Clarify documentation for "day of the week" handling for to_char() andBruce Momjian
EXTRACT().
2007-02-19Done:Bruce Momjian
> * -Add ISO day of week format 'ID' to to_char() where Monday = 1
2007-02-19Add "isodow" option to EXTRACT() and date_part() where Sunday = 7.Bruce Momjian
2007-02-19Done:Bruce Momjian
> * -Add a field 'isoyear' to extract(), based on the ISO week
2007-02-19Done:Bruce Momjian
< o Add long file support for binary pg_dump output < < While Win32 supports 64-bit files, the MinGW API does not, < meaning we have to build an fseeko replacement on top of the < Win32 API, and we have to make sure MinGW handles it. Another < option is to wait for the MinGW project to fix it, or use the < code from the LibGW32C project as a guide. < < http://archives.postgresql.org/pgsql-hackers/2006-12/msg00551.php < > o -Add long file support for binary pg_dump output
2007-02-18Document limitation of SPI_execute() using multiple queries in a singleBruce Momjian
string.
2007-02-18Update wording:Bruce Momjian
< Currently, ALTER USER and ALTER DATABASE support per-user and > Currently ALTER USER and ALTER DATABASE support per-user and < Currently, subtracting one date from another that crosses a > Currently subtracting one date from another that crosses a < Currently, SQL-language functions can only refer to parameters via $1, etc > Currently SQL-language functions can only refer to dollar parameters, > e.g. $1 < Currently, queries prepared via the libpq API are planned on first > Currently queries prepared via the libpq API are planned on first < Currently, SET <tab> causes a database lookup to check all > Currently SET <tab> causes a database lookup to check all < Currently, all statement results are transferred to the libpq > Currently all statement results are transferred to the libpq
2007-02-18Add:Bruce Momjian
* Allow SQL-language functions to reference parameters by parameter name Currently SQL-language functions can only refer to parameters via $1, etc
2007-02-18Update "Conflicting lock modes" to show as conflict, addBruce Momjian
current/requested headings, add link to table from text.
2007-02-17Add:Bruce Momjian
> * Allow holdable cursors in SPI
2007-02-17Add:Bruce Momjian
> > o Allow row and record variables to be set to NULL constants, > and allow NULL tests on such variables > > Because a row is not scalar, do not allow assignment > from NULL-valued scalars.
2007-02-17Remove installation mention that integer timestamps is less stable thatBruce Momjian
floating point.
2007-02-16Add:Bruce Momjian
> o Consider reducing on-disk varlena length from four to two > because a heap row cannot be more than 64k in length
2007-02-16Fix markup, spelling, grammar, and explanations for SSLKEY patch.Tom Lane
2007-02-16Functions for mapping table data and table schemas to XML (a.k.a. XML export)Peter Eisentraut
2007-02-16Remove extra character erroneously added.Bruce Momjian
2007-02-16Remove tabs from SGML files to help tag alingment and improveBruce Momjian
detection of tabs are added in the future.
2007-02-16Add two new format fields for use with to_char(), to_date() andBruce Momjian
to_timestamp(): - ID for day-of-week - IDDD for day-of-year This makes it possible to convert ISO week dates to and from text fully represented in either week ('IYYY-IW-ID') or day-of-year ('IYYY-IDDD') format. I have also added an 'isoyear' field for use with extract / date_part. Brendan Jurd
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-02 16:38:35 +0000