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

Commit7e5e7ab

Browse files
committed
Update opclass to be non-unique.
1 parent838fb5c commit7e5e7ab

File tree

2 files changed

+7
-9
lines changed

2 files changed

+7
-9
lines changed

‎src/include/catalog/indexing.h

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
* Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: indexing.h,v 1.29 1999/11/22 17:56:37 momjian Exp $
10+
* $Id: indexing.h,v 1.30 1999/11/23 04:47:39 momjian Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -182,7 +182,8 @@ DECLARE_UNIQUE_INDEX(pg_inherits_relid_seqno_index on pg_inherits using btree(in
182182
DECLARE_UNIQUE_INDEX(pg_language_name_indexonpg_languageusingbtree(lannamename_ops));
183183
DECLARE_UNIQUE_INDEX(pg_language_oid_indexonpg_languageusingbtree(oidoid_ops));
184184
DECLARE_UNIQUE_INDEX(pg_listener_relname_pid_indexonpg_listenerusingbtree(relnamename_ops,listenerpidint4_ops));
185-
DECLARE_UNIQUE_INDEX(pg_opclass_deftype_indexonpg_opclassusingbtree(opcdeftypeoid_ops));
185+
/* This column needs to allow multiple zero entries, but is in the cache */
186+
DECLARE_INDEX(pg_opclass_deftype_indexonpg_opclassusingbtree(opcdeftypeoid_ops));
186187
DECLARE_UNIQUE_INDEX(pg_opclass_name_indexonpg_opclassusingbtree(opcnamename_ops));
187188
DECLARE_UNIQUE_INDEX(pg_operator_oid_indexonpg_operatorusingbtree(oidoid_ops));
188189
DECLARE_UNIQUE_INDEX(pg_operator_oprname_l_r_k_indexonpg_operatorusingbtree(oprnamename_ops,oprleftoid_ops,oprrightoid_ops,oprkindchar_ops));

‎src/include/catalog/pg_opclass.h

Lines changed: 4 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
* Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_opclass.h,v 1.21 1999/11/22 17:56:37 momjian Exp $
10+
* $Id: pg_opclass.h,v 1.22 1999/11/23 04:47:39 momjian Exp $
1111
*
1212
* NOTES
1313
* the genbki.sh script reads this file and generates .bki
@@ -68,11 +68,9 @@ DATA(insert OID = 422 (box_ops603 ));
6868
DESCR("");
6969
DATA(insertOID=423 (float8_ops701 ));
7070
DESCR("");
71-
/* Technically, deftype is wrong, but it must be unique for index, bjm */
72-
DATA(insertOID=424 (int24_ops424 ));
71+
DATA(insertOID=424 (int24_ops0 ));
7372
DESCR("");
74-
/* Technically, deftype is wrong, but it must be unique for index, bjm */
75-
DATA(insertOID=425 (int42_ops425 ));
73+
DATA(insertOID=425 (int42_ops0 ));
7674
DESCR("");
7775
DATA(insertOID=426 (int4_ops23 ));
7876
DESCR("");
@@ -87,8 +85,7 @@ DATA(insert OID = 431 (text_ops 25 ));
8785
DESCR("");
8886
DATA(insertOID=432 (abstime_ops702 ));
8987
DESCR("");
90-
/* Technically, deftype is wrong, but it must be unique for index, bjm */
91-
DATA(insertOID=433 (bigbox_ops433 ));
88+
DATA(insertOID=433 (bigbox_ops603 ));
9289
DESCR("");
9390
DATA(insertOID=434 (poly_ops604 ));
9491
DESCR("");

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp