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