Postgres Pro
Downloads
Home   >   mailing lists

Re: pgAdmin bug - SQL creation for foreign keys - Mailing list pgadmin-hackers

From Dinesh Kumar
Subject Re: pgAdmin bug - SQL creation for foreign keys
Date
Msg-id CAKWsr7iYfsiRw3=Ya+RejBDAGCqa2_XsXxcbyV4vNJAQLogD4w@mail.gmail.com
Whole thread Raw
In response to Re: pgAdmin bug - SQL creation for foreign keys  (Dave Page <dpage@pgadmin.org>)
Responses Re: pgAdmin bug - SQL creation for foreign keys  (Dinesh Kumar <dinesh.kumar@enterprisedb.com>)
List pgadmin-hackers
Tree view

On Thu, Jul 11, 2013 at 4:55 PM, Dave Page <dpage@pgadmin.org> wrote:
Dinesh, can you investigate this please?


Sure Dave.

 
On Thu, Jul 11, 2013 at 11:42 AM, Jakub Trmota <jakub@trmota.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers


Thanks.

Dinesh

-- 
Dinesh Kumar
Software Engineer

Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter
@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more

 

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAdmin bug - SQL creation for foreign keys
Next
From: Akshay Joshi
Date:
Subject: Added "SSH Host key verification" logic in SSH Tunneling code