"Chris Velevitch" <chris.velevitch@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly