pgAdmin bug - SQL creation for foreign keys

From: Jakub Trmota <jakub(at)trmota(dot)cz>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin bug - SQL creation for foreign keys
Date: 2013-07-11 10:42:48
Message-ID: 51DE8C28.7040505@trmota.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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 buggy SQL 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;

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Forrest79 Temp 2013-07-11 10:44:01 pgAdmin bug - SQL creation for foreign keys
Previous Message Dinesh Kumar 2013-07-10 16:16:20 Re: pgAdmin Event Trigger Compatibility