From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Jakub Trmota <jakub(at)trmota(dot)cz>, Dinesh Kumar <dinesh(dot)kumar(at)enterprisedb(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: pgAdmin bug - SQL creation for foreign keys |
Date: | 2013-07-11 11:25:56 |
Message-ID: | CA+OCxow=a2ekh=6+HittX5R6jeGRs_Ob1R93SmvpYDKTSkFoow@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Dinesh, can you investigate this please?
On Thu, Jul 11, 2013 at 11:42 AM, Jakub Trmota <jakub(at)trmota(dot)cz> wrote:
> 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;
>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Dinesh Kumar | 2013-07-11 11:29:49 | Re: pgAdmin bug - SQL creation for foreign keys |
Previous Message | Forrest79 Temp | 2013-07-11 10:44:01 | pgAdmin bug - SQL creation for foreign keys |