summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2003-10-21For some reason, the preface mentions just six of the seven major partsTom Lane
of the book. Fix it.
2003-10-21Add release info about dollar signs to migration section:Bruce Momjian
<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>
2003-10-17Document all the system views created by initdb (several of these wereTom Lane
never documented anywhere, sigh). Centralize the detailed documentation of system views into catalogs.sgml, and provide cross-references.
2003-10-17Add a listing of our SQLSTATE error codes to the documentation.Tom Lane
Link to it from some appropriate places.
2003-10-17Fix busted markup.Tom Lane
2003-10-17Adjust display of actual runtimes in EXPLAIN output to use three fractionalTom Lane
digits, and label it 'ms' not 'msec', for consistency with psql's \timing display. Per recent discussions.
2003-10-17Add note deprecating use of consrc.Tom Lane
2003-10-16Fix bugs in referential_constraints view.Peter Eisentraut
2003-10-16Add mention of SIGHUP on the postmaster manual page.Bruce Momjian
2003-10-16Minor copy-editing.Tom Lane
2003-10-16Fix SGML markup.Bruce Momjian
Update HISTORY file.
2003-10-16This patch adds another item to the "migration to 7.4" list in theBruce Momjian
HISTORY file, and attributes the shared-buffer-alignment change to Manfred Spraul. Neil Conway
2003-10-16I have run pg_autovacuum on AIX, so that can, at least loosely, beBruce Momjian
considered "tested." And I have turned all of the 7.4 HISTORY material into DocBook for release.sgml Christopher Browne
2003-10-10Update max existing db size to 32tb.Bruce Momjian
2003-10-10Update Russian FAQ.Bruce Momjian
Viktor Vislobokov
2003-10-10> That's a fairly useless place to put it, though, since someone wouldBruce Momjian
> 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
2003-10-09About section 8.5.1.5. ("Special Values"):Bruce Momjian
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
2003-10-09Add mention of logrotate for syslog, from Robert TreatBruce Momjian
2003-10-08Have log_min_duration_statement = 0 always print duration/statement.Bruce Momjian
Change log line to be "duration: ms query:" Indent multi-line queries with a tab in the server logs.
2003-10-06Modify COPY FROM to match the null-value string against the column valueTom Lane
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.
2003-10-05Update MySQL mention.Bruce Momjian
2003-10-05Update MySQL mention.Bruce Momjian
2003-10-04Document the always-true-but-previously-undocumented fact that PQfnumber()Tom Lane
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.
2003-10-04Update INSTALL file for 7.4.Bruce Momjian
2003-10-04Update MySQL mention.Bruce Momjian
2003-10-04Update MySQL mention.Bruce Momjian
2003-10-04Change transaction status indicator in prompt from %T to %x.Peter Eisentraut
2003-10-03Add GUC parameter check_function_bodies to control whether validationTom Lane
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.
2003-10-03Cause PQescapeString to stop processing at a null character, ratherTom Lane
than generating an invalid output string. Per observation and patch from Igor Shevchenko. Further code cleanup and documentation by Tom Lane.
2003-09-30Adjust documentation examples to match recent error message rewordings.Tom Lane
A couple other minor fixes.
2003-09-30Minor copy-editing.Tom Lane
2003-09-30Use slightly less broken markup.Tom Lane
2003-09-29Adjust btree index build procedure so that the btree metapage looksTom Lane
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.
2003-09-29> >Bruce Momjian
> > 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
2003-09-29This patch makes a few incremental improvements to geqo.sgml andBruce Momjian
arch-dev.sgml Neil Conway
2003-09-29Change 7.3.4 release note format to match the rest of the 7.3.xBruce Momjian
releases. Rod Taylor
2003-09-28Update docs on function call permissions in view, from Tom.Bruce Momjian
2003-09-27Small SGML cleanup from Jeroen Ruigrok/asmodaiBruce Momjian
2003-09-27Document that functions are checked independently of the viewBruce Momjian
permissions.
2003-09-26Add "tuning" section to install instructions.Bruce Momjian
2003-09-25Update Japanese FAQ, from Jun KuwamuraBruce Momjian
2003-09-24Repair some REINDEX problems per recent discussions. The relcache isTom Lane
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.
2003-09-23pg_dump/pg_restore now always use SET SESSION AUTHORIZATION, not \connect,Tom Lane
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.
2003-09-23Minor copy-editing for plpgsql chapter.Tom Lane
2003-09-22Make the SQL command synopses appear less random.Peter Eisentraut
2003-09-20Fix a batch of speling misteaks identified by Peter's spell-checker tool.Tom Lane
2003-09-19Document that TRUNCATE ignores user-defined ON DELETE triggers.Tom Lane
2003-09-19Disallow foreign-key references from temp tables to permanent tables.Tom Lane
Per recent discussion, this does not work because other backends can't reliably see tuples in a temp table and so cannot run the RI checks correctly. Seems better to disallow this case than go back to accessing temp tables through shared buffers. Also, disallow FK references to ON COMMIT DELETE ROWS tables. We already caught this problem for normal TRUNCATE, but the path used by ON COMMIT didn't check.
2003-09-18Put a tad more detail in the discussion of postmaster and postgresTom Lane
signal handling.
2003-09-15Okay, who left off the id= here?Tom Lane
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-16 03:29:30 +0000