aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
Commit message (Collapse)AuthorAge
* Fix broken markup.Tom Lane2006-02-12
|
* > Actually, if you submit a patch that says either "SCROLL is theBruce Momjian2006-02-12
| | | | | | | | | | | | | | | | default" > or "NO SCROLL is the default", it will be rejected as incorrect. The > reason is that the default behavior is different from either of these, > as is explained in the NOTES section. Ok, so *that's* where the bit about the query plan being simple enough. Based on that, ISTM that it should be premissable for us to decide that a cursor requiring a sort isn't "simple enough" to support SCROLL. In any case, here's a patch that makes the non-standard behavior easier for people to find. Jim C. Nasby
* Update EXPLAIN wording for GEQO usage.Bruce Momjian2006-01-20
|
* Doc patch that adds an example of a correllated UPDATE.Bruce Momjian2006-01-19
| | | | David Fetter
* Update COPY CSV \. wording for externally created files.Bruce Momjian2005-12-28
|
* Add regression tests for CSV and \., and add automatic quoting of aBruce Momjian2005-12-28
| | | | | | | single column dump that has a \. value, so the load works properly. I also added documentation describing this issue. Backpatch to 8.1.X.
* Add documentation about the behavior of BEFORE triggers and referentialBruce Momjian2005-12-09
| | | | | | integrity actions. Stephan Szabo
* Remove mention that history is _now_ automatically saved on exit. ItBruce Momjian2005-12-09
| | | | has been that way for a long time.
* there's a paragraph in the ALTER TABLE reference page that reads:Bruce Momjian2005-12-08
| | | | | | | | | | | | | | | | | | | | | DROP CONSTRAINT This form drops constraints on a table. Currently, constraints on tables are not required to have unique names, so there may be more than one constraint matching the specified name. All matching constraints will be dropped. To my knowledge, it is no longer possible to create constraints with the same name for the same relation. When you create a constraint and specify the same name explictly, an error is raised. Implicit constraint creation won't choose an existing name either and up to now you could not rename a constraint. Renaming works with the patch I sent in a few hours ago but this patch as well won't allow constraints with identical names on the same relation. The attached patch thus removes the note in the docs. Joachim Wieland
* Fix obsolete description of -h option, per Andreas Schmidt.Tom Lane2005-12-02
|
* Spellchecking run, final cleanupsPeter Eisentraut2005-11-04
|
* Some minor improvements to the CE docs. Also fix a bit of SGML markupNeil Conway2005-11-03
| | | | elsewhere.
* Make an editorial pass over the reference pages.Tom Lane2005-11-01
|
* Mention in the docs that temporary/non-temp tables can not shareBruce Momjian2005-10-31
| | | | referential integrity relationships.
* Fix psql ref typo.Bruce Momjian2005-10-30
| | | | Andreas Seltenreich
* Remove mention that \x doesn't affect backslash commands.Bruce Momjian2005-10-28
|
* Document the behavior of GRANT/REVOKE in cases where the privilege isTom Lane2005-10-20
| | | | | held by means of role membership, rather than directly. Per discussion and bug fix of a couple weeks ago.
* Fix assorted typos in the documentation, and use American spellingNeil Conway2005-10-15
| | | | rather than British. Patch from Michael Fuhr.
* Merge some user-submitted suggestions for improvement into theNeil Conway2005-10-15
| | | | | documentation. Mostly add some <xref>s, fix a few typos, and document that zlib is required in the installation docs.
* Improve documentation about CREATEROLE privilege.Tom Lane2005-10-13
|
* Update documentation to reflect the new ALTER OWNER rules for allTom Lane2005-10-13
| | | | affected types of objects.
* Fix capitalization of example.Bruce Momjian2005-10-13
|
* Remove extra <para>Bruce Momjian2005-10-13
|
* Fix spelling error, per Michael Fuhr.Tom Lane2005-10-12
|
* Remove the DELETEs from pg_shadow and pg_group that pg_dumpall used toTom Lane2005-10-10
| | | | | | | | emit when given the --clean option, in favor of individual DROP ROLE commands. The old technique could not possibly work in 8.1, and was never a very good idea anyway IMHO. The DROP ROLE approach has the defect that the DROPs will fail for roles that own objects or have privileges, but perhaps we can improve that later.
* Clean up some messages and fix missing translation support. Option --logPeter Eisentraut2005-10-04
| | | | renamed to --log-file for clarity.
* Change the option spelling to --connection-limit to be consistent with thePeter Eisentraut2005-09-30
| | | | SQL option spelling.
* Fix problems with PGXS builds against an installation tree that wasTom Lane2005-09-27
| | | | | | | relocated after installation. We can't trust the installation paths inserted into Makefile.global by configure, so instead we must get the paths from pg_config. This requires extending pg_config to support all the separately-configurable path names, but that was on TODO anyway.
* Attached patch takes a swing at improving the autovacuum wording inBruce Momjian2005-09-23
| | | | | | | | maintenance.sgml. Robert Treat [ Also fix create domain markup.]
* Add warning about DOMAINs.Bruce Momjian2005-09-22
| | | | David Fetter
* Minor SGML markup fixes.Neil Conway2005-09-13
|
* Forgot to add pg_pltemplate to the list of shared system catalogs thatTom Lane2005-09-12
| | | | appears in the REINDEX ref page.
* Create the pg_pltemplate system catalog to hold template informationTom Lane2005-09-08
| | | | | | for procedural languages. This replaces the hard-wired table I had originally proposed as a stopgap solution. For the moment, the initial contents only include languages shipped with the core distribution.
* Implement a preliminary 'template' facility for procedural languages,Tom Lane2005-09-05
| | | | | | | | | | | | | | as per my recent proposal. For now the template data is hard-wired in proclang.c --- this should be replaced later by a new shared system catalog, but we don't want to force initdb during 8.1 beta. This change lets us cleanly load existing dump files even if they contain outright wrong information about a PL's support functions, such as a wrong path to the shared library or a missing validator function. Also, we can revert the recent kluges to make pg_dump dump PL support functions that are stored in pg_catalog. While at it, I removed the code in pg_regress that replaced $libdir with a hardcoded path for temporary installations. This is no longer needed given our support for relocatable installations.
* Add a note about CSV lines with trailing spaces.Andrew Dunstan2005-09-05
| | | | Suggestion by Darcy Buskermolen, reworded by me.
* Mention max_prepared_transactions in PREPARE TRANSACTION reference page,Tom Lane2005-08-30
| | | | per Bruce's suggestion.
* Add documentation for ALTER TABLE ENABLE/DISABLE TRIGGER.Tom Lane2005-08-24
|
* Update documentation that non-super users can now do ALTER OWNER.Bruce Momjian2005-08-22
|
* Cause ALTER INDEX OWNER to generate a warning and do nothing, rather thanTom Lane2005-08-22
| | | | | | | erroring out as it has done for the last couple weeks. Document that this form is now ignored because indexes can't usefully have different owners from their parent tables. Fix pg_dump to not generate ALTER OWNER commands for indexes.
* Clean up some stray remaining references to pg_shadow, pg_user, pg_group.Tom Lane2005-08-15
|
* Update administrator's guide chapters for ROLEs patch.Tom Lane2005-08-14
|
* Update the createuser utility for the ROLEs world. Alvaro HerreraTom Lane2005-08-14
|
* Fix up tab completion for ROLEs and add some more completion logic forTom Lane2005-08-14
| | | | | | other stuff; change \du and \dg to be role-aware (Stefan Kaltenbrunner). Also make tab completion fetch the list of GUC variables from pg_settings instead of having a hard-wired copy of the list (Tom Lane).
* CREATE TABLE has optional column names, so change {} to [].Bruce Momjian2005-08-13
| | | | Alvaro.
* Pass the type OID as the typioparam for all non-array types, rather thanTom Lane2005-08-12
| | | | | only composite types as we did in 8.0. Per discussion with 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.
* 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.
* 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.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-02 20:39:32 +0000