Code Inspections in PostgreSQL
This topic lists all JetBrains Rider code inspections available in PostgreSQL.
You can toggle specific inspections or change their severity level on the Editor | Inspection Settings | Inspection Severity | Other Languages settings page Ctrl+Alt+S.
Inspection | Description | Default Severity |
---|---|---|
Postgres: Select from procedure call | Reports situations when you make SELECT from a function or a DBLINK without an alias with a type (for example, This requirement does not apply to scalar functions. Example (PostgreSQL): CREATE FUNCTION produce_a_table() RETURNS RECORD AS $$
SELECT 1;
$$ LANGUAGE sql;
SELECT * FROM produce_a_table() AS s (c1 INT);
SELECT * FROM produce_a_table() AS s (c1);
SELECT * FROM DBLINK('dbname=mydb', 'SELECT proname, prosrc FROM pg_proc') AS t1; The |
Last modified: 11 February 2024