summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
AgeCommit message (Collapse)Author
2006-12-01Document the recently-understood hazard that a rollback can release row-levelTom Lane
locks that logically should not be released, because when a subtransaction overwrites XMAX all knowledge of the previous lock state is lost. It seems unlikely that we will be able to fix this before 8.3...
2006-07-31Fix confusion between COPY FROM and COPY TO, per Gavin Sharry and Arul Shaji.Alvaro Herrera
2005-12-02Fix obsolete description of -h option, per Andreas Schmidt.Tom Lane
2005-05-13Update createuser examples to match the current program behavior,Tom Lane
and add an example showing assignment of a password. Per suggestion from Jari Aalto (via Martin Pitt).
2005-05-03Alter the signature for encoding conversion functions to declare theTom Lane
output area as INTERNAL not CSTRING. This is to prevent people from calling the functions by hand. This is a permanent solution for the back branches but I hope it is just a stopgap for HEAD.
2005-05-02Backport fix for correct quoting in CREATE DOMAIN example. Per RobertNeil Conway
Treat.
2005-04-22Backpatch of LIMIT / FOR UPDATE behavior, but keep pre-7.3 mention in 8.0.X.Bruce Momjian
2005-02-22Document that only a table's owner may TRUNCATE it. Per Keith Worthington.Tom Lane
2005-02-22Update initdb locale/encoding documentation description. Backpatch toBruce Momjian
8.0.X.
2005-02-21Document the "register" and "unregister" pg_ctl subcommands, for use onNeil Conway
Windows. Patch from Magnus Hagander.
2005-02-11Mention that some psql environment variables come from libpq and noteBruce Momjian
more variables can be found in the libpq manual section. Mention .pgpass in the psql manual page section dealing with connection parameters and point to the libpq section for more details. Backpatch to 8.0.X.
2005-01-26Close all cursors created during a failed subtransaction. This is neededTom Lane
to avoid problems when a cursor depends on objects created or changed in the same subtransaction. We'd like to do better someday, but this seems the only workable answer for 8.0.1.
2005-01-23Add tools/find_gt_lt to find < and > in SGML source.Bruce Momjian
Lowercase some uppercase tags so tools is more reliable at finding problems.
2005-01-22More < and > changes to ampersands.Bruce Momjian
8.0.X and HEAD.
2005-01-22More < and > cleanups converted to ampersands.Bruce Momjian
2005-01-17Fix minor thinko in pg_dump documentation of "-n" option.Neil Conway
2005-01-14Incorporate examples and doc patches from Mark Kirkwood and David Fetter.Tom Lane
2005-01-14Change Win32 client configuration files from *.txt to *.conf.Bruce Momjian
2005-01-10Add some real documentation about TOAST (finally). Combine this withTom Lane
the old 'page' chapter and the recently added 'filelayout' chapter to make a coherent chapter about PostgreSQL's physical storage layout.
2005-01-09Some more small improvements in response to 7.4 interactive docs comments.Tom Lane
2005-01-06Spell APPDATA as %APPDATA%, per recommendation from Magnus.Tom Lane
2005-01-06Adjust examples to avoid using keywords as identifiers, per Honda Shigehiro.Tom Lane
2005-01-06Adjust lookup of client-side profile files (.pgpass and so on) as perTom Lane
discussion on pgsql-hackers-win32 list. Documentation still needs to be tweaked --- I'm not sure how to refer to the APPDATA folder in user documentation.
2005-01-06Re-readjust synopses for CREATE/ALTER USER.Tom Lane
2005-01-05Fix example, change table name from 'array' to 'array_int'.Bruce Momjian
2005-01-05Revert cosmetic synopsis changes that break psql translations.Peter Eisentraut
2005-01-04Fix subsection ordering (DISTINCT should be described before LIMIT).Tom Lane
2005-01-04More minor updates and copy-editing.Tom Lane
2005-01-04More minor updates and copy-editing.Tom Lane
2005-01-04Add mention of performance impact on LIKE of non-C locales.Bruce Momjian
2004-12-28Make libpq default to localhost connections on machines without Unix-domainTom Lane
sockets, rather than failing as it formerly did. Revert the thereby-obsoleted patch to make psql supply the localhost default.
2004-12-27Move info about psql console code page issues out of install-win32.sgml,Tom Lane
where it doesn't belong, and put it in the psql reference page.
2004-12-22Add mention that pg_ctl will return an accurate exit code when waitingBruce Momjian
for startup or shutdown. We have always done this but it wasn't documented.
2004-12-20Adjust pg_resetxlog to handle 8.0 WAL file names properly.Tom Lane
2004-12-13Spell checker runPeter Eisentraut
2004-12-02Disallow the combination VACUUM FULL FREEZE for safety's sake, for theTom Lane
reasons I outlined in pghackers a few days ago. Also, undo someone's overly optimistic decision to reduce tuple state checks from if (...) elog() to Asserts. If I trusted this code more, I might think it was a good idea to disable these checks in production installations. But I don't.
2004-12-02Rework libpq threaded SIGPIPE handling to avoid interference withBruce Momjian
calling applications. This is done by blocking sigpipe in the libpq thread and using sigpending/sigwait to possibily discard any sigpipe we generated.
2004-11-27Correctly name the Windows operating systemsPeter Eisentraut
2004-11-27Update of conformance information to SQL:2003Peter Eisentraut
by Troels Arvin, Simon Riggs, Elein Mustain Make spelling of SQL standard names uniform.
2004-11-17Document a limitation of COPY's new CSV mode. Doc patch from AndrewNeil Conway
Dunstan, editorializing by Neil Conway.
2004-11-15Replace "--" and "---" with "&mdash;" as appropriate, for better-lookingNeil Conway
output.
2004-11-05Create 'default_tablespace' GUC variable that supplies a TABLESPACETom Lane
clause implicitly whenever one is not given explicitly. Remove concept of a schema having an associated tablespace, and simplify the rules for selecting a default tablespace for a table or index. It's now just (a) explicit TABLESPACE clause; (b) default_tablespace if that's not an empty string; (c) database's default. This will allow pg_dump to use SET commands instead of tablespace clauses to determine object locations (but I didn't actually make it do so). All per recent discussions.
2004-11-04Minor documentation updates from Simon Riggs.Tom Lane
2004-10-29Fix broken example for PREPARE.Tom Lane
2004-10-29Improvements to the CREATE DATABASE reference page's description of theNeil Conway
TABLESPACE clause.
2004-10-24Update for 8.0: pg_tablespace is now also a shared catalog.Tom Lane
2004-10-22In ALTER COLUMN TYPE, strip any implicit coercion operations appearingTom Lane
at the top level of the column's old default expression before adding an implicit coercion to the new column type. This seems to satisfy the principle of least surprise, as per discussion of bug #1290.
2004-10-22Fix documentation typo.Neil Conway
2004-10-21Update obsolete comments about COPY vs INSERT options, per Uwe Schroeder.Tom Lane
2004-10-21Disallow referential integrity actions from being deferred; only theTom Lane
NO ACTION check is deferrable. This seems to be a closer approximation to what the SQL spec says than what we were doing before, and it prevents some anomalous behaviors that are possible now that triggers can fire during the execution of PL functions. Stephan Szabo.