summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
AgeCommit message (Collapse)Author
2004-02-03Rename SortMem and VacuumMem to work_mem and maintenance_work_mem.Tom Lane
Make btree index creation and initial validation of foreign-key constraints use maintenance_work_mem rather than work_mem as their memory limit. Add some code to guc.c to allow these variables to be referenced by their old names in SHOW and SET commands, for backwards compatibility.
2004-01-26Add usage examples for PREPARE and EXECUTE. Original patch from GavinNeil Conway
Sherry, editorializing by Neil Conway.
2004-01-20Implement '\copy from -' to support reading copy data from the sameTom Lane
source the \copy came from. Also, fix prompting logic so that initial and per-line prompts appear for all cases of reading from an interactive terminal. Patch by Mark Feit, with some kibitzing by Tom Lane.
2004-01-20This is a patch to support readline prompts which contain non-printingTom Lane
characters, as for fancy colorized prompts. This was nearly a direct lift from bash-2.05b's lib/readline/display.c, per guidance from Chet Ramey. Reece Hart
2004-01-11Put See Also links back in alphabetical order.Peter Eisentraut
2004-01-11Minor documentation improvements.Neil Conway
2004-01-11Add CREATE TRIGGER, CREATE INDEX, and CREATE SEQUENCE to the list ofNeil Conway
expressions supported by CREATE SCHEMA. Also added the beginning of some regression tests for CREATE SCHEMA; plenty more work is needed here.
2004-01-10Implement "WITH / WITHOID OIDS" clause for CREATE TABLE AS. This isNeil Conway
intended to allow application authors to insulate themselves from changes to the default value of 'default_with_oids' in future releases of PostgreSQL. This patch also fixes a bug in the earlier implementation of the 'default_with_oids' GUC variable: code in gram.y should not examine the value of GUC variables directly due to synchronization issues.
2004-01-10Allow BEGIN WORK to specify transaction isolation level, like STARTBruce Momjian
TRANSACTION.
2004-01-06Make the 'wal_debug' GUC variable a boolean (rather than an integer), andNeil Conway
hide it behind #ifdef WAL_DEBUG blocks.
2003-12-23Supress non-temp schemas from psql \dn display.Bruce Momjian
2003-12-14Fix two typos in the documentation for PREPARE.Neil Conway
2003-12-14This patch fixes a few more uppercase GUC vars. I also removed anNeil Conway
example from the RESET reference page because it seemed completely redundant.
2003-12-14This patch makes some SGML markup more consistent and makes a smallNeil Conway
improvement to the SSL auth docs.
2003-12-13This patch makes some SGML markup more consistent and makes a smallNeil Conway
improvement to the SSL auth docs.
2003-12-11Make some wording consistent with DROP OPERATOR description.Peter Eisentraut
2003-12-06Massive overhaul of pg_dump: make use of dependency information fromTom Lane
pg_depend to determine a safe dump order. Defaults and check constraints can be emitted either as part of a table or domain definition, or separately if that's needed to break a dependency loop. Lots of old half-baked code for controlling dump order removed.
2003-12-02Code and docs review for numeric-factorial patch.Tom Lane
2003-12-01attached is a patch that adds display of the groups a user belongs to toBruce Momjian
\du and a \dg command to psql. It's against 7.4beta5. Markus Bertheau <twanger@bluetwanger.de>
2003-12-01This patch adds a new GUC var, "default_with_oids", which follows theBruce Momjian
proposal for eventually deprecating OIDs on user tables that I posted earlier to pgsql-hackers. pg_dump now always specifies WITH OIDS or WITHOUT OIDS when dumping a table. The documentation has been updated. Neil Conway
2003-12-01Fix typos noted by Halley Pacheco de Oliveira.Tom Lane
2003-11-29$Header: -> $PostgreSQL Changes ...PostgreSQL Daemon
2003-11-25Fix language.Peter Eisentraut
2003-11-21COMMENT ON casts, conversions, languages, operator classes, andTom Lane
large objects. Dump all these in pg_dump; also add code to pg_dump user-defined conversions. Make psql's large object code rely on the backend for inserting/deleting LOB comments, instead of trying to hack pg_description directly. Documentation and regression tests added. Christopher Kings-Lynne, code reviewed by Tom
2003-11-14Repair error in syntax documentation for CREATE TABLE: one does not putTom Lane
a comma between multiple column_constraint's for a single column. Per report from Tomislaw Kitynski.
2003-11-12Documentation cleanupPeter Eisentraut
2003-11-12Here's a patch that adds some text mentioning thatBruce Momjian
RESTRICT is not deferrable to the create table reference page. Stephan Szabo
2003-11-08Adjust file so psql help picks it up properly.Peter Eisentraut
patch by Kris Jurka
2003-11-06Implement isolation levels read uncommitted and repeatable read as actingPeter Eisentraut
like the next higher one.
2003-11-04Random copy-editing.Peter Eisentraut
2003-11-04Copy-editing.Tom Lane
2003-11-02Fix language.Peter Eisentraut
2003-11-02pg_dumpall doesn't use psql anymore.Peter Eisentraut
2003-11-02Put --describe-config in the right place.Peter Eisentraut
2003-11-02Complete options help and put it in less random order.Peter Eisentraut
2003-11-01Spell checking, consistent terminology.Peter Eisentraut
2003-10-31When a superuser does GRANT or REVOKE on an object he doesn't own,Tom Lane
process the command as though it were issued by the object owner. This prevents creating weird scenarios in which the same privileges may appear to flow from different sources, and ensures that a superuser can in fact revoke all privileges if he wants to. In particular this means that the regression tests work when run by a superuser other than the original bootstrap userid. Per report from Larry Rosenman.
2003-10-28Add --describe-config to top of postgres manual page.Bruce Momjian
2003-10-28Document --describe-config.Bruce Momjian
2003-10-26Add mention of quotes on function body to NOTES section.Bruce Momjian
Oliver Elphick
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-16Add mention of SIGHUP on the postmaster manual page.Bruce Momjian
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-04Change transaction status indicator in prompt from %T to %x.Peter Eisentraut
2003-09-30Minor copy-editing.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-28Update docs on function call permissions in view, from Tom.Bruce Momjian
2003-09-27Document that functions are checked independently of the viewBruce Momjian
permissions.
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.
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-19 08:17:15 +0000