Обсуждение: pgAdmin bug - SQL creation for foreign keys

Поиск
Список
Период
Сортировка

pgAdmin bug - SQL creation for foreign keys

От
Forrest79 Temp
Дата:
Hello,
I found bug in pgAdmin III 1.16.1 on Windows 7 (x64). When I use czech interface and want to add foreign key, this
buggySQL is generated: 

ALTER TABLE app_cache_journal
   ADD FOREIGN KEY (entry) REFERENCES acl_object_parents (object_id) ON UPDATE ochránit (RESTRICT) ON DELETE kaskádová
akce(CASCADE); 

Correct SQL is:

ALTER TABLE app_cache_journal
   ADD FOREIGN KEY (entry) REFERENCES acl_object_parents (object_id) ON UPDATE RESTRICT ON DELETE CASCADE;