[pgadmin-hackers] pgAdmin III commit: Fix CREATE INDEX/CONSTRAINT syntax

2010-10-06 Thread Guillaume Lelarge
Fix CREATE INDEX/CONSTRAINT syntax Reverse the order of TABLESPACE and WITH() clauses for indexes. Previously pgAdminIII generated CREATE scripts like: CREATE INDEX foo_foo_id ON foo USING btree (foo_id) TABLESPACE bar WITH (FILLFACTOR=50); However this is illegal PostgreSQL syntax, the WITH(

[pgadmin-hackers] pgAdmin III commit: Fix CREATE INDEX/CONSTRAINT syntax when tablespace

2010-10-06 Thread Guillaume Lelarge
Fix CREATE INDEX/CONSTRAINT syntax when tablespace and fillfactor are specified Reverse the order of TABLESPACE and WITH() clauses for indexes. Previously pgAdminIII generated CREATE scripts like: ALTER TABLE foo ADD CONSTRAINT foo_pkey PRIMARY KEY(foo_id) USING INDEX TABLESPACE bar WITH (FILL