Re: [HACKERS] odd error creating index in -current... - Mailing list pgsql-hackers

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
                ^^^
??? NOT NULL appeared in 6.2...

6.3:
vac=> CREATE TABLE groups (
vac->   id CHAR(10) NOT NULL,
vac->   detail CHAR(30)
vac-> ) \g
CREATE
vac=>
vac=> CREATE   INDEX groups_indx ON groups ( id ) \g
CREATE
vac=>
vac=> INSERT INTO groups (id, detail) VALUES ('PTS','PTS Development')\g
INSERT 43725 1

Vadim