aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
* Another example-to-documentation difference. Maybe we can find aTom Lane2003-10-22
| | | | better way to keep these in sync...
* Ooops, missed updating this part of the complex-datatype example.Tom Lane2003-10-21
|
* Update the complex-datatype example to V1 function calling conventions,Tom Lane2003-10-21
| | | | | and add binary send/receive functions. Fix some other grottiness such as failure to mark the C functions STRICT.
* For some reason, the preface mentions just six of the seven major partsTom Lane2003-10-21
| | | | of the book. Fix it.
* Add release info about dollar signs to migration section:Bruce Momjian2003-10-21
| | | | | | | <listitem><para> Dollar sign (<literal>$</>) is no longer allowed in operator names</para></listitem> <listitem><para> Dollar sign (<literal>$</>) can be a non-first character in identifiers</para></listitem>
* Document all the system views created by initdb (several of these wereTom Lane2003-10-17
| | | | | never documented anywhere, sigh). Centralize the detailed documentation of system views into catalogs.sgml, and provide cross-references.
* Add a listing of our SQLSTATE error codes to the documentation.Tom Lane2003-10-17
| | | | Link to it from some appropriate places.
* Fix busted markup.Tom Lane2003-10-17
|
* Adjust display of actual runtimes in EXPLAIN output to use three fractionalTom Lane2003-10-17
| | | | | digits, and label it 'ms' not 'msec', for consistency with psql's \timing display. Per recent discussions.
* Add note deprecating use of consrc.Tom Lane2003-10-17
|
* Fix bugs in referential_constraints view.Peter Eisentraut2003-10-16
|
* Add mention of SIGHUP on the postmaster manual page.Bruce Momjian2003-10-16
|
* Minor copy-editing.Tom Lane2003-10-16
|
* Fix SGML markup.Bruce Momjian2003-10-16
| | | | Update HISTORY file.
* This patch adds another item to the "migration to 7.4" list in theBruce Momjian2003-10-16
| | | | | | | HISTORY file, and attributes the shared-buffer-alignment change to Manfred Spraul. Neil Conway
* I have run pg_autovacuum on AIX, so that can, at least loosely, beBruce Momjian2003-10-16
| | | | | | | | | considered "tested." And I have turned all of the 7.4 HISTORY material into DocBook for release.sgml Christopher Browne
* Update max existing db size to 32tb.Bruce Momjian2003-10-10
|
* Update Russian FAQ.Bruce Momjian2003-10-10
| | | | Viktor Vislobokov
* > That's a fairly useless place to put it, though, since someone wouldBruce Momjian2003-10-10
| | | | | | | | | | > only think to look at sort_mem if they already had a clue. It should > be mentioned under bulk data load (in performance tips chapter) Attached is a doc patch that does this. The way I've worded it may not be the best, though. Neil Conway
* About section 8.5.1.5. ("Special Values"):Bruce Momjian2003-10-09
| | | | | | | | | | | | I suggest adding LOCALTIMESTAMP and LOCALTIME to the first paragraph. Maybe it should be phrased as: The following SQL-compatible functions can be used to obtain current datetime-related values: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME and LOCALTIMESTAMP. (See Section 9.8.4.) Troels Arvin
* Add mention of logrotate for syslog, from Robert TreatBruce Momjian2003-10-09
|
* Have log_min_duration_statement = 0 always print duration/statement.Bruce Momjian2003-10-08
| | | | | | Change log line to be "duration: ms query:" Indent multi-line queries with a tab in the server logs.
* Modify COPY FROM to match the null-value string against the column valueTom Lane2003-10-06
| | | | | | | | | | | before it is de-backslashed, not after. This allows the null string \N to be reliably distinguished from the data value \N (which must be represented as \\N). Per bug report from Manfred Koizar ... but it's amazing this hasn't been reported before ... Also, be consistent about encoding conversion for null string: the form specified in the command is in the server encoding, but what is sent to/from client must be in client encoding. This never worked quite right before either.
* Update MySQL mention.Bruce Momjian2003-10-05
|
* Update MySQL mention.Bruce Momjian2003-10-05
|
* Document the always-true-but-previously-undocumented fact that PQfnumber()Tom Lane2003-10-04
| | | | | | | will downcase the supplied field name unless it is double-quoted. Also, upgrade the routine's handling of double quotes to match the backend, in particular support doubled double quotes within quoted identifiers. Per pgsql-interfaces discussion a couple weeks ago.
* Update INSTALL file for 7.4.Bruce Momjian2003-10-04
|
* Update MySQL mention.Bruce Momjian2003-10-04
|
* Update MySQL mention.Bruce Momjian2003-10-04
|
* Change transaction status indicator in prompt from %T to %x.Peter Eisentraut2003-10-04
|
* Add GUC parameter check_function_bodies to control whether validationTom Lane2003-10-03
| | | | | | | of function bodies is done at CREATE FUNCTION time. This is normally true but can be set false to avoid problems with forward references, wrong schema search path, etc. This is just the backend patch, still need to adjust pg_dump to make use of it.
* Cause PQescapeString to stop processing at a null character, ratherTom Lane2003-10-03
| | | | | | than generating an invalid output string. Per observation and patch from Igor Shevchenko. Further code cleanup and documentation by Tom Lane.
* Adjust documentation examples to match recent error message rewordings.Tom Lane2003-09-30
| | | | A couple other minor fixes.
* Minor copy-editing.Tom Lane2003-09-30
|
* Use slightly less broken markup.Tom Lane2003-09-30
|
* Adjust btree index build procedure so that the btree metapage looksTom Lane2003-09-29
| | | | | | | | | | invalid (has the wrong magic number) until the build is entirely complete. This turns out to cost no additional writes in the normal case, since we were rewriting the metapage at the end of the process anyway. In normal scenarios there's no real gain in security, because a failed index build would roll back the transaction leaving an unused index file, but for rebuilding shared system indexes this seems to add some useful protection.
* > >Bruce Momjian2003-09-29
| | | | | | | | | | | | | | | | | | | | | | | | | | > > a) Write documentation how the win32 console needs to be set up so that > > psql can handle 8-bit characters. > > Where should it be added? The Section "Installation on Windows" in the > > Administrator's Guide seems natural to me. > > > > b) Add code to psql that prints a warning on startup of psql when the > > console codepage differs from the windows codepage, something like > > > > Warning: Console codepage (850) differs from windows codepage (1252) > > 8-bit characters will not work correctly. See PostgreSQL > > documentation "Installation on Windows" for details. > Attached are two patches: - installdoc.patch contains an additional paragraph on the win32 console codepage for the chapter "Installation on Windows" Due to a lack of SGML-tools, I have only edited the text and not tested the SGML code - please check it before merging into the CVS branch. - psqlcodepage.patch adds the warning about a problematic codepage to psql. Christoph Dalitz
* This patch makes a few incremental improvements to geqo.sgml andBruce Momjian2003-09-29
| | | | | | arch-dev.sgml Neil Conway
* Change 7.3.4 release note format to match the rest of the 7.3.xBruce Momjian2003-09-29
| | | | | | releases. Rod Taylor
* Update docs on function call permissions in view, from Tom.Bruce Momjian2003-09-28
|
* Small SGML cleanup from Jeroen Ruigrok/asmodaiBruce Momjian2003-09-27
|
* Document that functions are checked independently of the viewBruce Momjian2003-09-27
| | | | permissions.
* Add "tuning" section to install instructions.Bruce Momjian2003-09-26
|
* Update Japanese FAQ, from Jun KuwamuraBruce Momjian2003-09-25
|
* Repair some REINDEX problems per recent discussions. The relcache isTom Lane2003-09-24
| | | | | | | | | | | | | now able to cope with assigning new relfilenode values to nailed-in-cache indexes, so they can be reindexed using the fully crash-safe method. This leaves only shared system indexes as special cases. Remove the 'index deactivation' code, since it provides no useful protection in the shared- index case. Require reindexing of shared indexes to be done in standalone mode, but remove other restrictions on REINDEX. -P (IgnoreSystemIndexes) now prevents using indexes for lookups, but does not disable index updates. It is therefore safe to allow from PGOPTIONS. Upshot: reindexing system catalogs can be done without a standalone backend for all cases except shared catalogs.
* pg_dump/pg_restore now always use SET SESSION AUTHORIZATION, not \connect,Tom Lane2003-09-23
| | | | | | | to control object ownership. The use-set-session-authorization and no-reconnect switches are obsolete (still accepted on the command line, but they don't do anything). This is a precursor to fixing handling of CREATE SCHEMA, which will be a separate commit.
* Minor copy-editing for plpgsql chapter.Tom Lane2003-09-23
|
* Make the SQL command synopses appear less random.Peter Eisentraut2003-09-22
|
* Fix a batch of speling misteaks identified by Peter's spell-checker tool.Tom Lane2003-09-20
|
* Document that TRUNCATE ignores user-defined ON DELETE triggers.Tom Lane2003-09-19
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 04:44:09 +0000