summaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAgeFilesLines
* Department of second thoughts: make checks for replacing a view slightlyTom Lane2002-09-023-13/+36
| | | | | more flexible, and improve the error reporting. Also, add documentation for REPLACE RULE/VIEW.
* Fix broken markup.Tom Lane2002-09-021-1/+2
|
* This patch fixes a minor inaccuracy in the documentation: NOT NULL isBruce Momjian2002-09-021-4/+2
| | | | | | | | not synonymous with CHECK (xxx IS NOT NULL) -- for example, consider ALTER TABLE ADD PRIMARY KEY, which checks for 'NOT NULL', not a check constraint. Neil Conway
* I checked all the previous string handling errors and most of them wereBruce Momjian2002-09-021-2/+2
| | | | | | | | | | | | | | | already fixed by You. However there were a few left and attached patch should fix the rest of them. I used StringInfo only in 2 places and both of them are inside debug ifdefs. Only performance penalty will come from using strlen() like all the other code does. I also modified some of the already patched parts by changing snprintf(buf, 2 * BUFSIZE, ... style lines to snprintf(buf, sizeof(buf), ... where buf is an array. Jukka Holappa
* Here's a doc patch for the new string functions recently committed --Bruce Momjian2002-09-021-29/+64
| | | | | | | replace, split, and to_hex. The patch also moves encode and decode into alphabetical order (since everything else in the table was). Joe Conway
* Move pg_settings doc into the right section.Bruce Momjian2002-09-022-63/+56
|
* Here is a documentation patch for the pg_settings virtual table. IfBruce Momjian2002-09-021-1/+62
| | | | | | there are no objections, please apply. Joe Conway
* Add GUC variable to print original query to the server logs when thereBruce Momjian2002-09-021-4/+25
| | | | | | is an error, warning, etc. Gavin Sherry
* Code review for HeapTupleHeader changes. Add version number to page headersTom Lane2002-09-021-65/+94
| | | | | | | | | | (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.
* Add log_duration to GUC/postgresql.conf.Bruce Momjian2002-09-012-6/+25
| | | | | Rename debug_print_query to log_statement and rename show_query_stats to show_statement_stats.
* plpgsql functions can return RECORD, per Neil Conway.Tom Lane2002-09-012-4/+23
|
* Minor copy-editing.Tom Lane2002-09-011-8/+9
|
* Remove mention of wal_files in a SHOW example.Bruce Momjian2002-09-011-2/+1
|
* Code review for pg_locks feature. Make shmemoffset of PROCLOCK structsTom Lane2002-08-311-32/+56
| | | | | | | | 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.
* Updates to reflect availability of autocommit option.Tom Lane2002-08-302-25/+45
|
* AUTOCOMMIT mode is now an available backend GUC variable; setting itTom Lane2002-08-302-2/+26
| | | | | | | | | 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.
* Add attisinherited column to pg_attribute; use it to guard againstTom Lane2002-08-301-1/+11
| | | | | | 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.
* Update documentation for --with-perl.Bruce Momjian2002-08-301-13/+7
|
* Improve wording after wal_files removal.Bruce Momjian2002-08-301-5/+5
|
* Complete TODO item:Bruce Momjian2002-08-302-30/+10
| | | | | * Remove wal_files postgresql.conf option because WAL files are now recycled
* Back out password packet length check.Bruce Momjian2002-08-302-4/+4
| | | | Improve wording of pre-7.3 syntax mention.
* Add comment on old sytax for SELECT FOR UPDATE/LIMIT and COPY.Bruce Momjian2002-08-302-4/+18
|
* PL/pgSQL functions can return sets. Neil Conway's patch, modified soTom Lane2002-08-304-30/+70
| | | | | that the functionality is available to anyone via ReturnSetInfo, rather than hard-wiring it to PL/pgSQL.
* Make pg_resetxlog options parsing more standard and prepare messages forPeter Eisentraut2002-08-291-2/+2
| | | | translation.
* The unit for statement_timeout is s/1000, not s/1000000Bruce Momjian2002-08-291-2/+2
| | | | Manfred Koizar
* Adjust nodeFunctionscan.c to reset transient memory context between callsTom Lane2002-08-291-11/+35
| | | | | | | 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.
* A few more fixes for the <replaceable>able> fiasco.Tom Lane2002-08-291-7/+7
|
* FOUND patch was a bit over-enthusiastic: SQL commands that are notTom Lane2002-08-291-53/+57
| | | | | INSERT, UPDATE, or DELETE shouldn't change FOUND. IMHO anyway. Also, try to make documentation a little clearer.
* Remove support for version-0 FE/BE protocol, per pghackers discussion.Tom Lane2002-08-291-1/+2
| | | | This breaks support for 6.2 or older client libraries.
* Code review for standalone composite types, query-specified compositeTom Lane2002-08-295-264/+359
| | | | | types, SRFs. Not happy with memory management yet, but I'll commit these other changes.
* Add mention of foreign key dependency and SERIAL in 7.2 data restores.Bruce Momjian2002-08-281-1/+10
| | | | | | Note can probably be removed after a couple of releases. Rod Taylor
* Update info about relkind and pg_type entries for composite-types patch.Tom Lane2002-08-281-9/+13
|
* Allow FOR UPDATE to appear after LIMIT/OFFSET to match MySQL syntax and asBruce Momjian2002-08-283-20/+20
| | | | a more logical ordering.
* Enable locale, so case conversion (identifier processing) and numberPeter Eisentraut2002-08-271-2/+2
| | | | | | formatting (\timing) works correctly. Change "Total time" to "Time" since there is nothing that "total" refers to. Remove non-multibyte code.
* Reimplement pg_dumpall in C. Currently no change in functionality,Peter Eisentraut2002-08-272-85/+166
| | | | except that it's more robust, reconnects less often, and is NLS'ed.
* PREPARE/EXECUTE statements. Patch by Neil Conway, some kibitzingTom Lane2002-08-276-4/+489
| | | | from Tom Lane.
* Cleanup of SGMLBruce Momjian2002-08-272-60/+76
|
* I attach a little patch to make CLUSTER set and reset the indisclusteredBruce Momjian2002-08-273-2/+284
| | | | | | | | | | | | | | | | | 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
* Add OS X link line example for external functions.Bruce Momjian2002-08-261-1/+15
|
* Add mention of 1 terrabyte databases.Bruce Momjian2002-08-261-2/+2
|
* Update docs for 7.2.2 release info.Bruce Momjian2002-08-251-1/+48
|
* Update Japanese FAQ, from Jun KuwamuraBruce Momjian2002-08-251-56/+86
|
* The cstring datatype can now be copied, passed around, etc. The typlenTom Lane2002-08-241-3/+9
| | | | | | | 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.
* Further cleanup around the edges of OPAQUE/pseudotype changes. CorrectTom Lane2002-08-231-7/+11
| | | | | the declarations of some index access method support functions. Support SQL functions returning VOID.
* Not sure how I fixed it the first time, but here's a fix for anotherBruce Momjian2002-08-231-2/+2
| | | | | | instance in which the docs mention that 'NAMEDATALEN == 32". Neil Conway
* This patch updates the CREATE OPERATOR sgml docs for the new defaultBruce Momjian2002-08-232-4/+4
| | | | | | | settings of NAMEDATALEN. I looked through the docs for other references to NAMEDATALEN, but this is the only one I could find. Neil Conway
* Update Russian FAQ.Bruce Momjian2002-08-231-20/+73
|
* Very minor copy-editing.Tom Lane2002-08-231-3/+3
|
* Add note that explains that \df omits functions it thinks are I/O functions.Tom Lane2002-08-231-1/+10
|
* Update reference to value of NAMEDATALEN. Someone needs to troll theTom Lane2002-08-231-2/+2
| | | | docs and find the other obsolete statements that no doubt lurk.
View Lorry Controller Status