Обсуждение: wrong sql code for fk covering index

Поиск
Список
Период
Сортировка

wrong sql code for fk covering index

От
Timon
Дата:
When trying to create covering index for existing fk constrain by
checking checkbox in dialog, pgadmin 1.14 (latest git) generates wrong
code for postgresql 9.0.

ALTER TABLE hotels VALIDATE CONSTRAINT hotels_city_id_fkey;
CREATE INDEX fki_hotels_cityid ON hotels(city_id);

postgresql 9.0 doesn't know about VALIDATE keyword.
--
All bugs reserved

Re: wrong sql code for fk covering index

От
Jasmin Dizdarevic
Дата:
Hi, 

this patch should fix that.

regards,
Jasmin

2011/6/16 Timon <timosha@gmail.com>
When trying to create covering index for existing fk constrain by
checking checkbox in dialog, pgadmin 1.14 (latest git) generates wrong
code for postgresql 9.0.

ALTER TABLE hotels VALIDATE CONSTRAINT hotels_city_id_fkey;
CREATE INDEX fki_hotels_cityid ON hotels(city_id);

postgresql 9.0 doesn't know about VALIDATE keyword.
--
All bugs reserved

--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Вложения

Re: wrong sql code for fk covering index

От
Guillaume Lelarge
Дата:
On Thu, 2011-06-16 at 18:45 +0200, Jasmin Dizdarevic wrote:
> [...]
> this patch should fix that.
>

Thanks, patch applied.


--
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com