user/sven/postgresql.git

Age	Commit message (Collapse)	Author
2011-07-18	Create a "fast path" for acquiring weak relation locks.	Robert Haas
	When an AccessShareLock, RowShareLock, or RowExclusiveLock is requested on an unshared database relation, and we can verify that no conflicting locks can possibly be present, record the lock in a per-backend queue, stored within the PGPROC, rather than in the primary lock table. This eliminates a great deal of contention on the lock manager LWLocks. This patch also refactors the interface between GetLockStatusData() and pg_lock_status() to be a bit more abstract, so that we don't rely so heavily on the lock manager's internal representation details. The new fast path lock structures don't have a LOCK or PROCLOCK structure to return, so we mustn't depend on that for purposes of listing outstanding locks. Review by Jeff Davis.
2011-07-18	Remove claim that the project is not represented in the SQL working group	Peter Eisentraut
	We have a few people involved there now.
2011-07-18	Note that information_schema.sql_languages was removed in SQL:2008	Peter Eisentraut

2011-07-17	Add pg_opfamily_is_visible.	Robert Haas
	We already have similar functions for many other object types, including operator classes, so it seems like we should have this one, too. Extracted from a larger patch by Josh Kupershmidt
2011-07-17	Add temp_file_limit GUC parameter to constrain temporary file space usage.	Tom Lane
	The limit is enforced against the total amount of temp file space used by each session. Mark Kirkwood, reviewed by Cédric Villemain and Tatsuo Ishii
2011-07-16	Add an errdetail_internal() ereport auxiliary routine.	Tom Lane
	This function supports untranslated detail messages, in the same way that errmsg_internal supports untranslated primary messages. We've needed this for some time IMO, but discussion of some cases in the SSI code provided the impetus to actually add it. Kevin Grittner, with minor adjustments by me
2011-07-15	Set information_schema.tables.commit_action to null	Peter Eisentraut
	The commit action of temporary tables is currently not cataloged, so we can't easily show it. The previous value was outdated from before we had different commit actions.
2011-07-15	Doc clarification for pg_locks columns.	Bruce Momjian
	Florian Pflug
2011-07-14	In docs, start window function sentence with "The asterisk (*)" rather	Bruce Momjian
	than "*"; it is confusing to start a sentence with a symbol.
2011-07-14	Fix broken markup	Alvaro Herrera

2011-07-14	Set information_schema.routines.is_udt_dependent to NO	Peter Eisentraut
	It previously said YES, but that is incorrect.
2011-07-14	Small update on suggested startup file locations	Peter Eisentraut
	Debian/Ubuntu don't have a /etc/rc.d/ directory, so add some alternative names as suggestions.
2011-07-13	Implement information schema interval_type columns	Peter Eisentraut
	Also correct reporting of interval precision when field restrictions are specified in the typmod.
2011-07-13	Use clearer woring for pg_locks columns, identifying which items are	Bruce Momjian
	related to lock objects.
2011-07-11	Fix and clarify information schema interval_precision fields	Peter Eisentraut
	The fields were previously wrongly typed as character_data; change to cardinal_number. Update the documentation and the implementation to show more clearly that this applies to a feature not available in PostgreSQL, rather than just not yet being implemented in the information schema.
2011-07-11	Improve wording of documentation on default privileges.	Andrew Dunstan
	Per recent -hackers discussion.
2011-07-08	Add item about Clang support to 9.1 release notes	Peter Eisentraut

2011-07-08	Message style improvements	Peter Eisentraut

2011-07-07	Update examples for string-related functions.	Tom Lane
	In the example for decode(), show the bytea result in hex format, since that's now the default. Use an E'' string in the example for quote_literal(), so that it works regardless of the standard_conforming_strings setting. On the functions-for-binary-strings page, leave the examples as-is for readability, but add a note pointing out that they are shown in escape format. Per comments from Thom Brown. Also, improve the description for encode() and decode() a tad. Backpatch to 9.0, where bytea_output was introduced.
2011-07-07	Update 9.1 release notes to reflect commits through today.	Tom Lane

2011-07-07	Reclassify replication-related GUC variables as "master" and "standby".	Tom Lane
	Per discussion, this structure seems more understandable than what was there before. Make config.sgml and postgresql.conf.sample agree. In passing do a bit of editorial work on the variable descriptions.
2011-07-07	Finish disabling reduced-lock-levels-for-DDL feature.	Tom Lane
	Previous patch only covered the ALTER TABLE changes, not changes in other commands; and it neglected to revert the documentation changes.
2011-07-06	Add \ir command to psql.	Robert Haas
	\ir is short for "include relative"; when used from a script, the supplied pathname will be interpreted relative to the input file, rather than to the current working directory. Gurjeet Singh, reviewed by Josh Kupershmidt, with substantial further cleanup by me.
2011-07-05	Restructure foreign data wrapper chapter so it has more than one section.	Tom Lane
	As noted by Laurenz Albe, our SGML tools deal rather oddly with chapters having just one <sect1>. Perhaps the tooling could be fixed, but really the design of this chapter's introduction is pretty bogus anyhow. Split it into a true introduction and a <sect1> about the FDW functions, so that it reads better and dodges the lack-of-a-chapter-TOC problem.
2011-07-05	Improve documentation about foreign data wrapper validator functions.	Tom Lane
	Modified version of a patch by Shigeru Hanada.
2011-07-05	Fix typo in sslmode documentation	Magnus Hagander
	Per bug #6089, noted by Sidney Cadot
2011-07-05	Small documentation tweaks	Peter Eisentraut

2011-07-04	Set user_defined_types.data_type to null	Peter Eisentraut
	On re-reading the standard, this field is only used for distinct or reference types.
