aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add new FAQ information.Bruce Momjian2005-08-10
| | | | Martijn van Oosterhout
* Extend pg_config to be able to report the build-time values of CC,Tom Lane2005-08-09
| | | | | | CPPFLAGS, CFLAGS, CFLAGS_SL, LDFLAGS, LDFLAGS_SL, and LIBS. Change it so that invoking pg_config with no arguments reports all available information, rather than just giving an error message. Per discussion.
* Combine entries:Bruce Momjian2005-08-09
| | | | | | < inheritance < * Allow enable_constraint_exclusion to work for UPDATE and DELETE queries > inheritance, and allow it to work for UPDATE and DELETE queries
* Done:Bruce Momjian2005-08-09
| | | | > * -Add C code on Unix to copy directories for use in creating new databases
* Fix ordering of default sync options to match code.Bruce Momjian2005-08-09
|
* Update patches queue URL, description.Bruce Momjian2005-08-09
|
* Done:Bruce Momjian2005-08-09
| | | | > * -Allow multiple blocks to be written to WAL with one write()
* Clarify wal_sync_method options in documentation.Bruce Momjian2005-08-09
|
* Done:Bruce Momjian2005-08-08
| | | | > o -Allow FOR UPDATE queries to do NOWAIT locks
* ALTER TABLE OWNER must change the ownership of the table's rowtype too.Tom Lane2005-08-04
| | | | | | | | | | | | | This was not especially critical before, but it is now that we track ownership dependencies --- the dependency for the rowtype *must* shift to the new owner. Spotted by Bernd Helmle. Also fix a problem introduced by recent change to allow non-superusers to do ALTER OWNER in some cases: if the table had a toast table, ALTER OWNER failed *even for superusers*, because the test being applied would conclude that the new would-be owner had no create rights on pg_toast. A side-effect of the fix is to disallow changing the ownership of indexes or toast tables separately from their parent table, which seems a good idea on the whole.
* Done:Bruce Momjian2005-08-03
| | | | | < * Prevent inherited tables from expanding temporary subtables of other > * -Prevent inherited tables from expanding temporary subtables of other
* Code and docs review for pg_column_size() patch.Tom Lane2005-08-02
|
* Add NOWAIT option to SELECT FOR UPDATE/SHARE.Tom Lane2005-08-01
| | | | | Original patch by Hans-Juergen Schoenig, revisions by Karel Zak and Tom Lane.
* nor -> or.Bruce Momjian2005-08-01
|
* Documentation for ALTER object SET SCHEMA commands. Also some minorTom Lane2005-08-01
| | | | editorialization.
* Done:Bruce Momjian2005-08-01
| | | | > * -Allow limits on per-db/role connections
* Done:Bruce Momjian2005-08-01
| | | | | | | | | | | | < o Allow objects to be moved to different schemas > o -Allow objects to be moved to different schemas Fix word wrap: < * Allow GRANT/REVOKE permissions to be applied to all schema objects with one < command > o Allow GRANT/REVOKE permissions to be applied to all schema objects > with one command
* Add description:Bruce Momjian2005-08-01
| | | | | | | | | | < This would require a new global table that is dumped to flat file for < use by the postmaster. We do a similar thing for pg_shadow currently. > This would add a function to load the SQL table from > pg_hba.conf, and one to writes its contents to the flat file. > The table should have a line number that is a float so rows > can be inserted between existing rows, e.g. row 2.5 goes > between row 2 and row 3.
* Add per-user and per-database connection limit options.Tom Lane2005-07-31
| | | | | This patch also includes preliminary update of pg_dumpall for roles. Petr Jelinek, with review by Bruce Momjian and Tom Lane.
* Suggest syntax:Bruce Momjian2005-07-31
| | | | | | < o Allow postgresql.conf file values to be changed via an SQL API > o Allow postgresql.conf file values to be changed via an SQL > API, perhaps using SET GLOBAL
* Add item to sentence:Bruce Momjian2005-07-31
| | | | | | < * Allow server logs to be remotely read using SQL commands 151a151 > * Allow server logs to be remotely read and removed using SQL commands
* Spacing improvement.Bruce Momjian2005-07-31
|
* Fix broken markup and spelling, put paragraph in a somewhat less randomTom Lane2005-07-30
| | | | place.
* More vacuum markup fixes. AlvaroBruce Momjian2005-07-30
|
* Fix VACUUM sgml markup.Bruce Momjian2005-07-30
|
* Patch to mention cost-based delay in vacuum referenceBruce Momjian2005-07-30
| | | | Alvaro Herrera
* Add GUC variables to control keep-alive times for idle, interval, andBruce Momjian2005-07-30
| | | | | | count. Oliver Jowett
* Please find attached diffs for documentation and simple regressionBruce Momjian2005-07-30
| | | | | | | | | tests for the new interval->day changes. I added tests for justify_hours() and justify_days() to interval.sql, as they take interval input and produce interval output. If there's a more appropriate place for them, please let me know. Michael Glaesemann
* Add constraint exclusion items:Bruce Momjian2005-07-30
| | | | | | | | | < > * Allow EXPLAIN to identify tables that were skipped because of > enable_constraint_exclusion > * Allow EXPLAIN output to be more easily processed by scripts 760a763 > * Allow enable_constraint_exclusion to work for UPDATE and DELETE queries
* Add:Bruce Momjian2005-07-30
| | | | | | < > * Allow enable_constraint_exclusion to work for UNIONs like it does for > inheritance
* Add:Bruce Momjian2005-07-30
| | | | | > * Prevent inherited tables from expanding temporary subtables of other > sessions
* Add:Bruce Momjian2005-07-30
| | | | | | | > * Add system view to show free space map contents 884c885 < o Move into the backend code > o -Move into the backend code
* Add:Bruce Momjian2005-07-30
| | | | > * Allow SELECT ... FOR UPDATE on inherited tables
* Clarify:Bruce Momjian2005-07-30
| | | | | < * Add TRUNCATE permission > * Add a separate TRUNCATE permission
* Add:Bruce Momjian2005-07-30
| | | | | | | | > * Add TRUNCATE permission > > Currently only the owner can TRUNCATE a table because triggers are not > called, and the table is locked in exclusive mode. >
* Add:Bruce Momjian2005-07-30
| | | | > * Add PQescapeIdentifier() to libpq
* Add detail:Bruce Momjian2005-07-29
| | | | | | | > > If CRC check fails during recovery, remember the page in case > a later CRC for that page properly matches. >
* Move reindexdb from /contrib to /bin.Bruce Momjian2005-07-29
| | | | Euler Taveira de Oliveira
* Move dbsize functions into the backend. New functions:Bruce Momjian2005-07-29
| | | | | | | | | | | | pg_tablespace_size pg_database_size pg_relation_size pg_complete_relation_size pg_size_pretty Remove /contrib/dbsize. Dave Page
* I've had this small patch in my local tree for a while. It documentsBruce Momjian2005-07-29
| | | | | | new commands which may make an SPI call fail. Alvaro Herrera
* Done:Bruce Momjian2005-07-29
| | | | | | | < * Consider use of open/fcntl(O_DIRECT) to minimize OS caching, < especially for WAL writes > * -Consider use of open/fcntl(O_DIRECT) to minimize OS caching, > for WAL writes
* Add some missing SGML markup.Neil Conway2005-07-27
|
* Basic documentation for ROLEs. The user-manag chapter still needs toTom Lane2005-07-26
| | | | be rewritten, but at least the reference pages are reasonably sane.
* Add a role property 'rolinherit' which, when false, denotes that the roleTom Lane2005-07-26
| | | | | | | | | doesn't automatically inherit the privileges of roles it is a member of; for such a role, membership in another role can be exploited only by doing explicit SET ROLE. The default inherit setting is TRUE, so by default the behavior doesn't change, but creating a user with NOINHERIT gives closer adherence to our current reading of SQL99. Documentation still lacking, and I think the information schema needs another look.
* Add pg_has_role() family of privilege inquiry functions modeled after theTom Lane2005-07-26
| | | | | | | existing ones for object privileges. Update the information_schema for roles --- pg_has_role() makes this a whole lot easier, removing the need for most of the explicit joins with pg_user. The views should be a tad faster now, too. Stephen Frost and Tom Lane.
* Add SET ROLE. This is a partial commit of Stephen Frost's recent patch;Tom Lane2005-07-25
| | | | I'm still working on the has_role function and information_schema changes.
* Add:Bruce Momjian2005-07-25
| | | | | > o Allow postgresql.conf file values to be changed via an SQL API > o Allow the server to be stopped/restarted via an SQL API
* With the interval/day patch, the horology regression test no longerTom Lane2005-07-24
| | | | | | fails near DST transition days, so remove the advice about that testing problem. Also improve the description of variant-comparison-file selection.
* Simple constraint exclusion. For now, only child tables of inheritanceTom Lane2005-07-23
| | | | | scans are candidates for exclusion; this should be fixed eventually. Simon Riggs, with some help from Tom Lane.
* Fix AT TIME ZONE for timestamps without time zones:Bruce Momjian2005-07-22
| | | | | | | | | | test=> select ('2005-07-20 00:00:00'::timestamp without time zone) at time zone 'Europe/Paris'; timezone ------------------------ 2005-07-19 22:00:00-04 Udpate documentation.
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-23 05:47:06 +0000