Skip to content

AZ114: A quote that goes on to the next line ​

A string, a quoted name or a dollar quote in a condition ends on the line it starts on. The condition's text goes into the generated SQL, in its comments too, where a line break would end the comment. Write the text on one line, and a line break in a string as E'\n': 'one' || E'\n' || 'two'. A named test's statements (given {...}, as user 3 allowed {...}) may hold quotes over several lines: they are run as written.

Reported when the policy is compiled: rowstile check, the editor, rowstile dev.

The mistake ​

authz
app role app_user
type user = app.users
type folder = app.folders
  owner : user = owner_id
  can view = owner and {name <> 'one
    two'}
line 5: a quote in {...} goes on to the next line: write it on one line, a line break in a string as E'\n' ('a' || E'\n' || 'b') [AZ114]

Fixed ​

authz
app role app_user
type user = app.users
type folder = app.folders
  owner : user = owner_id
  can view = owner and {name <> 'one' || E'\n' || 'two'}