summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2012-02-07createuser: Disable prompting by defaultPeter Eisentraut
Do not prompt when options were not specified. Assume --no-createdb, --no-createrole, --no-superuser by default. Also disable prompting for user name in dropdb, unless --interactive was specified. reviewed by Josh Kupershmidt
2012-02-04Allow SQL-language functions to reference parameters by name.Tom Lane
Matthew Draper, reviewed by Hitoshi Harada
2012-02-04Remove tabs in SGML file.Bruce Momjian
2012-02-03Add array_to_json and row_to_json functions.Andrew Dunstan
Also move the escape_json function from explain.c to json.c where it seems to belong. Andrew Dunstan, Reviewd by Abhijit Menon-Sen.
2012-02-01initdb: Add options --auth-local and --auth-hostPeter Eisentraut
reviewed by Robert Haas and Pavel Stehule
2012-02-01Implement dry-run mode for pg_archivecleanupAlvaro Herrera
In dry-run mode, just the name of the file to be removed is printed to stdout; this is so the user can easily plug it into another program through a pipe. If debug mode is also specified, a more verbose message is printed to stderr. Author: Gabriele Bartolini Reviewer: Josh Kupershmidt
2012-01-31Built-in JSON data type.Robert Haas
Like the XML data type, we simply store JSON data as text, after checking that it is valid. More complex operations such as canonicalization and comparison may come later, but this is enough for not. There are a few open issues here, such as whether we should attempt to detect UTF-8 surrogate pairs represented as \uXXXX\uYYYY, but this gets the basic framework in place.
2012-01-30Add sequence USAGE privileges to information schemaPeter Eisentraut
The sequence USAGE privilege is sufficiently similar to the SQL standard that it seems reasonable to show in the information schema. Also add some compatibility notes about it on the GRANT reference page.
2012-01-30PL/Python: Add result metadata functionsPeter Eisentraut
Add result object functions .colnames, .coltypes, .coltypmods to obtain information about the result column names and types, which was previously not possible in the PL/Python SPI interface. reviewed by Abhijit Menon-Sen
2012-01-28Add caution about multiple unique indexes breaking plpgsql upsert example.Tom Lane
Per Phil Sorber, though I didn't use his wording exactly.
2012-01-28Update statement about sorting of character-string data.Tom Lane
The sort order is no longer fixed at database creation time, but can be controlled via COLLATE. Noted by Thomas Kellerer.
2012-01-27Use parameterized paths to generate inner indexscans more flexibly.Tom Lane
This patch fixes the planner so that it can generate nestloop-with- inner-indexscan plans even with one or more levels of joining between the indexscan and the nestloop join that is supplying the parameter. The executor was fixed to handle such cases some time ago, but the planner was not ready. This should improve our plans in many situations where join ordering restrictions formerly forced complete table scans. There is probably a fair amount of tuning work yet to be done, because of various heuristics that have been added to limit the number of parameterized paths considered. However, we are not going to find out what needs to be adjusted until the code gets some real-world use, so it's time to get it in there where it can be tested easily. Note API change for index AM amcostestimate functions. I'm not aware of any non-core index AMs, but if there are any, they will need minor adjustments.
2012-01-27Document that COUNT(*) might not need a seq scan any more.Robert Haas
Noted by Josh Kupershmidt.
2012-01-27Document that analyzing an empty table doesn't update the statistics.Robert Haas
Per a suggestion from Sergey Konoplev
2012-01-27Fix copy-paste error in docs.Heikki Linnakangas
Dean Rasheed
2012-01-27Fix wording, per Peter GeogheganMagnus Hagander
2012-01-27Mention in the docs that bgwriter now sleeps longer when it has no work to do.Heikki Linnakangas
2012-01-26Fix sentence in docs: checkpoints are not done by bgwriter anymore.Heikki Linnakangas
2012-01-26Add deadlock counter to pg_stat_databaseMagnus Hagander
Adds a counter that tracks number of deadlocks that occurred in each database to pg_stat_database. Magnus Hagander, reviewed by Jaime Casanova
2012-01-26Track temporary file count and size in pg_stat_databaseMagnus Hagander
Add counters for number and size of temporary files used for spill-to-disk queries for each database to the pg_stat_database view. Tomas Vondra, review by Magnus Hagander
2012-01-25Allow pg_basebackup from standby node with safety checking.Simon Riggs
Base backup follows recommended procedure, plus goes to great lengths to ensure that partial page writes are avoided. Jun Ishizuka and Fujii Masao, with minor modifications
2012-01-25Add pg_trigger_depth() functionAlvaro Herrera
This reports the depth level of triggers currently in execution, or zero if not called from inside a trigger. No catversion bump in this patch, but you have to initdb if you want access to the new function. Author: Kevin Grittner
2012-01-24Add new replication mode synchronous_commit = 'write'.Simon Riggs
Replication occurs only to memory on standby, not to disk, so provides additional performance if user wishes to reduce durability level slightly. Adds concept of multiple independent sync rep queues. Fujii Masao and Simon Riggs
2012-01-23ALTER <thing> [IF EXISTS] ... allows silent DDL if required,Simon Riggs
e.g. ALTER FOREIGN TABLE IF EXISTS foo RENAME TO bar Pavel Stehule
2012-01-22Typo fixMagnus Hagander
Guillaume Lelarge
2012-01-20Get rid of itemizedlist inside tableMagnus Hagander
This renders badly on the website, and in this particular case also doesn't actually add anything to the readability...
2012-01-20Further doc cleanups from the pg_stat_activity changesMagnus Hagander
Fujii Masao
2012-01-19Triggered change notifications.Robert Haas
Kevin Grittner, reviewed (in earlier versions) by Álvaro Herrera
2012-01-19Clarify that bgwriter no longer handles checkpoints.Robert Haas
Text by Peter Geoghegan.
2012-01-19Add bitwise AND, OR, and NOT operators for macaddr data type.Robert Haas
Brendan Jurd, reviewed by Fujii Masao
2012-01-19Separate state from query string in pg_stat_activityMagnus Hagander
This separates the state (running/idle/idleintransaction etc) into it's own field ("state"), and leaves the query field containing just query text. The query text will now mean "current query" when a query is running and "last query" in other states. Accordingly,the field has been renamed from current_query to query. Since backwards compatibility was broken anyway to make that, the procpid field has also been renamed to pid - along with the same field in pg_stat_replication for consistency. Scott Mead and Magnus Hagander, review work from Greg Smith
2012-01-19Make pg_relation_size() and friends return NULL if the object doesn't exist.Heikki Linnakangas
That avoids errors when the functions are used in queries like "SELECT pg_relation_size(oid) FROM pg_class", and a table is dropped concurrently. Phil Sorber
2012-01-18PL/Python: Update examplePeter Eisentraut
Change the usesavedplan() example to use a more modern Python style using the .setdefault() function.
2012-01-16Disallow merging ONLY constraints in children tablesAlvaro Herrera
When creating a child table, or when attaching an existing table as child of another, we must not allow inheritable constraints to be merged with non-inheritable ones, because then grandchildren would not properly get the constraint. This would violate the grandparent's expectations. Bugs noted by Robert Haas. Author: Nikhil Sontakke
2012-01-15Allow a user to kill his own queries using pg_cancel_backend()Magnus Hagander
Allows a user to use pg_cancel_queries() to cancel queries in other backends if they are running under the same role. pg_terminate_backend() still requires superuser permissoins. Short patch, many authors working on the bikeshed: Magnus Hagander, Josh Kupershmidt, Edward Muller, Greg Smith.
2012-01-14Make superuser imply replication privilege. The idea of a privilege thatHeikki Linnakangas
superuser doesn't have doesn't make much sense, as a superuser can do whatever he wants through other means, anyway. So instead of granting replication privilege to superusers in CREATE USER time by default, allow replication connection from superusers whether or not they have the replication privilege. Patch by Noah Misch, per discussion on bug report #6264
2012-01-10Support CREATE TABLE (LIKE ...) with foreign tables and viewsPeter Eisentraut
Composite types are not yet supported, because parserOpenTable() rejects them.
2012-01-09Add compatibility note about grant options on GRANT reference pagePeter Eisentraut
Point out in the compatibility section that granting grant options to PUBLIC is not supported by PostgreSQL. This is already mentioned earlier, but since it concerns the information schema, it might be worth pointing out explicitly as a compatibility issue.
2012-01-07Rename the internal structures of the CREATE TABLE (LIKE ...) facilityPeter Eisentraut
The original implementation of this interpreted it as a kind of "inheritance" facility and named all the internal structures accordingly. This turned out to be very confusing, because it has nothing to do with the INHERITS feature. So rename all the internal parser infrastructure, update the comments, adjust the error messages, and split up the regression tests.
2012-01-06Fix typo, pg_types_date.h => pgtypes_date.h.Tom Lane
Spotted by Koizumi Satoru.
2012-01-05Improve ALTER DOMAIN / DROP CONSTRAINT with nonexistent constraintPeter Eisentraut
ALTER DOMAIN / DROP CONSTRAINT on a nonexistent constraint name did not report any error. Now it reports an error. The IF EXISTS option was added to get the usual behavior of ignoring nonexistent objects to drop.
2012-01-03Support for building with MS Visual Studio 2010.Andrew Dunstan
Brar Piening, reviewed by Craig Ringer.
2012-01-01Update copyright notices for year 2012.Bruce Momjian
2011-12-31Send new protocol keepalive messages to standby servers.Simon Riggs
Allows streaming replication users to calculate transfer latency and apply delay via internal functions. No external functions yet.
2011-12-26Minor enhancements to MVCC chapterAlvaro Herrera
Author: Erik Rijkers
2011-12-24Rethink representation of index clauses' mapping to index columns.Tom Lane
In commit e2c2c2e8b1df7dfdb01e7e6f6191a569ce3c3195 I made use of nested list structures to show which clauses went with which index columns, but on reflection that's a data structure that only an old-line Lisp hacker could love. Worse, it adds unnecessary complication to the many places that don't much care which clauses go with which index columns. Revert to the previous arrangement of flat lists of clauses, and instead add a parallel integer list of column numbers. The places that care about the pairing can chase both lists with forboth(), while the places that don't care just examine one list the same as before. The only real downside to this is that there are now two more lists that need to be passed to amcostestimate functions in case they care about column matching (which btcostestimate does, so not passing the info is not an option). Rather than deal with 11-argument amcostestimate functions, pass just the IndexPath and expect the functions to extract fields from it. That gets us down to 7 arguments which is better than 11, and it seems more future-proof against likely additions to the information we keep about an index path.
2011-12-23Add bytea_agg, parallel to string_agg.Robert Haas
Pavel Stehule
2011-12-22Typo fixes.Robert Haas
All noted by Jaime Casanova.
2011-12-22Add a security_barrier option for views.Robert Haas
When a view is marked as a security barrier, it will not be pulled up into the containing query, and no quals will be pushed down into it, so that no function or operator chosen by the user can be applied to rows not exposed by the view. Views not configured with this option cannot provide robust row-level security, but will perform far better. Patch by KaiGai Kohei; original problem report by Heikki Linnakangas (in October 2009!). Review (in earlier versions) by Noah Misch and others. Design advice by Tom Lane and myself. Further review and cleanup by me.
2011-12-22Add ALTER DOMAIN ... RENAMEPeter Eisentraut
You could already rename domains using ALTER TYPE, but with this new command it is more consistent with how other commands treat domains as a subcategory of types.
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-22 18:44:03 +0000