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