Skip to content

fixed some string-literals

nice project!

fixes for those errors:

psql:parts/_initialize.sql:76: WARNING:  nonstandard use of escape in a string literal
LINE 14:         pg_catalog.pg_get_viewdef(c.oid, true) ~ 'FROM .*pg_...
                                                          ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:parts/_initialize.sql:76: WARNING:  nonstandard use of escape in a string literal
LINE 14:         pg_catalog.pg_get_viewdef(c.oid, true) ~ 'FROM .*pg_...
                                                          ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:parts/_initialize.sql:76: WARNING:  nonstandard use of escape in a string literal
LINE 7:         pg_catalog.pg_get_viewdef(c.oid, true) ~ 'FROM .*pg_...
                                                         ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
QUERY:  select min(n.nspname)                     from
        pg_catalog.pg_class c
        join pg_catalog.pg_namespace n on c.relnamespace = n.oid
    where
        c.relname = 'pg_stat_statements' and
        c.relkind = 'v' and
        pg_catalog.pg_get_viewdef(c.oid, true) ~ 'FROM .*pg_stat_statements\(.* pg_stat_statements\(' AND
        c.oid in (
            select a.attrelid
            from pg_catalog.pg_attribute a
            where
                a.attname in ('dbid', 'query', 'calls', 'total_time') and
                not a.attisdropped
            group by a.attrelid
            having count(distinct a.attname) = 4
        )
psql:parts/_initialize.sql:76: ERROR:  invalid regular expression: parentheses () not balanced
CONTEXT:  SQL statement "select min(n.nspname)                     from
        pg_catalog.pg_class c
        join pg_catalog.pg_namespace n on c.relnamespace = n.oid
    where
        c.relname = 'pg_stat_statements' and
        c.relkind = 'v' and
        pg_catalog.pg_get_viewdef(c.oid, true) ~ 'FROM .*pg_stat_statements\(.* pg_stat_statements\(' AND
        c.oid in (
            select a.attrelid
            from pg_catalog.pg_attribute a
            where
                a.attname in ('dbid', 'query', 'calls', 'total_time') and
                not a.attisdropped
            group by a.attrelid
            having count(distinct a.attname) = 4
        )"
PL/pgSQL function inline_code_block line 7 at SQL statement
psql:parts/sqlascii.sql:8: ERROR:  current transaction is aborted, commands ignored until end of transaction block
Edited by easteregg

Merge request reports