From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Brett McCormick <brett(at)work(dot)chicken(dot)org> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] odd error creating index in -current... |
Date: | 1998-02-20 05:35:13 |
Message-ID: | Pine.BSF.3.96.980220013446.226u-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim B. Mikheev | 1998-02-20 05:38:26 | Re: [HACKERS] odd error creating index in -current... |
Previous Message | Thomas G. Lockhart | 1998-02-20 05:29:39 | Re: [HACKERS] Another one I thought should work... |