
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



Fri, 20 Feb 1998 00:58:08 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
odd error creating index in -current...

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

Thu, 19 Feb 1998 21:28:00 -0800
Brett McCormick <brett@work.chicken.org>
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 


Fri, 20 Feb 1998 01:35:13 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] odd error creating index in -current...
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

Fri, 20 Feb 1998 12:38:26 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] odd error creating index in -current...
Brett McCormick wrote:
> 
> I may be missing something, but because char_ops has been left out?

It's good in _most_ cases to let all XXX_ops be left out :)
Indices know what to use...

Vadim

Fri, 20 Feb 1998 12:53:52 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] odd error creating index in -current...

I'm still living in pre 6.0 days, then..  are indices on type oid
atttributes used as well?

On Fri, 20 February 1998, at 12:53:52, Vadim B. Mikheev wrote:

> It's good in _most_ cases to let all XXX_ops be left out :)
> Indices know what to use...
> 
> Vadim

Thu, 19 Feb 1998 22:24:23 -0800
Brett McCormick <brett@work.chicken.org>
Re: [HACKERS] odd error creating index in -current...
Brett McCormick wrote:
> 
> I'm still living in pre 6.0 days, then..  are indices on type oid
> atttributes used as well?
> 
> On Fri, 20 February 1998, at 12:53:52, Vadim B. Mikheev wrote:
> 
> > It's good in _most_ cases to let all XXX_ops be left out :)
> > Indices know what to use...

They should... Just try.

Vadim

Fri, 20 Feb 1998 14:08:27 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] odd error creating index in -current...
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...



Fri, 20 Feb 1998 07:48:49 -0500 (EST)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] odd error creating index in -current...