<[EMAIL PROTECTED]> writes:
> So i use the following query in order to have default operator:
> INSERT INTO pg_opclass(opcname,opcdeftype) select 'ean13_ops',oid
> from pg_type where typname = 'ean13' ;
> So the new error with postgresql when i try to create an index
> on my new type is : opclass
Hi,
Well i create a new type. I want indexing my new type but i
can't , postgresql erro : my type has no default operator class
So i use the following query in order to have default operator:
INSERT INTO pg_opclass(opcname,opcdeftype) select 'ean13_ops',oid
from pg_type where typname = 'ean13' ;