Booboo v(=∩_∩=)ﾌ Comments

· You're about to add item_market_id_unique unique constraint to the table, which contains 72 items. If this statement fails, you will receive an error from the database. Do you want to truncate item table?

Then I press yes, I have already tried no and it does not work. Now when I proceed I get this:

 Warning  Found data-loss statements:
· You're about to change id column type from serial to uuid with 2 items
· You're about to add not-null namespaced_id column without default value, which contains 72 items
· You're about to delete id column in item table with 72 items

THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED       

Do you still want to push changes?
error: column "id" cannot be cast automatically to type uuid
    at C:\Coding\Wimer\my-app\node_modules\drizzle-kit\bin.cjs:24462:21
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async PgPostgres.query (C:\Coding\Wimer\my-app\node_modules\drizzle-kit\bin.cjs:25423:21)
    at async Command.<anonymous> (C:\Coding\Wimer\my-app\node_modules\drizzle-kit\bin.cjs:63261:9) {
  length: 169,
  severity: 'ERROR',
  code: '42804',
  detail: undefined,
  hint: 'You might need to specify "USING id::uuid".',        
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'tablecmds.c',
  line: '12336',
  routine: 'ATPrepAlterColumnType'
}

9 replies

Gaming

Programming