"Chris Velevitch" <[EMAIL PROTECTED]> 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.
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/
---(end of broadcast)---
TIP 2: Don't
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
