Drizzle Team•13mo ago

on every `migrate()`: schema "drizzle" already exists, skipping

Hi there! I have setuped a postgres DB. Everytime I call migrate(), it works and migrates, but returns these two warnings:

{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P06',
  message: 'schema "drizzle" already exists, skipping',
  file: 'schemacmds.c',
  line: '128',
  routine: 'CreateSchemaCommand'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P07',
  message: 'relation "__drizzle_migrations" already exists, skipping',
  file: 'parse_utilcmd.c',
  line: '209',
  routine: 'transformCreateStmt'
}

{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P06',
  message: 'schema "drizzle" already exists, skipping',
  file: 'schemacmds.c',
  line: '128',
  routine: 'CreateSchemaCommand'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P07',
  message: 'relation "__drizzle_migrations" already exists, skipping',
  file: 'parse_utilcmd.c',
  line: '209',
  routine: 'transformCreateStmt'
}

Does anyone have an idea on why this happens and how I can stop it from happening? Clogs up my console 😄 Thanks! -- I am using postgres-js@3.3.5, drizzle-orm@0.28.5, drizzle-kit@0.19.13

8 Replies

Fabian B.•13mo ago

Ah and I am connected to a supabase postgres instance, using the pg bouncer connection string

rphlmr ⚡•13mo ago

Hello, As for now, there is no way to hide these messages (they come from the driver)

Angelelz•13mo ago

I saw somebody was able to disable those https://discord.com/channels/1043890932593987624/1144213507424923800/1144254661512155176 He passed an empty function to onnotice field in the config object of the pg connection.

rphlmr ⚡•13mo ago

Ah thanks!

Fabian B.•13mo ago

@angelelz Thanks! Haven't seen that one.

productdevbook•12mo ago

Hi @madebyfabian how to fixed ?

Fabian B.•12mo ago

@productdevbook hi, check the answer from @angelelz Not a fix but at least silences it

productdevbook•12mo ago

thank you, It seems better to open this. It didn't create a table for me, so I deleted Docker and installed it again and it created it.

Gaming

Programming

on every `migrate()`: schema "drizzle" already exists, skipping