Hi Sebastian, Thank you for the information. Issue is reproduced with the given steps. I will submit the patch after the fix.
Thanks, Neel Patel On Thu, Dec 24, 2015 at 5:28 PM, Sebastian Albert < alb...@math.uni-goettingen.de> wrote: > -----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.pa...@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----- >
