DT
Drizzle Team•17mo ago
Fabian B.

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 [email protected], [email protected], [email protected]
8 Replies
Fabian B.
Fabian B.OP•17mo ago
Ah and I am connected to a supabase postgres instance, using the pg bouncer connection string
rphlmr âš¡
rphlmr ⚡•17mo ago
Hello, As for now, there is no way to hide these messages (they come from the driver)
Angelelz
Angelelz•17mo 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 âš¡
rphlmr ⚡•17mo ago
Ah thanks!
Fabian B.
Fabian B.OP•17mo ago
@angelelz Thanks! Haven't seen that one.
codyr
codyr•16mo ago
Hi @madebyfabian how to fixed ?
Fabian B.
Fabian B.OP•16mo ago
@productdevbook hi, check the answer from @angelelz Not a fix but at least silences it
codyr
codyr•16mo 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.

Did you find this page helpful?