• Bruce Momjian's avatar
    Appears there is a problem finding the opclass when indexing a domain. · 46aaa5dd
    Bruce Momjian authored
    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
    46aaa5dd
indexcmds.c 21.6 KB