Postgres Pro
Downloads
Home   >   mailing lists

Re: wrong sql code for fk covering index - Mailing list pgadmin-hackers

From Jasmin Dizdarevic
Subject Re: wrong sql code for fk covering index
Date
Msg-id BANLkTi=UfoPk11hGnz2Nk7dYsG70MmTM8g@mail.gmail.com
Whole thread Raw
In response to wrong sql code for fk covering index  (Timon <timosha@gmail.com>)
Responses Re: wrong sql code for fk covering index  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-hackers
Tree view
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

Attachment

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: pgAdmin III commit: make style
Next
From: Jasmin Dizdarevic
Date:
Subject: Fwd: Foreign Table without options