Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit8a10096

Browse files
committed
information_schema.key_column_usage.position_in_unique_constraint was
misdocumented as not being implemented. In reality it has worked sincethe release of 8.2.
1 parent6bbef4e commit8a10096

File tree

1 file changed

+8
-6
lines changed

1 file changed

+8
-6
lines changed

‎doc/src/sgml/information_schema.sgml

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.34 2008/09/08 00:47:40 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.35 2008/11/25 20:47:42 tgl Exp $ -->
22

33
<chapter id="information-schema">
44
<title>The Information Schema</title>
@@ -2192,7 +2192,7 @@ ORDER BY c.ordinal_position;
21922192
<entry><type>sql_identifier</type></entry>
21932193
<entry>
21942194
Name of the database that contains the table that contains the
2195-
column that is restricted bysome constraint (always the
2195+
column that is restricted bythis constraint (always the
21962196
current database)
21972197
</entry>
21982198
</row>
@@ -2202,7 +2202,7 @@ ORDER BY c.ordinal_position;
22022202
<entry><type>sql_identifier</type></entry>
22032203
<entry>
22042204
Name of the schema that contains the table that contains the
2205-
column that is restricted bysome constraint
2205+
column that is restricted bythis constraint
22062206
</entry>
22072207
</row>
22082208

@@ -2211,15 +2211,15 @@ ORDER BY c.ordinal_position;
22112211
<entry><type>sql_identifier</type></entry>
22122212
<entry>
22132213
Name of the table that contains the column that is restricted
2214-
bysome constraint
2214+
bythis constraint
22152215
</entry>
22162216
</row>
22172217

22182218
<row>
22192219
<entry><literal>column_name</literal></entry>
22202220
<entry><type>sql_identifier</type></entry>
22212221
<entry>
2222-
Name of the column that is restricted bysome constraint
2222+
Name of the column that is restricted bythis constraint
22232223
</entry>
22242224
</row>
22252225

@@ -2236,7 +2236,9 @@ ORDER BY c.ordinal_position;
22362236
<entry><literal>position_in_unique_constraint</literal></entry>
22372237
<entry><type>cardinal_number</type></entry>
22382238
<entry>
2239-
Not yet implemented
2239+
For a foreign-key constraint, ordinal position of the referenced
2240+
column within its unique constraint (count starts at 1);
2241+
otherwise null
22402242
</entry>
22412243
</row>
22422244
</tbody>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp