DT
Drizzle Team•4mo ago
Rajat

How to fix, issue while pushing the migration, drizzle is treating view as table and trying to drop

pgPush fails with “pg_stat_statements_info is not a table” error While applying the migration and pushing the migration using drizzle-kit push facing below issue, drizzle is trying to It looks like Drizzle is trying to drop pg_stat_statements_info as if it were a table, but it’s actually a view provided by the pg_stat_statements extension. I haven’t configured anything special in drizzle.config.ts, so I expected introspection to skip system views or at least use the proper DROP VIEW syntax. What I’ve tried so far - Manually disabling or ignoring system schemas/tables in drizzle.config.ts (no effect) - Tried by adding view in schema witht he existing() but no effect. - Confirming that the view exists by running \dv pg_stat_statements_info in psql Questions - Is there a recommended way to tell Drizzle to ignore Postgres system views (like anything in pg_catalog or provided by an extension)? - If not, is there a workaround so that drizzle-kit push uses DROP VIEW instead of DROP TABLE for views? - Would it make sense for Drizzle to automatically detect views vs. tables during introspection? Thanks in advance for any guidance! Happy to share more config or logs if helpful.
No description
10 Replies
veksen
veksen•3mo ago
I have this exact same issue, did you find a solution @Rajat ? in fact my issue is different as it tries to drop the view: 
error: cannot drop view pg_stat_statements because extension pg_stat_statements requires it
    at /app/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async Object.query (/app/node_modules/drizzle-kit/bin.cjs:78810:26)
    at async pgPush (/app/node_modules/drizzle-kit/bin.cjs:82397:13)
    at async Object.handler (/app/node_modules/drizzle-kit/bin.cjs:92657:9)
    at async run (/app/node_modules/drizzle-kit/bin.cjs:91903:7) {
  length: 205,
  severity: 'ERROR',
error: cannot drop view pg_stat_statements because extension pg_stat_statements requires it
    at /app/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async Object.query (/app/node_modules/drizzle-kit/bin.cjs:78810:26)
    at async pgPush (/app/node_modules/drizzle-kit/bin.cjs:82397:13)
    at async Object.handler (/app/node_modules/drizzle-kit/bin.cjs:92657:9)
    at async run (/app/node_modules/drizzle-kit/bin.cjs:91903:7) {
  length: 205,
  severity: 'ERROR',
Rajat
RajatOP•3mo ago
Yes did find the solution for this will drop in sometime.
veksen
veksen•3mo ago
my solution seems to be this: https://github.com/drizzle-team/drizzle-orm/discussions/2410#discussioncomment-10815100 
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: './src/lib/db/schema.ts',
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DATABASE_URL,
  },
  verbose: true,
  strict: true,
  out: './drizzle',
  tablesFilter: ['!pg_stat_statements', '!pg_stat_statements_info'],
});
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: './src/lib/db/schema.ts',
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DATABASE_URL,
  },
  verbose: true,
  strict: true,
  out: './drizzle',
  tablesFilter: ['!pg_stat_statements', '!pg_stat_statements_info'],
});
(the tablesFilter)
Rajat
RajatOP•3mo ago
Yes I tried this way also but it’s not supporting “!” annotation in tablesFilter.
Rajat
RajatOP•3mo ago
Rajat
RajatOP•3mo ago
@veksen ^^
veksen
veksen•3mo ago
Thank you! So you did the opposite, whitelisted, seems like the blacklist is a new feature? Because it worked for me
Rajat
RajatOP•3mo ago
Ah so the “!” Works for you, nice. Btw just to confirm do you using same version or different? And also i visited querydoctor tools seems interesting at first glance, will explore more on later.
veksen
veksen•3mo ago
I'm on 0.44.1 sure thing 😄 we are shipping a pretty big upgrade this week
Rajat
RajatOP•3mo ago
Thanks will give it a try Oh cool, will checkout on weekend

Did you find this page helpful?