aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
Commit message (Collapse)AuthorAge
* ALTER DOMAIN OWNER, from Rod Taylor.Tom Lane2003-01-06
|
* Code review for CLUSTER ALL patch. Fix bogus locking, incorrect transactionTom Lane2002-12-30
| | | | stop/start nesting, other infelicities.
* Cause FETCH 1 to return the current cursor row, or zero if atBruce Momjian2002-12-30
| | | | | | | | | | | | beginning/end of cursor. Have MOVE return 0/1 depending on cursor position. Matches SQL spec. Pass cursor counter from parser as a long rather than int. Doc updates.
* Improvement to CREATE TRIGGER and catalog documentation.Bruce Momjian2002-12-17
| | | | Neil Conway
* Document that zero-column tables are allowed (and non-standard).Tom Lane2002-12-16
|
* TODO marked as done:Bruce Momjian2002-12-12
| | | | | | | | | | | | | | | | | | | | | * Add schema, cast, and conversion backslash commands to psql I had to create a new publically available function, pg_conversion_is_visible, as it seemed to be missing from the catalogs. This required me to do no small amount of hacking around in namespace.c I have updated the \? help and sgml docs. \dc - list conversions [PATTERN] \dC - list casts \dn list schemas I didn't support patterns with casts as there's nothing obvious to match against. Catalog version incremented --- initdb required. Christopher Kings-Lynne
* Preliminary code review for domain CHECK constraints patch: add documentation,Tom Lane2002-12-12
| | | | | | | | make VALUE a non-reserved word again, use less invasive method of passing ConstraintTestValue into transformExpr, fix problems with nested constraint testing, do correct thing with NULL result from a constraint expression, remove memory leak. Domain checks still need much more work if we are going to allow ALTER DOMAIN, however.
* In the examples, I missed changing a few 'column' and 'table' mentionsBruce Momjian2002-12-06
| | | | | | to domain when copying alter table docs. -- Rod Taylor <rbt@rbt.ca>
* Mark ALTER DOMAIN as supported, fix typo in header.Bruce Momjian2002-12-06
|
* Re-addd Rod's ALTER DOMAIN patch.Bruce Momjian2002-12-06
|
* Add file.Bruce Momjian2002-12-06
|
* Add SGML file.Bruce Momjian2002-12-06
|
* Back out ALTER DOMAIN patch until missing file appears.Bruce Momjian2002-12-06
|
* ALTER DOMAIN .. SET / DROP NOT NULLBruce Momjian2002-12-06
| | | | | | | | | | ALTER DOMAIN .. SET / DROP DEFAULT ALTER DOMAIN .. ADD / DROP CONSTRAINT New files: - doc/src/sgml/ref/alter_domain.sgml Rod Taylor
* With a recent commit truncate is transaction safe in 7.4.Bruce Momjian2002-12-06
| | | | Rod Taylor
* This patch implements FOR EACH STATEMENT triggers, per my email toBruce Momjian2002-11-23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | -hackers a couple days ago. Notes/caveats: - added regression tests for the new functionality, all regression tests pass on my machine - added pg_dump support - updated PL/PgSQL to support per-statement triggers; didn't look at the other procedural languages. - there's (even) more code duplication in trigger.c than there was previously. Any suggestions on how to refactor the ExecXXXTriggers() functions to reuse more code would be welcome -- I took a brief look at it, but couldn't see an easy way to do it (there are several subtly-different versions of the code in question) - updated the documentation. I also took the liberty of removing a big chunk of duplicated syntax documentation in the Programmer's Guide on triggers, and moving that information to the CREATE TRIGGER reference page. - I also included some spelling fixes and similar small cleanups I noticed while making the changes. If you'd like me to split those into a separate patch, let me know. Neil Conway
* Fixups for man pagesPeter Eisentraut2002-11-21
|
* Remove ALL from CLUSTER ALL. Use just CLUSTER.Bruce Momjian2002-11-18
|
* Re-order REINDEX options in manual for consistency. REINDEXBruce Momjian2002-11-17
| | | | DATABASE/TABLE/INDEX is the proper order.
* SGML improvements.Bruce Momjian2002-11-15
| | | | Neil Conway
* New version attached. The following is implemented:Bruce Momjian2002-11-15
| | | | | | | | | | | - CLUSTER ALL clusters all the tables that have some index with indisclustered set and the calling user owns. - CLUSTER tablename clusters the named table, using the index with indisclustered set. If no index has the bit set, throws elog(ERROR). - The multi-relation version (CLUSTER ALL) uses a multitransaction approach, similar to what VACUUM does. Alvaro Herrera
* Add DOMAIN check constraints.Bruce Momjian2002-11-15
| | | | Rod Taylor
* Make MOVE/FETCH 0 actually move/fetch 0. Add MOVE LAST to move to endBruce Momjian2002-11-13
| | | | of cursor.
* Code review for ON COMMIT patch. Make the actual on-commit action happenTom Lane2002-11-11
| | | | | | | | | before commit, not after :-( --- the original coding is not only unsafe if an error occurs while it's processing, but it generates an invalid sequence of WAL entries. Resurrect 7.2 logic for deleting items when no longer needed. Use an enum instead of random macros. Editorialize on names used for routines and constants. Teach backend/nodes routines about new field in CreateTable struct. Add a regression test.
* Tweak CREATE SEQUENCE grammar to be more SQL1999 standards compliant.Bruce Momjian2002-11-10
| | | | Neil Conway
* Add code to handle [ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP }]Bruce Momjian2002-11-09
| | | | | | for temp tables. Gavin Sherry
* Here is a patch that does just that, while maintaining theBruce Momjian2002-11-08
| | | | | | | | "traditional" behavior, so the change should be transparent. Use the command "\pset pager always" to turn it on. Anything else does the normal toggle between "on" and "off" Greg Sabino Mullane
* Fix permissions-checking bugs and namespace-search-path bugs inTom Lane2002-11-02
| | | | | CONVERSION code. Still need to figure out what to do about inappropriate coding in parsing.
* Add note about sort order of character datatypes being locale-dependent,Tom Lane2002-10-24
| | | | per suggestion from Nicolaus Erichsen.
* Add introductory sections explaining what each book is about. Remove Y2KPeter Eisentraut2002-10-24
| | | | statement.
* Add mention of postgres signals to reference pageBruce Momjian2002-10-23
| | | | Joseph Shraibman
* Improve ECPG documentation.Peter Eisentraut2002-10-21
|
* Since ANY is a reserved word, better suggest that ANY be quoted whenTom Lane2002-10-21
| | | | used for the input type of an aggregate.
* Fix inconsistent formatting.Tom Lane2002-10-19
|
* Fix incomplete definition of ALTER TABLE ADD/DROP CONSTRAINT syntax.Tom Lane2002-10-19
| | | | | Add some verbiage about recent tweaks to behavior of ADD and DROP COLUMN when there are descendant tables.
* Fix psql's \copy to accept table names containing schemas, as well asTom Lane2002-10-19
| | | | | | | a column list. Bring its parsing of quoted names and quoted strings somewhat up to speed --- I believe it now handles all non-error cases the same way the backend would, but weird boundary conditions are not necessarily done the same way.
* Improve discussion of FOR UPDATE.Tom Lane2002-10-18
|
* Make SET really not start a transaction.Tom Lane2002-10-13
|
* Assorted reference page updatesPeter Eisentraut2002-10-11
|
* set.patch updates an example in ref/set.sgml to have microsecondBruce Momjian2002-10-09
| | | | | | | | | precision. vacuum.patch updates ref/vacuum.sgml to explicitly state that an exclusive lock is not obtained during normal (non-FULL) vacuum. Rod Taylor
* Have SET not start transaction when autocommit off, with doc updates.Bruce Momjian2002-10-09
|
* Restrict CREATE OPERATOR CLASS to superusers, per discussion some weeksTom Lane2002-10-04
| | | | ago.
* Require superuser privilege to create a binary-compatible cast, perTom Lane2002-10-04
| | | | | | discussion some weeks ago. Also, add a check that two types to be binary-equivalenced match as to typlen, typbyval, and typalign; if they don't then it's surely a mistake to equivalence them.
* Re-enable pg_resetxlog to accept -l values in hexadecimal (it used toTom Lane2002-10-02
| | | | | | be able to do that, but the ability seems to have got lost in the shuffle). Add a -o nextOID switch for completeness. Improve the documentation to explain how and why to use these switches.
* Change default privileges for languages and functions to be PUBLIC USAGETom Lane2002-09-24
| | | | | and PUBLIC EXECUTE, respectively. Per discussion about easing updates from prior versions.
* Make \dS work more like it used to, viz, show only system objects.Tom Lane2002-09-22
|
* Provide an upgrade strategy for dump files containing functions declaredTom Lane2002-09-21
| | | | | | | | with OPAQUE. CREATE LANGUAGE, CREATE TRIGGER, and CREATE TYPE will all accept references to functions declared with OPAQUE --- but they will issue a NOTICE, and will modify the function entries in pg_proc to have the preferred type-safe argument or result types instead of OPAQUE. Per recent pghackers discussions.
* Add more appropriate markup.Peter Eisentraut2002-09-21
|
* This patch corrects a minor mis-statement in the CREATE DOMAIN docs,Bruce Momjian2002-09-20
| | | | | | | pointed out by Chris KL on -hackers a little while ago -- NOT NULL != CHECK xxx IS NOT NULL. Neil Conway
* Extend pg_cast castimplicit column to a three-way value; this allows usTom Lane2002-09-18
| | | | | | | | | | | | | | | | | | | | | | | | to be flexible about assignment casts without introducing ambiguity in operator/function resolution. Introduce a well-defined promotion hierarchy for numeric datatypes (int2->int4->int8->numeric->float4->float8). Change make_const to initially label numeric literals as int4, int8, or numeric (never float8 anymore). Explicitly mark Func and RelabelType nodes to indicate whether they came from a function call, explicit cast, or implicit cast; use this to do reverse-listing more accurately and without so many heuristics. Explicit casts to char, varchar, bit, varbit will truncate or pad without raising an error (the pre-7.2 behavior), while assigning to a column without any explicit cast will still raise an error for wrong-length data like 7.3. This more nearly follows the SQL spec than 7.2 behavior (we should be reporting a 'completion condition' in the explicit-cast cases, but we have no mechanism for that, so just do silent truncation). Fix some problems with enforcement of typmod for array elements; it didn't work at all in 'UPDATE ... SET array[n] = foo', for example. Provide a generalized array_length_coerce() function to replace the specialized per-array-type functions that used to be needed (and were missing for NUMERIC as well as all the datetime types). Add missing conversions int8<->float4, text<->numeric, oid<->int8. initdb forced.
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-25 13:37:56 +0000