aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add:Bruce Momjian2005-07-21
| | | | | < > * Research storing disk pages with no alignment/padding
* Fix breakage of INSTALL document build.Tom Lane2005-07-20
|
* Add 'day' field to INTERVAL so 1 day interval can be distinguished fromBruce Momjian2005-07-20
| | | | | | | | | | | | | | | | 24 hours. This is very helpful for daylight savings time: select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours'; ?column? ---------------------- 2005-05-04 01:00:00-04 select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day'; ?column? ---------------------- 2005-05-04 01:00:00-04 Michael Glaesemann
* Documentation tweak: make <command>CREATE OPERATOR CLASS</command> intoNeil Conway2005-07-19
| | | | an <xref/>.
* Fix some bogosities in geometric-function documentation: add an entryTom Lane2005-07-18
| | | | | | | | for circle(polygon), which was missing; remove bogus entry for point(lseg, lseg), which does not exist, and the documentation seemed to describe lseg_interpt, which we already document as an operator not a function. Also remove entry for box_intersect, which likewise is preferentially used via the operator #.
* \pset numericsep -> numericlocale.Bruce Momjian2005-07-18
|
* Fix SGML spacing.Bruce Momjian2005-07-15
|
* Change numericsep to a boolean, and make it locale-aware.Bruce Momjian2005-07-14
|
* This doc patch replaces all inappropriate references to SQL:1999 when itNeil Conway2005-07-14
| | | | | is used as if it were the latest (and/or still valid) SQL standard. SQL:2003 is used in its place. Patch from Simon Riggs.
* Integrate autovacuum functionality into the backend. There's still aTom Lane2005-07-14
| | | | | few loose ends to be dealt with, but it seems to work. Alvaro Herrera, based on the contrib code by Matthew O'Connor.
* Documentation for some new PL/Perl features. Patch from David Fetter,Neil Conway2005-07-13
| | | | various editorialization from Neil Conway.
* Change typreceive function API so that receive functions get the sameTom Lane2005-07-10
| | | | | | | optional arguments as text input functions, ie, typioparam OID and atttypmod. Make all the datatypes that use typmod enforce it the same way in typreceive as they do in typinput. This fixes a problem with failure to enforce length restrictions during COPY FROM BINARY.
* Add --encoding to pg_dump.Bruce Momjian2005-07-10
| | | | | | | | | | | | The Problem: Occassionally a DBA needs to dump a database to a new encoding. In instances where the current encoding, (or lack of an encoding, like SQL_ASCII) is poorly supported on the target database server, it can be useful to dump into a particular encoding. But, currently the only way to set the encoding of a pg_dump file is to change client_encoding in postgresql.conf and restart postmaster. This is more than a little awkward for production systems. Magnus Hagander
* Update.Bruce Momjian2005-07-10
| | | | | | | | < computations should adjust based on the time zone rules, e.g. < adding 24 hours to a timestamp would yield a different result from < adding one day. < > computations should adjust based on the time zone rules.
* I made the patch that implements regexp_replace again.Bruce Momjian2005-07-10
| | | | | | | | | | | | | | | | | | | | | | | The specification of this function is as follows. regexp_replace(source text, pattern text, replacement text, [flags text]) returns text Replace string that matches to regular expression in source text to replacement text. - pattern is regular expression pattern. - replacement is replace string that can use '\1'-'\9', and '\&'. '\1'-'\9': back reference to the n'th subexpression. '\&' : entire matched string. - flags can use the following values: g: global (replace all) i: ignore case When the flags is not specified, case sensitive, replace the first instance only. Atsushi Ogawa
* Add psql \pset numericsep to allow output numbers like 100,000.0 orBruce Momjian2005-07-10
| | | | | | 100.000,0. Eugen Nedelcu
* Done:Bruce Momjian2005-07-08
| | | | > * -Prevent dropping user that still owns objects, or auto-drop the objects
* Track dependencies on shared objects (which is to say, roles; we alreadyTom Lane2005-07-07
| | | | | | | have adequate mechanisms for tracking the contents of databases and tablespaces). This solves the longstanding problem that you can drop a user who still owns objects and/or has access permissions. Alvaro Herrera, with some kibitzing from Tom Lane.
* Update:Bruce Momjian2005-07-07
| | | | | | | < writer. > writer. It might cause problems for applying WAL on recovery > into a partially-written page, but later the full page will be > replaced from WAL.
* Update:Bruce Momjian2005-07-07
| | | | | | | | | | | | > > o -Add ability to turn off full page writes > o When off, write CRC to WAL and check file system blocks > on recovery > o Write full pages during file system write and not when > the page is modified in the buffer cache > > This allows most full page writes to happen in the background > writer.
* Reverse out because the lack of using pgport in timezone/ is causingBruce Momjian2005-07-06
| | | | | | | | | | problems: --------------------------------------------------------------------------- Support cross compilation by compiling "zic" with a native compiler. This relies on the output of zic being platform independent, but that is currently the case.
* Add pg_column_size() to return storage size of a column, includingBruce Momjian2005-07-06
| | | | | | possible compression. Mark Kirkwood
* Update description of GUC full_page_writes.Bruce Momjian2005-07-06
| | | | Michael Paesold
* Done:Bruce Momjian2005-07-06
| | | | > * -Add function to return compressed length of TOAST data values
* Add GUC full_page_writes to control writing full pages to WAL.Bruce Momjian2005-07-05
|
* Remove, now have GUC:Bruce Momjian2005-07-05
| | | | | | | < * Turn off full page writes if fsync is disabled < < If fsync is off, there is no purpose in writing full pages to WAL <
* Add:Bruce Momjian2005-07-05
| | | | | | | < 881a881,882 > o Improve xid wraparound detection by recording per-table rather > than per-database
* More TODO list section restructuring.Bruce Momjian2005-07-04
|
* Restructure TODO sections.Bruce Momjian2005-07-04
|
* UpdateBruce Momjian2005-07-04
| | | | | | | | > * Allow GIST indexes to create certain complex index types, like digital > trees (see Aoki) > 783a787 >
* Update wording:Bruce Momjian2005-07-04
| | | | | | | | < Currently, to protect against partial disk page writes, we write the > Currently, to protect against partial disk page writes, we write 877c877 < * Turn off after-change writes if fsync is disabled > * Turn off full page writes if fsync is disabled
* Support cross compilation by compiling "zic" with a native compiler. ThisPeter Eisentraut2005-07-03
| | | | | relies on the output of zic being platform independent, but that is currently the case.
* Remove GIST concurrency limitations section.Bruce Momjian2005-07-02
| | | | Christopher Kings-Lynne
* Add SGML markup for on/off values in run-time section.Bruce Momjian2005-07-02
|
* Use on/off consistently for GUC variables in postgresql.conf and theBruce Momjian2005-07-02
| | | | documentation, to match SHOW.
* Update:Bruce Momjian2005-07-02
| | | | | < * Add rtree index support for line, lseg, path, point > * Add more gist index support for geometric data types
* In PL/PgSQL, allow a block's label to be optionally specified at theNeil Conway2005-07-02
| | | | | | | | | | | | | end of the block: <<label>> begin ... end label; Similarly for loops. This is per PL/SQL. Update the documentation and add regression tests. Patch from Pavel Stehule, code review by Neil Conway.
* Clarify:Bruce Momjian2005-07-01
| | | | | | | < o Replace crude DELETE FROM method of pg_dumpall for cleaning of < roles with separate DROP commands > o Replace crude DELETE FROM method of pg_dumpall --clean for > cleaning of roles with separate DROP commands
* Update for roles:Bruce Momjian2005-07-01
| | | | | | | | | | | | | | | | | < * Allow limits on per-db/user connections > * Allow limits on per-db/role connections < * Prevent default re-use of sysids for dropped users and roles < < Currently, if a user is removed while he still owns objects, a new < user given might be given their user id and inherit the < previous users objects. < 450c444 < * Add COMMENT ON for all cluster global objects (users, roles, databases > * Add COMMENT ON for all cluster global objects (roles, databases 609c603 < users and roles with separate DROP commands > roles with separate DROP commands
* Update for roles:Bruce Momjian2005-07-01
| | | | | | | | | | | < * Prevent default re-use of sysids for dropped users and groups > * Prevent default re-use of sysids for dropped users and roles 450c450 < * Add COMMENT ON for all cluster global objects (users, groups, databases > * Add COMMENT ON for all cluster global objects (users, roles, databases 609c609 < users and groups with separate DROP commands > users and roles with separate DROP commands
* Item superceeded now that groups exist:Bruce Momjian2005-07-01
| | | | | < * Add group object ownership, so groups can rename/drop/grant on objects, < so we can implement roles
* Done:Bruce Momjian2005-07-01
| | | | > o -Add dumping and restoring of LOB comments
* Clarify documentation about log_min_duration_statement.Bruce Momjian2005-07-01
|
* Improve gettimeofday() documentation.Bruce Momjian2005-06-29
| | | | Karl O. Pinc
* Improved words spacing.Bruce Momjian2005-06-29
| | | | Victor Y. Yegorov
* Replace pg_shadow and pg_group by new role-capable catalogs pg_authidTom Lane2005-06-28
| | | | | | | | and pg_auth_members. There are still many loose ends to finish in this patch (no documentation, no regression tests, no pg_dump support for instance). But I'm going to commit it now anyway so that Alvaro can make some progress on shared dependencies. The catalog changes should be pretty much done.
* Done:Bruce Momjian2005-06-27
| | | | > * -Add concurrency to GIST
* Done:Bruce Momjian2005-06-27
| | | | > * -Remove kerberos4 from source tree
* Remove support for Kerberos V4. It seems no one is using this, it hasNeil Conway2005-06-27
| | | | | some security issues, and upstream has declared it "dead". Patch from Magnus Hagander, minor editorialization from Neil Conway.
* Done:Bruce Momjian2005-06-27
| | | | > o -Allow PL/pgSQL EXECUTE query_var INTO record_var;
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-23 17:57:48 +0000