Re: [pgadmin-hackers] wrong sql code for fk covering index

2011-06-16 Thread 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 -- Sent via pgadmin-hackers mailing list ([email protected]) To make changes to y

Re: [pgadmin-hackers] wrong sql code for fk covering index

2011-06-16 Thread Jasmin Dizdarevic
Hi, this patch should fix that. regards, Jasmin 2011/6/16 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

[pgadmin-hackers] wrong sql code for fk covering index

2011-06-16 Thread 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 k