revskill
revskill
PostsComments
DTDrizzle Team
Created by revskill on 5/3/2024 in #help
Problem with AT TIME ZONE
When running drizzle-kit studio, I got error with following generated schema file (from supabase): 
createdAt: timestamp("created_at", { mode: 'string' }).default((now() AT TIME ZONE 'utc'::text)),
createdAt: timestamp("created_at", { mode: 'string' }).default((now() AT TIME ZONE 'utc'::text)),
errors: [
    {
      detail: undefined,
      id: '',
      location: {
        column: 71,
        file: '/Users/app/repository/drizzle/schema.ts',
        length: 2,
        line: 35,
        lineText: `\tcreatedAt: timestamp("created_at", { mode: 'string' }).default((now() AT TIME ZONE 'utc'::text)),`,
        namespace: '',
        suggestion: ')'
      },
      notes: [],
      pluginName: '',
      text: 'Expected ")" but found "AT"'
    }
  ],
  warnings: []
errors: [
    {
      detail: undefined,
      id: '',
      location: {
        column: 71,
        file: '/Users/app/repository/drizzle/schema.ts',
        length: 2,
        line: 35,
        lineText: `\tcreatedAt: timestamp("created_at", { mode: 'string' }).default((now() AT TIME ZONE 'utc'::text)),`,
        namespace: '',
        suggestion: ')'
      },
      notes: [],
      pluginName: '',
      text: 'Expected ")" but found "AT"'
    }
  ],
  warnings: []
11 replies