Re: pgAdmin bug - SQL creation for foreign keys

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>