Re: Create index syntax error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Create index syntax error
Date: 2007-11-29 05:57:06
Message-ID: 2879.1196315826@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Velevitch 2007-11-29 06:08:41 Why upgrade?
Previous Message Andrew Dunstan 2007-11-29 05:39:30 Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?