fix current_setting() default value ''::boolean error

HexaCluster / pg_dbms_metadata

PostgreSQL License

11 stars 2 forks source link

fix current_setting() default value ''::boolean error #3

Closed Villyli closed 6 months ago

Villyli commented 6 months ago

current_setting('SETTING_NAME', true) returns null when missing and can't convert into boolean, just try to fix it

Villyli commented 6 months ago

Besides, REVOKE ALL ON ... FROM PUBLIC; is required a high privilege user for PUBLIC is it considered designed optional and capture PUBLIC auth failure (as this is a tool funcs for normal user)