Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Create index syntax error
- From: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Create index syntax error
- Date: Thu, 29 Nov 2007 16:20:03 +1100
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)
^
********** Error **********
ERROR: syntax error at or near "index"
SQL state: 42601
Character: 16
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au
- Follow-Ups:
- Re: Create index syntax error
- From: Tom Lane
- Re: Create index syntax error
- From: Chris
- Re: Create index syntax error
- Prev by Date: Re: Error compiling Slony I
- Next by Date: Re: Btree indexes temp copy Was [Re: Cluster using tablespaces?]
- Previous by thread: Cluster using tablespaces?
- Next by thread: Re: Create index syntax error
- Indexes: