diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-04-27 00:33:46 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-04-27 00:33:46 +0000 |
| commit | 02eb8f4f5c93de08bfd916738e4e3c117d9fd968 (patch) | |
| tree | df284cbeb4ffb5669d8efbbb811c5153fab61c37 /doc/src | |
| parent | 944a17bf9f7f8394b693b12a5861576964cad97b (diff) | |
| download | postgresql-02eb8f4f5c93de08bfd916738e4e3c117d9fd968.tar.gz postgresql-02eb8f4f5c93de08bfd916738e4e3c117d9fd968.zip | |
Use schema search path to find the first matching contraint name for SET
CONSTRAINT, rather than affecting all constraints in all schemas (which
is what we used to do). Also allow schema specifications.
Kris Jurka
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/set_constraints.sgml | 17 |
1 files changed, 5 insertions, 12 deletions
diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml index 3bcde91f386..9af82008aa3 100644 --- a/doc/src/sgml/ref/set_constraints.sgml +++ b/doc/src/sgml/ref/set_constraints.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/set_constraints.sgml,v 1.12 2004/09/10 18:39:53 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/set_constraints.sgml,v 1.13 2006/04/27 00:33:32 momjian Exp $ --> <refentry id="SQL-SET-CONSTRAINTS"> <refmeta> <refentrytitle id="SQL-SET-CONSTRAINTS-title">SET CONSTRAINTS</refentrytitle> @@ -45,10 +45,10 @@ SET CONSTRAINTS { ALL | <replaceable class="parameter">name</replaceable> [, ... <para> <command>SET CONSTRAINTS</command> with a list of constraint names changes - the mode of just those constraints (which must all be deferrable). If - there are multiple constraints matching any given name, all are affected. - <command>SET CONSTRAINTS ALL</command> changes the mode of all deferrable - constraints. + the mode of just those constraints (which must all be deferrable). The + current schema search path is used to find the first matching name if + no schema name is specified. <command>SET CONSTRAINTS ALL</command> + changes the mode of all deferrable constraints. </para> <para> @@ -93,13 +93,6 @@ SET CONSTRAINTS { ALL | <replaceable class="parameter">name</replaceable> [, ... foreign-key constraints. </para> - <para> - The SQL standard says that constraint names appearing in <command>SET - CONSTRAINTS</command> can be schema-qualified. This is not yet - supported by <productname>PostgreSQL</productname>: the names must - be unqualified, and all constraints matching the command will be - affected no matter which schema they are in. - </para> </refsect1> </refentry> |