pgAdmin III commit: Fix CREATE INDEX/CONSTRAINT syntax when tablespace

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема pgAdmin III commit: Fix CREATE INDEX/CONSTRAINT syntax when tablespace
Дата
Msg-id 201010061914.o96JEcZl084144@gothos.postgresql.org
обсуждение исходный текст
Список pgadmin-hackers
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 (FILLFACTOR=50);
CREATE INDEX foo_foo_id ON foo USING btree (foo_id)
  TABLESPACE bar WITH (FILLFACTOR=50);

However these are illegal PostgreSQL syntax, the WITH() clause must come before
TABLESPACE.

The statements generated by "new index" or "new primary key" dialogs are
already correct.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=79835bfa6b57b4a3b64ba1377f79f51cf35ec2f2
Author: Marti Raudsepp <marti@juffo.org>

Modified Files
--------------
pgadmin/schema/pgIndex.cpp           |    6 +++---
pgadmin/schema/pgIndexConstraint.cpp |    6 +++---
2 files changed, 6 insertions(+), 6 deletions(-)


В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: pgAdmin website commit: Update website french translation.
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: [PATCH] Fix CREATE INDEX/CONSTRAINT syntax when tablespace and fillfactor are specified