Postgres Pro
Downloads
Home   >   mailing lists

Re: Create index syntax error - Mailing list pgsql-general

From Tom Lane
Subject Re: Create index syntax error
Date
Msg-id 2879.1196315826@sss.pgh.pa.us
Whole thread Raw
In response to Create index syntax error  ("Chris Velevitch" <chris.velevitch@gmail.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Create index syntax error
Next
From: "Chris Velevitch"
Date:
Subject: Why upgrade?