Re: [HACKERS] odd error creating index in -current...

On Thu, 19 Feb 1998, Brett McCormick wrote:

> 
> I may be missing something, but because char_ops has been left out?

	Last I knew, it wasn't required...it auto-detects it, and is, in
fact, the recommended method of creating an index...


> 
> On Fri, 20 February 1998, at 00:58:08, The Hermit Hacker wrote:
> 
> > Someone want to tell me why the below CREATE INDEX fails?  
> > 
> > I've tried everything I can think of, and can't get that INDEX to be
> > created :(
> > 
> > -- $Id: groups.psql,v 1.2 1997/08/14 20:05:08 shevett Exp $
> > -- postgresql 6.1
> > --
> > -- Host: localhost    Database: pts
> > ----------------------------------------------------------
> > 
> > 
> > --
> > -- Table structure for table 'groups'
> > --
> > CREATE TABLE groups (
> >   id CHAR(10) NOT NULL,
> >   detail CHAR(30)
> > ) \g
> > 
> > CREATE   INDEX groups_indx ON groups ( id ) \g
> > 
> > 
> > --
> > -- Dumping data for table 'groups'
> > --
> > 
> > INSERT INTO groups (id, detail) VALUES ('PTS','PTS Development')\g
> > 
> > 
> 

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org