2011-07-04	Clarify that you need ActiveState perl 5.8 or later to build on Windows.	Heikki Linnakangas

2011-07-04	Remove silent_mode. You get the same functionality with "pg_ctl -l	Heikki Linnakangas
	postmaster.log", or nohup. There was a small issue with LINUX_OOM_ADJ and silent_mode, namely that with silent_mode the postmaster process incorrectly used the OOM settings meant for backend processes. We certainly could've fixed that directly, but since silent_mode was redundant anyway, we might as well just remove it.
2011-07-04	Reset ALTER TABLE lock levels to AccessExclusiveLock in all cases.	Simon Riggs
	Locks on inheritance parent remain at lower level, as they were before. Remove entry from 9.1 release notes.
2011-07-03	Fix omissions in documentation of the pg_roles view.	Tom Lane
	Somehow, column rolconfig got removed from the documentation of the pg_roles view in the 9.0 cycle, although the column is actually still there. In 9.1, we'd also forgotten to document the rolreplication column. Spotted by Sakamoto Masahiko.
2011-07-01	In the pg_upgrade docs, move 50432 port mention to the place where we	Bruce Momjian
	talk about client access.
2011-07-01	Change pg_upgrade to use port 50432 by default to avoid unintended	Bruce Momjian
	client connections during the upgrade. Also rename data/bin/port environment variables to being with 'PG'. Also no longer honor PGPORT.
2011-06-30	Enable CHECK constraints to be declared NOT VALID	Alvaro Herrera
	This means that they can initially be added to a large existing table without checking its initial contents, but new tuples must comply to them; a separate pass invoked by ALTER TABLE / VALIDATE can verify existing data and ensure it complies with the constraint, at which point it is marked validated and becomes a normal part of the table ecosystem. An non-validated CHECK constraint is ignored in the planner for constraint_exclusion purposes; when validated, cached plans are recomputed so that partitioning starts working right away. This patch also enables domains to have unvalidated CHECK constraints attached to them as well by way of ALTER DOMAIN / ADD CONSTRAINT / NOT VALID, which can later be validated with ALTER DOMAIN / VALIDATE CONSTRAINT. Thanks to Thom Brown, Dean Rasheed and Jaime Casanova for the various reviews, and Robert Hass for documentation wording improvement suggestions. This patch was sponsored by Enova Financial.
2011-06-29	Unify spelling of "canceled", "canceling", "cancellation"	Peter Eisentraut
	We had previously (af26857a2775e7ceb0916155e931008c2116632f) established the U.S. spellings as standard.
2011-06-28	Implement the collation columns of various information schema views	Peter Eisentraut
	Fill in the collation columns of the views attributes, columns, domains, and element_types. Also update collation information in sql_implementation_info.
2011-06-28	Add composite-type attributes to information_schema.element_types view	Peter Eisentraut

2011-06-27	Mention that SSPI authentication can use GSSAPI on non-Windows systems.	Robert Haas
	As noted by Christian Ullrich.
2011-06-24	Documentation improvements for pg_locks with respect to SSI.	Robert Haas
	Explain that querying pg_locks does not simultaneously lock both the normal lock manager and the predicate lock manager. Per discussion with Kevin Grittner.
2011-06-23	In pg_upgrade docs, clarify that link mode uses "hard" links.	Bruce Momjian
	Backpatch to 9.1 and 9.0.
2011-06-23	Add information schema views role_udt_grants, udt_privileges, user_defined_types	Peter Eisentraut

2011-06-23	Add a bit of markup	Peter Eisentraut

2011-06-21	Add smallserial pseudotype.	Robert Haas
	This is just like serial and bigserial, except it generates an int2 column rather than int4 or int8. Mike Pultz, reviewed by Brar Piening and Josh Kupershmidt
2011-06-21	Make deadlock_timeout PGC_SUSET rather than PGC_SIGHUP.	Robert Haas
	This allows deadlock_timeout to be reduced for transactions that are particularly likely to be involved in a deadlock, thus detecting it more quickly. It is also potentially useful as a poor-man's deadlock priority mechanism: a transaction with a high deadlock_timeout is less likely to be chosen as the victim than one with a low deadlock_timeout. Since that could be used to game the system, we make this PGC_SUSET rather than PGC_USERSET. At some point, it might be worth thinking about a more explicit priority mechanism, since using this is far from fool-proof. But let's see whether there's enough use case to justify the additional work before we go down that route. Noah Misch, reviewed by Shigeru Hanada
2011-06-21	Add notion of a "transform function" that can simplify function calls.	Robert Haas
	Initially, we use this only to eliminate calls to the varchar() function in cases where the length is not being reduced and, therefore, the function call is equivalent to a RelabelType operation. The most significant effect of this is that we can avoid a table rewrite when changing a varchar(X) column to a varchar(Y) column, where Y > X. Noah Misch, reviewed by me and Alexey Klyukin
2011-06-21	Performance tuning advice for SSI.	Robert Haas
	Kevin Grittner, with additional wordsmithing by me.
2011-06-20	Fix missed use of "cp -i" in an example, per Fujii Masao.	Tom Lane
	Also be more careful about markup: use & not just &.
2011-06-19	Produce HISTORY file consistently as ASCII	Peter Eisentraut
	The release notes may contain non-ASCII characters (for contributor names), which lynx converts to the encoding determined by the current locale. The get output that is deterministic and easily readable by everyone, we make lynx produce LATIN1 and then convert that to ASCII with transliteration for the non-ASCII characters.
2011-06-19	Capitalization fixes	Peter Eisentraut