Create index syntax error

From: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Create index syntax error
Date: 2007-11-29 05:20:03
Message-ID: b0a3bf780711282120w13e7757em4b8e1a751c03361@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

create index job_approver1_idx on jobs (approver1_id)

I'm using 7.4 and pgAdmin 1.8 and I don't see why this simple command
has a syntax error:-

Query result with 0 rows will be returned.

ERROR: syntax error at or near "index"
LINE 1: EXPLAIN create index job_approver1_idx on jobs (approver1_id)
^

********** Error **********

ERROR: syntax error at or near "index"
SQL state: 42601
Character: 16

Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-29 05:25:43 Re: Btree indexes temp copy Was [Re: Cluster using tablespaces?]
Previous Message Alvaro Herrera 2007-11-29 03:09:36 Re: Error compiling Slony I