summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2002-09-02Here is a documentation patch for the pg_settings virtual table. IfBruce Momjian
there are no objections, please apply. Joe Conway
2002-09-02Add GUC variable to print original query to the server logs when thereBruce Momjian
is an error, warning, etc. Gavin Sherry
2002-09-02Code review for HeapTupleHeader changes. Add version number to page headersTom Lane
(overlaying low byte of page size) and add HEAP_HASOID bit to t_infomask, per earlier discussion. Simplify scheme for overlaying fields in tuple header (no need for cmax to live in more than one place). Don't try to clear infomask status bits in tqual.c --- not safe to do it there. Don't try to force output table of a SELECT INTO to have OIDs, either. Get rid of unnecessarily complex three-state scheme for TupleDesc.tdhasoids, which has already caused one recent failure. Improve documentation.
2002-09-01Add log_duration to GUC/postgresql.conf.Bruce Momjian
Rename debug_print_query to log_statement and rename show_query_stats to show_statement_stats.
2002-09-01plpgsql functions can return RECORD, per Neil Conway.Tom Lane
2002-09-01Minor copy-editing.Tom Lane
2002-09-01Remove mention of wal_files in a SHOW example.Bruce Momjian
2002-08-31Code review for pg_locks feature. Make shmemoffset of PROCLOCK structsTom Lane
available (else there's no way to interpret the list links). Change pg_locks view to show transaction ID locks separately from ordinary relation locks. Avoid showing N duplicate rows when the same lock is held multiple times (seems unlikely that users care about exact hold count). Improve documentation.
2002-08-30Updates to reflect availability of autocommit option.Tom Lane
2002-08-30AUTOCOMMIT mode is now an available backend GUC variable; setting itTom Lane
to false provides more SQL-spec-compliant behavior than we had before. I am not sure that setting it false is actually a good idea yet; there is a lot of client-side code that will probably be broken by turning autocommit off. But it's a start. Loosely based on a patch by David Van Wie.
2002-08-30Add attisinherited column to pg_attribute; use it to guard againstTom Lane
column additions, deletions, and renames that would let a child table get out of sync with its parent. Patch by Alvaro Herrera, with some kibitzing by Tom Lane.
2002-08-30Update documentation for --with-perl.Bruce Momjian
2002-08-30Improve wording after wal_files removal.Bruce Momjian
2002-08-30Complete TODO item:Bruce Momjian
* Remove wal_files postgresql.conf option because WAL files are now recycled
2002-08-30Back out password packet length check.Bruce Momjian
Improve wording of pre-7.3 syntax mention.
2002-08-30Add comment on old sytax for SELECT FOR UPDATE/LIMIT and COPY.Bruce Momjian
2002-08-30PL/pgSQL functions can return sets. Neil Conway's patch, modified soTom Lane
that the functionality is available to anyone via ReturnSetInfo, rather than hard-wiring it to PL/pgSQL.
2002-08-29Make pg_resetxlog options parsing more standard and prepare messages forPeter Eisentraut
translation.
2002-08-29The unit for statement_timeout is s/1000, not s/1000000Bruce Momjian
Manfred Koizar
2002-08-29Adjust nodeFunctionscan.c to reset transient memory context between callsTom Lane
to the table function, thus preventing memory leakage accumulation across calls. This means that SRFs need to be careful to distinguish permanent and local storage; adjust code and documentation accordingly. Patch by Joe Conway, very minor tweaks by Tom Lane.
2002-08-29A few more fixes for the <replaceable>able> fiasco.Tom Lane
2002-08-29FOUND patch was a bit over-enthusiastic: SQL commands that are notTom Lane
INSERT, UPDATE, or DELETE shouldn't change FOUND. IMHO anyway. Also, try to make documentation a little clearer.
2002-08-29Remove support for version-0 FE/BE protocol, per pghackers discussion.Tom Lane
This breaks support for 6.2 or older client libraries.
2002-08-29Code review for standalone composite types, query-specified compositeTom Lane
types, SRFs. Not happy with memory management yet, but I'll commit these other changes.
2002-08-28Add mention of foreign key dependency and SERIAL in 7.2 data restores.Bruce Momjian
Note can probably be removed after a couple of releases. Rod Taylor
2002-08-28Update info about relkind and pg_type entries for composite-types patch.Tom Lane
2002-08-28Allow FOR UPDATE to appear after LIMIT/OFFSET to match MySQL syntax and asBruce Momjian
a more logical ordering.
2002-08-27Enable locale, so case conversion (identifier processing) and numberPeter Eisentraut
formatting (\timing) works correctly. Change "Total time" to "Time" since there is nothing that "total" refers to. Remove non-multibyte code.
2002-08-27Reimplement pg_dumpall in C. Currently no change in functionality,Peter Eisentraut
except that it's more robust, reconnects less often, and is NLS'ed.
2002-08-27PREPARE/EXECUTE statements. Patch by Neil Conway, some kibitzingTom Lane
from Tom Lane.
2002-08-27Cleanup of SGMLBruce Momjian
2002-08-27I attach a little patch to make CLUSTER set and reset the indisclusteredBruce Momjian
bit on the indexes. I also attach clusterdb and clusterdb.sgml; both of them are blatant rips of vacuumdb and vacuumdb.sgml, but get the job done. Please review them, as I'm probably making a lot of mistakes with SGML and I can't compile it here. vacuumdb itself is not very comfortable to use when the databases have passwords, because it has to connect once for each table (I can probably make it connect only once for each database; should I?). Because of this I added a mention of PGPASSWORDFILE in the documentation, but I don't know if that is the correct place for that. Alvaro Herrera
2002-08-26Add OS X link line example for external functions.Bruce Momjian
2002-08-26Add mention of 1 terrabyte databases.Bruce Momjian
2002-08-25Update docs for 7.2.2 release info.Bruce Momjian
2002-08-25Update Japanese FAQ, from Jun KuwamuraBruce Momjian
2002-08-24The cstring datatype can now be copied, passed around, etc. The typlenTom Lane
value '-2' is used to indicate a variable-width type whose width is computed as strlen(datum)+1. Everything that looks at typlen is updated except for array support, which Joe Conway is working on; at the moment it wouldn't work to try to create an array of cstring.
2002-08-23Further cleanup around the edges of OPAQUE/pseudotype changes. CorrectTom Lane
the declarations of some index access method support functions. Support SQL functions returning VOID.
2002-08-23Not sure how I fixed it the first time, but here's a fix for anotherBruce Momjian
instance in which the docs mention that 'NAMEDATALEN == 32". Neil Conway
2002-08-23This patch updates the CREATE OPERATOR sgml docs for the new defaultBruce Momjian
settings of NAMEDATALEN. I looked through the docs for other references to NAMEDATALEN, but this is the only one I could find. Neil Conway
2002-08-23Update Russian FAQ.Bruce Momjian
2002-08-23Very minor copy-editing.Tom Lane
2002-08-23Add note that explains that \df omits functions it thinks are I/O functions.Tom Lane
2002-08-23Update reference to value of NAMEDATALEN. Someone needs to troll theTom Lane
docs and find the other obsolete statements that no doubt lurk.
2002-08-22Mark 7.2.2 as newest release.Bruce Momjian
2002-08-22Update FAQ.Bruce Momjian
2002-08-22Improve wording of upgrade section.Bruce Momjian
2002-08-22Fix for documention:Bruce Momjian
>>" It's also possible to select no escape character by writing ESCAPE ''. >>In this case there is no way to turn off the special meaning of >>underscore and percent signs in the pattern." Joe Conway
2002-08-22> > I had great difficulty in finding how to change the search path, so hereBruce Momjian
> > is a patch to add some cross-referencing. Oliver Elphick
2002-08-22Remove libpq++ SGML documentation.Bruce Momjian