Re: [HACKERS] Indexing new type ........

2001-02-15 Thread Tom Lane
<[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

[HACKERS] Indexing new type ........

2001-02-15 Thread pejac
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' ;