Hi,

this patch should fix that.

regards,
Jasmin

2011/6/16 Timon <timo...@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
>

Attachment: 0001-Fix-validate-constraint-with-PostgreSQL-9.1-when-cre.patch
Description: Binary data

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

Reply via email to