Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aC3uo-0002RM-If for pgadmin-hackers@arkaria.postgresql.org; Thu, 24 Dec 2015 11:18:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aC3um-0007kC-UC for pgadmin-hackers@arkaria.postgresql.org; Thu, 24 Dec 2015 11:18:36 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aC3uY-0007Va-Kv for pgadmin-hackers@postgresql.org; Thu, 24 Dec 2015 11:18:22 +0000 Received: from mail-yk0-x22e.google.com ([2607:f8b0:4002:c07::22e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aC3uQ-00013j-P1 for pgadmin-hackers@postgresql.org; Thu, 24 Dec 2015 11:18:20 +0000 Received: by mail-yk0-x22e.google.com with SMTP id p130so220007357yka.1 for ; Thu, 24 Dec 2015 03:18:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=3UcgAze+AIl4x/qG3Ypc/dm94ojvF2yYYLdXIJwQgeU=; b=co3NdMooztg7cMzzp+bml5XF0TkDnhf0DAM8amwESUtyO/Z4lvPO+A2Fkz0tYMqV6r JuOTUr0fhxpyXkILV1oz61rYBhWw8qjotA5QAvY6SWgDSU9V4bHhViaEDrmbMsczoer/ FdaCs8l5o+pMjv8oy21XzTrtquwOgIKo9zYSgkI8Nx4ri0jT1HAbOhcqA1E/P9byZOiy 8Ts0tLnJbkMcFQuLYpJ3qCmNRDeIfz3M8jWQu3tysldDpxJUu9Jo7+5dMe5i/G/IrcZj TP5hChRYoRKS5Jol5eZH0eplFq0/xOz/RwCm6dsnOHqwwkeDxvRMrJs/+wbyrU6NTWez 2jIg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=3UcgAze+AIl4x/qG3Ypc/dm94ojvF2yYYLdXIJwQgeU=; b=JJExiTkmUzbSfM6uGwJ2Zcl1kiCvARyt4Vce+lwirtpksoO3e/V7qv/rlLqTEHs4g2 t5nxc/DCrtkqB7SXSMO8AnemMOhoKBQVRzuA3Lg5CIwqOUvdgK1A2Lz2JmiBrF1/OxEC Mc+KIxFbLDLky0ItFRahu2mzHFTJcpPXMQy1qzzRX2uN9aWekRY0std2VPTTTd12CT/H vFpOy3iRpranWmrywatVuMm39wXsGC7TkcfIMdqpIAl7JVdUXjFp6ikzs/ytxXL5dIam qLQTo8SlFeQKWsOEPgyJiGRToMwmPR8dTlQ1yJyaZ9i19jFle88xVTt620cma82aDs0n 1oNQ== X-Gm-Message-State: ALoCoQliVXjaUmkpkaM2pxnnnWgaBkY2GtJRtOPJCBc2mnGU/d/XTHnl9Dn7GNVWy9JydspAziAD4KRpkEGALbwnbP11VOr7LYqXp8Hfdsd/cEoX26GKmYk= MIME-Version: 1.0 X-Received: by 10.13.237.129 with SMTP id w123mr26665631ywe.319.1450955893307; Thu, 24 Dec 2015 03:18:13 -0800 (PST) Received: by 10.37.202.75 with HTTP; Thu, 24 Dec 2015 03:18:13 -0800 (PST) In-Reply-To: References: <567AA0E4.2030101@math.uni-goettingen.de> Date: Thu, 24 Dec 2015 16:48:13 +0530 Message-ID: Subject: Re: pgAdmin3: check_option translated in View editing dialog From: Neel Patel To: Dave Page Cc: Sebastian Albert , pgadmin-hackers Content-Type: multipart/alternative; boundary=94eb2c08851e9b2b0d0527a2fe45 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --94eb2c08851e9b2b0d0527a2fe45 Content-Type: text/plain; charset=UTF-8 Hi Sebastian, We have just tried to reproduce the issue but not able to understand the issue from the description. We followed below steps. 1. Change the language to German. 2. Open the existing View's properties and try to change "With check option". 3. Open SQL tab - According to change in option, we are able to see and edit the query. Let me know if anything missing in above steps or Can you please give steps to understand the issue ? Thanks, Neel Patel On Wed, Dec 23, 2015 at 7:09 PM, Neel Patel wrote: > Hi Dave, > > Sure. I will look into this issue. > > Thanks, > Neel Patel > > On Wed, Dec 23, 2015 at 7:04 PM, Dave Page wrote: > >> Neel, can you look into this please? >> >> Thanks. >> >> On Wed, Dec 23, 2015 at 1:25 PM, Sebastian Albert >> wrote: >> > -----BEGIN PGP SIGNED MESSAGE----- >> > Hash: SHA256 >> > >> > Dear pgAdmin-Hackers >> > >> > I observed the following minor issue in pgAdmin3 1.20.0 >> > For I did not find a bugtracker, I'm mailing it to the list. Please >> > point me to it if there is one. >> > >> > pgAdmin appears to me translated (into German) in part, probably due >> > to my locale. However, in the dialog for editing a VIEW's properties, >> > the generated SQL reads >> > >> > ALTER VIEW myview >> > SET (check_option=nein); >> > >> > with "Nein", "Lokal" and "Cascaded" offered in the corresponding >> > dropdown. I can manually edit these two lines away in the SQL tab of >> > the dialog, but it's probably not intended that way. >> > >> > - -- Sebastian >> > -----BEGIN PGP SIGNATURE----- >> > Version: GnuPG v2 >> > >> > iQIcBAEBCAAGBQJWeqDgAAoJEKZN7hpT3kUKC4gP/jCdUy64KlCmGbFH5vOapyCh >> > CcicKABS8EtuUpaFEgxPJCemtplSzS9oNzDKBtSKD1MxxoDN/Sjreuw7wYtzmO+/ >> > U/JIA4rGqP1FgVldXqDuaw4Hih76gRW3XOqTzv+kkqmt/G/0JrKlMDyY9QKPgHw9 >> > qB2o5Nf9E4QLWyTZkRJqiCuCARsYvHAUWafOINgPx3fpl2cTinSN7/mT8AaLCtXT >> > y09MmNvqGp1ILqYp81AsXblPUADdW5rLjcCxD70QIE7ejuej9EtmGYQWLGr8Bo1d >> > UnUUQNPuYjrfjInj15Odirmw+hUnfu1iIwjUUze6no4o9FwOmLYx0OKw2gw+QG1H >> > byL+JR3wb6H7sa5RgLeNvW90feP7XFsQsKPUREovVNX891ZxGkdNZEknhaL8TYyj >> > 8xCqoX9+yecixDA4U9wZIFfsD6b9cNBFRUjOHKLS1qnQ+zQgWQLlUxXAjLiLawgE >> > AbB9rf6N9HzLIhVlqd7u/HpNOamUgXrdwBAd7DNiyqqsVdxaOzEFT3bXpgv5UQA/ >> > F2eyQi35MCzoROcMoVKUT5kVKKo1UcMkymThWV4s78Lv2C7jM+8GX79gcIpGSps5 >> > mSJLXHLUH03SozfZeGh3DBsl6UyhRHM8GVghCZutHzj68ViM4MSKgPX8RU+wBUxs >> > 8ZpeXtC927azi9NJcNP6 >> > =yrr2 >> > -----END PGP SIGNATURE----- >> > >> > >> > -- >> > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.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 >> > > --94eb2c08851e9b2b0d0527a2fe45 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Sebastian,

We have just tried to rep= roduce the issue but not able to understand the issue from the description.=

We followed below steps.

=C2=A0 1. Change the language to German.
=C2=A0 2. Open the exis= ting View's properties and try to change "With check option".=
=C2=A0 3. Open SQL tab - According to change in option, we are a= ble to see and edit the query.

Let me know if anyt= hing missing in above steps or Can you please give steps to understand the = issue ?

Thanks,
Neel Patel

On Wed, Dec 23, 201= 5 at 7:09 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Dave,
Sure. I will look into this issue.

Thanks,
Neel Patel

On Wed, D= ec 23, 2015 at 7:04 PM, Dave Page <dpage@pgadmin.org> wrote:=
Neel, can you look into this please?

Thanks.

On Wed, Dec 23, 2015 at 1:25 PM, Sebastian Albert
<albe= rt@math.uni-goettingen.de> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Dear pgAdmin-Hackers
>
> I observed the following minor issue in pgAdmin3 1.20.0
> For I did not find a bugtracker, I'm mailing it to the list. Pleas= e
> point me to it if there is one.
>
> pgAdmin appears to me translated (into German) in part, probably due > to my locale. However, in the dialog for editing a VIEW's properti= es,
> the generated SQL reads
>
> ALTER VIEW myview
>=C2=A0 =C2=A0SET (check_option=3Dnein);
>
> with "Nein", "Lokal" and "Cascaded" offe= red in the corresponding
> dropdown. I can manually edit these two lines away in the SQL tab of > the dialog, but it's probably not intended that way.
>
> - -- Sebastian
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2
>
> iQIcBAEBCAAGBQJWeqDgAAoJEKZN7hpT3kUKC4gP/jCdUy64KlCmGbFH5vOapyCh
> CcicKABS8EtuUpaFEgxPJCemtplSzS9oNzDKBtSKD1MxxoDN/Sjreuw7wYtzmO+/
> U/JIA4rGqP1FgVldXqDuaw4Hih76gRW3XOqTzv+kkqmt/G/0JrKlMDyY9QKPgHw9
> qB2o5Nf9E4QLWyTZkRJqiCuCARsYvHAUWafOINgPx3fpl2cTinSN7/mT8AaLCtXT
> y09MmNvqGp1ILqYp81AsXblPUADdW5rLjcCxD70QIE7ejuej9EtmGYQWLGr8Bo1d
> UnUUQNPuYjrfjInj15Odirmw+hUnfu1iIwjUUze6no4o9FwOmLYx0OKw2gw+QG1H
> byL+JR3wb6H7sa5RgLeNvW90feP7XFsQsKPUREovVNX891ZxGkdNZEknhaL8TYyj
> 8xCqoX9+yecixDA4U9wZIFfsD6b9cNBFRUjOHKLS1qnQ+zQgWQLlUxXAjLiLawgE
> AbB9rf6N9HzLIhVlqd7u/HpNOamUgXrdwBAd7DNiyqqsVdxaOzEFT3bXpgv5UQA/
> F2eyQi35MCzoROcMoVKUT5kVKKo1UcMkymThWV4s78Lv2C7jM+8GX79gcIpGSps5
> mSJLXHLUH03SozfZeGh3DBsl6UyhRHM8GVghCZutHzj68ViM4MSKgPX8RU+wBUxs
> 8ZpeXtC927azi9NJcNP6
> =3Dyrr2
> -----END PGP SIGNATURE-----
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) > To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-ha= ckers



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--94eb2c08851e9b2b0d0527a2fe45--