one also needs CREATE and USAGE
privileges of the schema.
Perhaps to add a statement: "If a statement causes internally the creation of
another database object (index, sequence generator), then you must also have
CREATE and USAGE privilege of the schema that contains the tabl
st regards
Erki Eessaar
of your documents the column has to be kept up to date with its
source data. It is possible to create a trigger to update the tsvector column
when the document content columns change. Two built-in trigger functions are
available for this, or you can write your own."
Best regards
Erki Eessaar
-2023) it is
also said that T801 is supported.
Perhaps there are some technical details that I am not aware of. However, I
wanted to point this out.
Best regards
Erki Eessaar
and is not needed.
Best regards
Erki Eessaar
From: Bruce Momjian
Sent: Friday, October 7, 2022 4:35 PM
To: Erki Eessaar
Cc: pgsql-docs@lists.postgresql.org ; Noah
Misch ; Peter Eisentraut
Subject: Re: SQL-standard function bodies and creating SECURITY DEFINER
bodies should also override search_path.
Best regards
Erki Eessaar
*
/*Table in the schema public.*/
CREATE TABLE public.A(a INTEGER PRIMARY KEY);
/*Table in the schema pg_temp.*/
CREATE TABLE pg_temp.A(a INTEGER PRIMARY KEY);
/*SECURITY DEFINER function without SQL-standard
th_path_newer();
Result: 2
SELECT f_find_t_count_without_path_newer();
Result: 2
/*In both cases table T in the schema public was used to return the result.*/
Best regards
Erki Eessaar
