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

Brett McCormick <brett@work.chicken.org>

From: Brett McCormick <brett@work.chicken.org>
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-02-20T05:28:00Z
Lists: pgsql-hackers
I may be missing something, but because char_ops has been left out?

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
> 
>