public inbox for [email protected]  

help / color / mirror / Atom feed

From: mrudula attili <[email protected]>
To: [email protected]
Subject: Can't create a table with vector type as a non-super user
Date: Tue, 30 Sep 2025 14:35:06 +0100
Message-ID: <CACmLaviY60Vx64hcacS687kBA3tXRfcYzrSJb6XaHU4X5qOrmQ@mail.gmail.com> (raw)

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 getting the below error.

CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3))
[2025-09-30 09:22:29] [42704] ERROR: type "vector" does not exist
[2025-09-30 09:22:29] Position: 57

Actions taken:

   1. Granted usage of type vector to user


   - No luck


   2. Granted usage on schema public to user


   - Worked

Concern:
As its a production environment, we are not really happy to give away the
usage on public schema.

Is there a way we could get the end users make use of the extension without
granting usage on public schema


Thanks,
SA

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Can't create a table with vector type as a non-super user
  In-Reply-To: <CACmLaviY60Vx64hcacS687kBA3tXRfcYzrSJb6XaHU4X5qOrmQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox