Postgres Pro
Downloads
Home   >   mailing lists

Create index syntax error - Mailing list pgsql-general

From Chris Velevitch
Subject Create index syntax error
Date
Msg-id b0a3bf780711282120w13e7757em4b8e1a751c03361@mail.gmail.com
Whole thread Raw
Responses Re: Create index syntax error  (Chris <dmagick@gmail.com>)
Re: Create index syntax error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Error compiling Slony I
Next
From: Tom Lane
Date:
Subject: Re: Btree indexes temp copy Was [Re: Cluster using tablespaces?]