| From: | momjian(at)postgresql(dot)org (Bruce Momjian - CVS) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql-server/src/backend/commands indexcmds.c |
| Date: | 2002-08-15 02:53:35 |
| Message-ID: | 20020815025335.9A9AA475C52@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian(at)postgresql(dot)org 02/08/14 22:53:35
Modified files:
src/backend/commands: indexcmds.c
Log message:
Appears there is a problem finding the opclass when indexing a domain.
CREATE DOMAIN newint as int4;
CREATE TABLE tab (col newint unique);
ERROR: data type newint has no default operator class for access method
"btree"
You must specify an operator class for the index or define a
default operator class for the data type
Specifically, GetDefaultOpClass() finds 0 exact matches and 3 binary
compatible matches. Fetching getBaseType() of the attribute fixes the
problem for domains (see attachment).
Rod Taylor
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian - CVS | 2002-08-15 02:56:19 | pgsql-server/ oc/src/sgml/libpq++.sgml oc/src/ ... |
| Previous Message | Bruce Momjian - CVS | 2002-08-15 02:51:28 | pgsql-server/ ontrib/tablefunc/README.tablefun ... |