Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Create index syntax error



"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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group