Drizzle pull/push: Permission denied for view pg_stat_user_indexes

Hi 👋

Sorry to bother you again. Quick question: After a long while I'm using the drizzle commands again and now I'm receiving the following error:

XATA_BRANCH test-template2
Pulling from ['public'] list of schemas

Using 'pg' driver for database querying
[✓] 15  tables fetched
[⣻] 207 columns fetching
[✓] 0   enums fetched
[⣻] 0   indexes fetching
[⣻] 0   foreign keys fetching
[✓] 0   policies fetched
[⣻] 0   check constraints fetching
[⣻] 0   views fetching
error: permission denied for view pg_stat_user_indexes
    at /home/michael/repos/monorepo/node_modules/.pnpm/pg-pool@3.6.2_pg@8.11.5/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async Object.query (/home/michael/repos/monorepo/node_modules/.pnpm/drizzle-kit@0.30.1_drizzle-orm@0.38.3_@opentelemetry+api@1.9.0_@planetscale+database@1.7.0_@t_4xfdxdbonwo2l5u4y5cl47zhfu/node_modules/drizzle-kit/bin.cjs:78762:26)
    at async <anonymous> (/home/michael/repos/monorepo/node_modules/.pnpm/drizzle-kit@0.30.1_drizzle-orm@0.38.3_@opentelemetry+api@1.9.0_@planetscale+database@1.7.0_@t_4xfdxdbonwo2l5u4y5cl47zhfu/node_modules/drizzle-kit/bin.cjs:37743:43) {
  length: 107,
  severity: 'ERROR',
  code: '42501',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'aclchk.c',
  line: '3770',
  routine: 'aclcheck_error'
}


It seems like a Xata permission issue. But I'm not sure if the error is on drizzle's side.
Was this page helpful?