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:
It seems like a Xata permission issue. But I'm not sure if the error is on drizzle's side.
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'
}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.