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 >
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