summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
AgeCommit message (Collapse)Author
2004-07-19Here is another patch that fixes a stack of pg_dump bugs:Bruce Momjian
* Fix help text ordering * Add back --set-session-authorization to pg_dumpall. Updated the docs for that. Updated help for that. * Dump ALTER USER commands for the cluster owner ("pgsql"). These are dumped AFTER the create user and create database commands in case the permissions to do these have been revoked. * Dump ALTER OWNER for public schema (because it's possible to change it). This was done by adding TOC entries for the public schema, and filtering them out at archiver time. I also save the owner in the TOC entry just for the public schema. * Suppress dumping single quotes around schema_path and DateStyle options when they are set using ALTER USER or ALTER DATABASE. Added a comment to the steps in guc.c to remind people to update that list. * Fix dumping in --clean mode against a pre-7.3 server. It just sets all drop statements to assume the public schema, allowing it to restore without error. * Cleaned up text output. eg. Don't output -- Tablespaces comment if there are none. Same for groups and users. * Make the commands to DELETE FROM pg_shadow and DELETE FROM pg_group only be output when -c mode is enabled. I'm not sure why that hasn't been done before?!?! This should be good for application asap, after which I will start on regression dumping 7.0-7.4 databases. Christopher Kings-Lynne
2004-07-17Fix broken markup, per Jonathan Gardner.Tom Lane
2004-07-15Add permission display to \db+.Bruce Momjian
2004-07-14Detect locale/encoding mismatch in initdb, or pick a suitable encodingPeter Eisentraut
automatically if none was specified.
2004-07-13Have \dn+ show permissions and description for schemas.Bruce Momjian
Dennis Bjorklund
2004-07-13Change pg_dump to use ALTER OWNER commands instead of SET SESSIONBruce Momjian
AUTHORIZATION commands by default. Move all GRANT and REVOKE commands to the end of the dump to avoid restore failures in several situations. Bring back --use-set-session-authorization option to get previous SET behaviour Christopher Kings-Lyne
2004-07-12Add tablespace location display for psql \d.Bruce Momjian
Gavin Sherry
2004-07-12This patch adds the following options to pg_dumpall, to be passed toBruce Momjian
pg_dump: -S, --superuser=NAME -O, --no-owner -X disable-dollar-quoting, --disable-dollar-quoting -X disable-triggers, --disable-triggers Christopher Kings-Lynne
2004-07-12Remove TABLESPACE option of CREATE SEQUENCE; sequences will now alwaysTom Lane
live in database or schema's default tablespace, as per today's discussion. Also, remove some unused keywords from the grammar (PATH, PENDANT, VERSION), and fix ALSO, which was added as a keyword but not added to the keyword classification lists, thus making it worse-than-reserved.
2004-07-12Tablespace examples for CREATE TABLE/INDEX/SCHEMA/DATABASE as well asBruce Momjian
some other examples for CREATE DATABASE. Gavin Sherry
2004-07-11Example for create function using argument namesBruce Momjian
Gavin Sherry
2004-07-11ALTER TABLE SET TABLESPACE. Gavin Sherry, some rework by Tom Lane.Tom Lane
2004-07-11Allow configuration files to be placed outside the data directory.Bruce Momjian
Add new postgresql.conf variables to point to data, pg_hba.conf, and pg_ident.conf files. Needs more documentation.
2004-07-10Clarify schema meanings in pg_dump manual page by referring to objectBruce Momjian
definitions more frequently.
2004-07-05Fix paragraph mention in ALTER DATABASE manual page.Bruce Momjian
Christopher Kings-Lynne
2004-06-25Support renaming of tablespaces, and changing the owners ofTom Lane
aggregates, conversions, functions, operators, operator classes, schemas, types, and tablespaces. Fold the existing implementations of alter domain owner and alter database owner in with these. Christopher Kings-Lynne
2004-06-25Add argument name to syntax.Dennis Bjorklund
2004-06-24Add --pwfile option to initdb, so that passwords can be set by GUI toolsTom Lane
that aren't able to feed the password to initdb's /dev/tty. Magnus Hagander
2004-06-21Rename the built-in tablespaces to pg_default and pg_global, and prohibitTom Lane
creation of user-defined tablespaces with names starting with 'pg_', as per suggestion of Chris K-L. Also install admin-guide tablespace documentation from Gavin.
2004-06-18Replace createdb's obsolete --location switch with --tablespace.Tom Lane
I kept the same abbreviated letter -D, in hopes of maintaining some modicum of backwards compatibility (though it's doubtful whether anyone is really using scripts that invoke createdb -D ...)
2004-06-18initlocation is history. (It's still mentioned in manage-ag.sgml,Tom Lane
but I'll leave that file alone so as not to mess up the doc patch I trust Gavin is working on.)
2004-06-18Tablespaces. Alternate database locations are dead, long live tablespaces.Tom Lane
There are various things left to do: contrib dbsize and oid2name modules need work, and so does the documentation. Also someone should think about COMMENT ON TABLESPACE and maybe RENAME TABLESPACE. Also initlocation is dead, it just doesn't know it yet. Gavin Sherry and Tom Lane.
2004-06-17The attached patch adds some index entries pointing to the cursorBruce Momjian
reference pages. Please apply. Alvaro Herrera
2004-06-16Represent type-specific length coercion functions as pg_cast entries,Tom Lane
eliminating the former hard-wired convention about their names. Allow pg_cast entries to represent both type coercion and length coercion in a single step --- this is represented by a function that takes an extra typmod argument, just like a length coercion function. This nicely merges the type and length coercion mechanisms into something at least a little cleaner than we had before. Make use of the single- coercion-step behavior to fix integer-to-bit coercion so that coercing to bit(n) yields the rightmost n bits of the integer instead of the leftmost n bits. This should fix recurrent complaints about the odd behavior of this coercion. Clean up the documentation of the bit string functions, and try to put it where people might actually find it. Also, get rid of the unreliable heuristics in ruleutils.c about whether to display nested coercion steps; instead require parse_coerce.c to label them properly in the first place.
2004-06-09Support assignment to subfields of composite columns in UPDATE and INSERT.Tom Lane
As a side effect, cause subscripts in INSERT targetlists to do something more or less sensible; previously we evaluated such subscripts and then effectively ignored them. Another side effect is that UPDATE-ing an element or slice of an array value that is NULL now produces a non-null result, namely an array containing just the assigned-to positions.
2004-06-07Add start/stop times for pg_dump/pg_dumpall when verbose output is used.Bruce Momjian
2004-06-06Infrastructure for I/O of composite types: arrange for the I/O routinesTom Lane
of a composite type to get that type's OID as their second parameter, in place of typelem which is useless. The actual changes are mostly centralized in getTypeInputInfo and siblings, but I had to fix a few places that were fetching pg_type.typelem for themselves instead of using the lsyscache.c routines. Also, I renamed all the related variables from 'typelem' to 'typioparam' to discourage people from assuming that they necessarily contain array element types.
2004-06-04Remove dash in pg_ctl signal name. It broke with getopt_long dashBruce Momjian
reorganization processing, and it is clearer without the dash anyway.
2004-06-02Improve without cluster wording.Bruce Momjian
2004-06-02OK, here's the final version of ALTER TABLE ... SET WITHOUT CLUSTER.Bruce Momjian
Has docs + regression test. Christopher Kings-Lynne
2004-06-01Align GRANT/REVOKE behavior more closely with the SQL spec, per discussionTom Lane
of bug report #1150. Also, arrange that the object owner's irrevocable grant-option permissions are handled implicitly by the system rather than being listed in the ACL as self-granted rights (which was wrong anyway). I did not take the further step of showing these permissions in an explicit 'granted by _SYSTEM' ACL entry, as that seemed more likely to bollix up existing clients than to do anything really useful. It's still a possible future direction, though.
2004-05-31Update pg_dump -v comments to mention additional comments in dump file.Bruce Momjian
2004-05-27Document new pg_ctl 'kill' command, specificially for Win32.Bruce Momjian
2004-05-27Recommend ALTER TABLE ... TYPE as the best way to reclaim space occupied by ↵Tom Lane
deleted columns. The old method involving UPDATE and VACUUM FULL will be considerably less efficient.
2004-05-26This patch implement the TODO [ALTER DATABASE foo OWNER TO bar].Bruce Momjian
It was necessary to touch in grammar and create a new node to make home to the new syntax. The command is also supported in E CPG. Doc updates are attached too. Only superusers can change the owner of the database. New owners don't need any aditional privileges. Euler Taveira de Oliveira
2004-05-19Clearify CHECK handling of unknown test values.Bruce Momjian
Karl O. Pinc
2004-05-16Add documentation for the new "dollar quoting" feature, and update existingNeil Conway
examples to use dollar quoting when appropriate. Original patch from David Fetter, additional work and editorializing by Neil Conway.
2004-05-14Properly document rotatelogs, and add mention of it to pg_ctl manual page.Bruce Momjian
2004-05-06Erase MD5 user passwords when a user is renamed because the username isBruce Momjian
used as salt for the MD5 password.
2004-05-05ALTER TABLE rewrite. New cool stuff:Tom Lane
* ALTER ... ADD COLUMN with defaults and NOT NULL constraints works per SQL spec. A default is implemented by rewriting the table with the new value stored in each row. * ALTER COLUMN TYPE. You can change a column's datatype to anything you want, so long as you can specify how to convert the old value. Rewrites the table. (Possible future improvement: optimize no-op conversions such as varchar(N) to varchar(N+1).) * Multiple ALTER actions in a single ALTER TABLE command. You can perform any number of column additions, type changes, and constraint additions with only one pass over the table contents. Basic documentation provided in ALTER TABLE ref page, but some more docs work is needed. Original patch from Rod Taylor, additional work from Tom Lane.
2004-04-22Make psql's \d+ command indicate whether the table in questionNeil Conway
contains OIDs. Also, minor documentation improvements to the psql reference page.
2004-04-22Fix filename mention in psqlrc.sample file.Bruce Momjian
2004-04-22Put information about tag in Outputs section, where it belongs.Tom Lane
2004-04-22Update EXECUTE docs to mention tag matches prepared statement.Bruce Momjian
Update log_statement to more clearly state it doesn't filter based on the statement type of the prepared statement.
2004-04-22Add global psql config file, psql.rc.sample.Bruce Momjian
2004-04-21Minor improvement to CREATE AGGREGATE docs: add an xref to the docs forNeil Conway
builtin aggregate functions.
2004-04-21Change COPY CSV keyword to be:Bruce Momjian
FORCE QUOTE to force quotes FORCE NOT NULL to quote null input values
2004-04-20Improve IS NULL partial index wording.Bruce Momjian
2004-04-20Document partial indexes for IS NULL lookups.Bruce Momjian
2004-04-20Remove TCL docs.Bruce Momjian
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-18 04:03:22 +0000