On Tue, 12 Jan 1999, Bruce Momjian wrote:

> >     postgres=> create table a (b int8);
> >     CREATE
> >     postgres=> create index c on a(b);
> >     ERROR:  Can't find a default operator class for type 20.
> > 
> > Any ideas on this problem? Many thanx in advance.
> 
> We don't have indexes for int8 yet.  Sorry.
I have same problem with timestamp to, but some insert query to system
tables (4xmpl. pg_am) solve this. (create some acces method, & use the btree
stategy)
I read only, the man of create_index. i can't attach my script yet, but any
mortal can write it, i mean, based this manual.

sprintf         ("`-''-/").___..--''"`-._            Error In
("%|s",          `6_ 6  )   `-.  (     ).`-.__.`)    Loading Object
"Petike"         (_Y_.)'  ._   )  `._ `. ``-..-'     line:3
/* Neko */     _..`--'_..-_/  /--'_.' ,'             Before /*Neko*/
 );           (il),-''  (li),'  ((!.-'

Reply via email to