aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
Commit message (Collapse)AuthorAge
* Documentation adjustments.Bruce Momjian2005-05-08
| | | | Vladimir Chukharev
* Add COPY WITH CVS HEADER to allow a heading line as the first line inBruce Momjian2005-05-07
| | | | | | COPY. Andrew Dunstan
* Remove documentation that CSV didn't handle carriage returns and lineBruce Momjian2005-05-06
| | | | feeds properly.
* Alter the signature for encoding conversion functions to declare theTom Lane2005-05-03
| | | | | | 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.
* Add some missing "See Also" entries to the domain-related SQL referenceNeil Conway2005-05-02
| | | | pages. From Robert Treat.
* Change CREATE TYPE to require datatype output and send functions to haveTom Lane2005-05-01
| | | | | | | only one argument. (Per recent discussion, the option to accept multiple arguments is pretty useless for user-defined types, and would be a likely source of security holes if it was used.) Simplify call sites of output/send functions to not bother passing more than one argument.
* Fix incorrect backslashing in regexp example, per Robert Treat.Tom Lane2005-05-01
|
* Implement sharable row-level locks, and use them for foreign key referencesTom Lane2005-04-28
| | | | | | | | | | | | | | | to eliminate unnecessary deadlocks. This commit adds SELECT ... FOR SHARE paralleling SELECT ... FOR UPDATE. The implementation uses a new SLRU data structure (managed much like pg_subtrans) to represent multiple- transaction-ID sets. When more than one transaction is holding a shared lock on a particular row, we create a MultiXactId representing that set of transactions and store its ID in the row's XMAX. This scheme allows an effectively unlimited number of row locks, just as we did before, while not costing any extra overhead except when a shared lock actually has to be shared. Still TODO: use the regular lock manager to control the grant order when multiple backends are waiting for a row lock. Alvaro Herrera and Tom Lane.
* Add psql \set ON_ERROR_ROLLBACK to allow statements in a transaction toBruce Momjian2005-04-28
| | | | | error without affecting the entire transaction. Valid values are "on|interactive|off".
* Typo fix. Alvaro.Bruce Momjian2005-04-22
|
* Remove pre-7.3 mention that FOR UPDATE can be before LIMIT.Bruce Momjian2005-04-22
| | | | | Document that FOR UPDATE and LIMIT together can return fewer rows that LIMIT specifies, and why.
* Add aggsortop column to pg_aggregate, so that MIN/MAX optimization canTom Lane2005-04-12
| | | | | | | | be supported for all datatypes. Add CREATE AGGREGATE and pg_dump support too. Add specialized min/max aggregates for bpchar, instead of depending on text's min/max, because otherwise the possible use of bpchar indexes cannot be recognized. initdb forced because of catalog changes.
* Change the default setting of "add_missing_from" to false. This has beenNeil Conway2005-04-08
| | | | | | the long-term plan for this behavior for quite some time, but it is only possible now that DELETE has a USING clause so that the user can join other tables in a DELETE statement without relying on this behavior.
* Add a "USING" clause to DELETE, which is equivalent to the FROM clauseNeil Conway2005-04-07
| | | | | | | | | | | | | | | in UPDATE. We also now issue a NOTICE if a query has _any_ implicit range table entries -- in the past, we would only warn about implicit RTEs in SELECTs with at least one explicit RTE. As a result of the warning change, 25 of the regression tests had to be updated. I also took the opportunity to remove some bogus whitespace differences between some of the float4 and float8 variants. I believe I have correctly updated all the platform-specific variants, but let me know if that's not the case. Original patch for DELETE ... USING from Euler Taveira de Oliveira, reworked by Neil Conway.
* First phase of OUT-parameters project. We can now define and use SQLTom Lane2005-03-31
| | | | | functions with OUT parameters. The various PLs still need work, as does pg_dump. Rudimentary docs and regression tests included.
* Note that the -F and -R command line options only affect unalignedTom Lane2005-03-14
| | | | | output mode. This was already stated in other places in the psql reference page, but not here.
* Allow ALTER FUNCTION to change a function's strictness, volatility, andNeil Conway2005-03-14
| | | | | | | | | whether or not it is a security definer. Changing a function's strictness is required by SQL2003, and the other capabilities make sense. Also, allow an optional RESTRICT noise word to be specified, for SQL conformance. Some trivial regression tests added and the documentation has been updated.
* Make default_with_oids default to false -- user-created tables will nowNeil Conway2005-03-13
| | | | | | no longer include OIDs, unless WITH OIDS is specified or the default_with_oids configuration parameter is enabled. Update the docs accordingly.
* Make the behavior of HAVING without GROUP BY conform to the SQL spec.Tom Lane2005-03-10
| | | | | | | | | Formerly, if such a clause contained no aggregate functions we mistakenly treated it as equivalent to WHERE. Per spec it must cause the query to be treated as a grouped query of a single group, the same as appearance of aggregate functions would do. Also, the HAVING filter must execute after aggregate function computation even if it itself contains no aggregate functions.
* Rename canonical encodings, per Peter:Bruce Momjian2005-03-07
| | | | | | | | | UNICODE => UTF8 ALT => WIN866 WIN => WIN1251 TCVN => WIN1258 The old codes continue to work.
* Document that only a table's owner may TRUNCATE it. Per Keith Worthington.Tom Lane2005-02-22
|
* Update initdb locale/encoding documentation description. Backpatch toBruce Momjian2005-02-22
| | | | 8.0.X.
* Document the "register" and "unregister" pg_ctl subcommands, for use onNeil Conway2005-02-21
| | | | Windows. Patch from Magnus Hagander.
* Mention that some psql environment variables come from libpq and noteBruce Momjian2005-02-11
| | | | | | | | | 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.
* Add support for temporary views, including documentation and regressionNeil Conway2005-02-02
| | | | | | | | tests. Contributed by Koju Iijima, review from Neil Conway, Gavin Sherry and Tom Lane. Also, fix error in description of WITH CHECK OPTION clause in the CREATE VIEW reference page: it should be "CASCADED", not "CASCADE".
* Generalize TRUNCATE to support truncating multiple tables in oneTom Lane2005-01-27
| | | | | | | | command. This is useful because we can allow truncation of tables referenced by foreign keys, so long as the referencing table is truncated in the same command. Alvaro Herrera
* Close all cursors created during a failed subtransaction. This is neededTom Lane2005-01-26
| | | | | | 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.
* Add tools/find_gt_lt to find < and > in SGML source.Bruce Momjian2005-01-23
| | | | | Lowercase some uppercase tags so tools is more reliable at finding problems.
* More < and > changes to ampersands.Bruce Momjian2005-01-22
| | | | 8.0.X and HEAD.
* More fixes for => and ->, use proper ampersand markups.Bruce Momjian2005-01-22
|
* Fix minor thinko in pg_dump documentation of "-n" option.Neil Conway2005-01-17
|
* Incorporate examples and doc patches from Mark Kirkwood and David Fetter.Tom Lane2005-01-14
|
* Change Win32 client configuration files from *.txt to *.conf.Bruce Momjian2005-01-14
|
* Add some real documentation about TOAST (finally). Combine this withTom Lane2005-01-10
| | | | | the old 'page' chapter and the recently added 'filelayout' chapter to make a coherent chapter about PostgreSQL's physical storage layout.
* Some more small improvements in response to 7.4 interactive docs comments.Tom Lane2005-01-09
|
* Spell APPDATA as %APPDATA%, per recommendation from Magnus.Tom Lane2005-01-06
|
* Adjust examples to avoid using keywords as identifiers, per Honda Shigehiro.Tom Lane2005-01-06
|
* Adjust lookup of client-side profile files (.pgpass and so on) as perTom Lane2005-01-06
| | | | | | 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.
* Re-readjust synopses for CREATE/ALTER USER.Tom Lane2005-01-06
|
* Fix example, change table name from 'array' to 'array_int'.Bruce Momjian2005-01-05
|
* Revert cosmetic synopsis changes that break psql translations.Peter Eisentraut2005-01-05
|
* Fix subsection ordering (DISTINCT should be described before LIMIT).Tom Lane2005-01-04
|
* More minor updates and copy-editing.Tom Lane2005-01-04
|
* More minor updates and copy-editing.Tom Lane2005-01-04
|
* Add mention of performance impact on LIKE of non-C locales.Bruce Momjian2005-01-04
|
* Make libpq default to localhost connections on machines without Unix-domainTom Lane2004-12-28
| | | | | sockets, rather than failing as it formerly did. Revert the thereby-obsoleted patch to make psql supply the localhost default.
* Move info about psql console code page issues out of install-win32.sgml,Tom Lane2004-12-27
| | | | where it doesn't belong, and put it in the psql reference page.
* Add mention that pg_ctl will return an accurate exit code when waitingBruce Momjian2004-12-22
| | | | for startup or shutdown. We have always done this but it wasn't documented.
* Adjust pg_resetxlog to handle 8.0 WAL file names properly.Tom Lane2004-12-20
|
* Spell checker runPeter Eisentraut2004-12-13
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-31 02:59:24 +0000