Re: pgAdmin bug - SQL creation for foreign keys

Hi Dave,

I am able to re-produce the reported issue and with the create new role
dialogue box. Please find the attached patch for these reported cases.

Thanks in advance.

Dinesh

--
*Dinesh Kumar*
Software Engineer

Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
*
Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community> and
more <http://www.enterprisedb.com/resources-community>

On Thu, Jul 11, 2013 at 4:59 PM, Dinesh Kumar <dinesh(dot)kumar(at)enterprisedb(dot)com
> wrote:

>
> On Thu, Jul 11, 2013 at 4:55 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> Dinesh, can you investigate this please?
>>
>>
> Sure Dave.
>
>
>
>> 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
>>
>>
> Thanks.
>
> Dinesh
>
> --
> *Dinesh Kumar*
> Software Engineer
>
> Ph: +918087463317
> Skype ID: dinesh.kumar432
> www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
> *
> Follow us on Twitter*
> @EnterpriseDB
>
> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and
> more <http://www.enterprisedb.com/resources-community>
>
>
>