| From: | Brett McCormick <brett(at)work(dot)chicken(dot)org> |
|---|---|
| To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] odd error creating index in -current... |
| Date: | 1998-02-20 05:28:00 |
| Message-ID: | 199802200528.VAA11926@abraxas.scene.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas G. Lockhart | 1998-02-20 05:29:39 | Re: [HACKERS] Another one I thought should work... |
| Previous Message | Brett McCormick | 1998-02-20 05:26:14 | Re: [HACKERS] Who is everyone? |