On Fri, 20 Feb 1998, Vadim B. Mikheev wrote:
> 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
Strange...I'm going to re-check this all through tonight when I get home,
since I've obviously got something messed up on my computer...
As for the 'NOT NULL'...I'm trying to get the PostgreSQL stuff up to date
in PTS for v6.3 ... I added in the NOT NULL last night...