Skip site navigation (1) Skip section navigation (2)

wrong sql code for fk covering index

From: Timon <timosha(at)gmail(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: wrong sql code for fk covering index
Date: 2011-06-16 15:22:01
Message-ID: BANLkTinG7Xe9vctRy6ZJfPSWt_bfMY8H0g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2011-06-16 16:08:59
Subject: pgAdmin III commit: make style
Previous:From: Dave PageDate: 2011-06-16 14:54:42
Subject: pgAdmin III commit: Only enable the fill factor text box when

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group