Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create index syntax error

Create index syntax error

From
"Chris Velevitch"
Date:
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

Re: Create index syntax error

From
Chris
Date:
> ERROR:  syntax error at or near "index"
> LINE 1: EXPLAIN create index job_approver1_idx on jobs (approver1_id)

You can't explain creating an index.

--
Postgresql & php tutorials
http://www.designmagick.com/

Re: Create index syntax error

From
Tom Lane
Date:
"Chris Velevitch" <chris.velevitch@gmail.com> writes:
> I'm using 7.4 and pgAdmin 1.8 and I don't see why this simple command
> has a syntax error:-

> LINE 1: EXPLAIN create index job_approver1_idx on jobs (approver1_id)

CREATE INDEX isn't an explain-able operation, because it doesn't
have a plan.

            regards, tom lane