3

We have added arguments to pg_stat_statements_reset during postgresql 12 developing cycle (in fact, in version 1.7 of the extension itself). These new arguments have default values, but anyway foo() and foo(param int DEFAULT 0) are different functions from postgresql point of view. You need replace this GRANT to grant all on FUNCTION pg_stat_statements_reset(...


2

You can create a domain based on your type. create domain checked_dimensions as dimensions constraint check_size check ( (value).w <= 10 ); Note the parentheses around the keyword value. They look redundant but are required in this case. Then use the type checked_dimensions as your column type


1

The locale parameter of CREATE DATABASE expects a name of locale that can be recognized and used by the setlocale POSIX function of the underlying operating system, or whatever is the equivalent if the OS is Windows. On the other hand, the names of collations that are user-defined by CREATE COLLATION and whose scope is only the current database do not have ...


1

You could use a function in your policy that has the side effect of logging data. But that is not reliable, because it might well be that the RLS condition is applied before some other query condition, so that you'd get false positives that wouldn't have become part of the result set anyway. I don't think that there is a way to do what you want. That is not ...


Only top voted, non community-wiki answers of a minimum length are eligible