Subject: Re: pgAdmin3: check_option translated in View
 editing dialog
To: Dave Page <dpage@pgadmin.org>, Neel Patel <neel.patel@enterprisedb.com>
References: <567AA0E4.2030101@math.uni-goettingen.de>
 <CA+OCxoxCpLJYirHqRN15QVKNtULP2Nmvq4tudtoKKuLCvH7xHw@mail.gmail.com>
 <CACCA4P34muwjnknJ_fDmpNazYwsTq-9yzuucCXD-3C1Wr1ZgbA@mail.gmail.com>
 <CACCA4P3farSX1vsySWzBwJAJcoJbp97uz1pYNG=5iR_MBCtSPw@mail.gmail.com>
 <CA+OCxowpMOSnTqu8d+my1doAVyGSHC1cz1nrh2Yv5aSOthqggQ@mail.gmail.com>
CC: pgadmin-hackers <pgadmin-hackers@postgresql.org>
From: Sebastian Albert <albert@math.uni-goettingen.de>
Message-ID: <567BDDEC.2070102@math.uni-goettingen.de>
Date: Thu, 24 Dec 2015 12:58:36 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
In-Reply-To: 
 <CA+OCxowpMOSnTqu8d+my1doAVyGSHC1cz1nrh2Yv5aSOthqggQ@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Hi Neel

Thanks for looking into it. Dave is right, it's about the SQL
statement not working (because of translation appearing for a sort of
keyword) *unless* edited manually. You should not *have to* edit the
SQL manually, but due to the issue, you do, no matter what property of
the view you are trying to change.

So, to reproduce:
1. Create a view
2. Set language of pgAdmin to German
3. Try to change anything on the view, e.g., try to rename it, using
the properties dialog.

Unless I edit the SQL statement, I am presented an SQL error, which
comes from the check_option setting being translated.

Happy holidays
Sebastian

On 24.12.2015 12:20, Dave Page wrote:
> On Thu, Dec 24, 2015 at 11:18 AM, Neel Patel 
> <neel.patel@enterprisedb.com> wrote:
>> 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 ?
> 
> Hi Neel,
> 
> I believe the issue is that "no" is being translated to "nein" in 
> the SQL:
> 
> ALTER VIEW myview SET (check_option=nein);
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJWe93qAAoJEKZN7hpT3kUKTrgP/1wmrrScAtfvNc269K9+t1sa
UKyBfyMFvSgcMgydLC6bjsV5ECN2EVeV/qtNy6tGIlpWppzTtXccQxbKvQiwkyT1
F3MHM6tp869kegB0N2ZU5mzE+8ko/PaFRAISQomSlpxpDsATZ+5nR3VnFnh5DMde
4XYbPvdZWH4Kos9yrWDKTxi5FVHbCvj4m86Qxg8hMlOGUixRDlVx77t1dccchEjq
OJRenlQWO9x65iRQbobXJtJddyQLplulc7enBgSJapQahQ4QTqe4RTx7f4Qya2B8
9bIndvgIvbI08cnss7BQ8iJvK737gMoHc9CscwEAwadaI69/2QAlB4wtwS5bwIZp
DIeW+ulNJC40ZX6Ol/QMNZEvm1pBdwncLAUJBaiHht6M9rJcXld99uEPJDfP5wji
2M9WAa3fjyLJFV3d1lA2GYujPgUBAr7KCRcAxgQSXopCj8KICYJzCOkP5skHIPlL
zYEMDML3uATmMPbabhy65/mf44WgzjebnQwM86iwnPRbWzfzSrWyK26fm+9CZ6aF
kgZvS9bWtQDViS/+6vTMuR3YQK4H+iU88RCIDbrHa8Kn53S8ryglg1f2CKtqrV9z
2bNlK+iCNFxHoz1ApDw0CE8cJTKU31fL/B17+gB/bL6cCtnpzyCjNosRtO7vr89b
7N9Y5AOnyVwbQD42/3EN
=KwP3
-----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