Hello Team,
I have recently installed the pgvector extension on one of our production
databases.
Managed to create the extension as super user and create table with the
vector type.
But a non super user (a read write user of the database) is not able to
create a table with vector type and keeps
Hi.
With pg_has_role(), I can use USAGE for access right now, or MEMBER
for "possible" access after a SET ROLE. I.e. I can see GRANT
INHERIT'ance in action.
But with has_schema_privilege(..., 'USAGE'), I can only check the
"right now" case. But I'd like to be able to take "indirect USAGE"
into ac
On 9/28/25 13:46, Ray O'Donnell wrote:
Hi all,
As per $subject - is PG 18 not available for Ubuntu Noble (24.04)?
According to the below it is:
https://www.postgresql.org/download/linux/ubuntu/
My laptop runs Tuxedo OS which is based on Noble, and doing this -
apt search postgresql-1
