Unexpected identifier 'TABLE'

I used

drizzle-kit generate:pg

drizzle-kit generate:pg

drizzle-kit generate:pg

drizzle-kit generate:pg to generate this schema

CREATE TABLE IF NOT EXISTS users (
    user_id INT PRIMARY KEY,
    username VARCHAR(255),
    email VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS users (
    user_id INT PRIMARY KEY,
    username VARCHAR(255),
    email VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS users (
    user_id INT PRIMARY KEY,
    username VARCHAR(255),
    email VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS users (
    user_id INT PRIMARY KEY,
    username VARCHAR(255),
    email VARCHAR(255)
);

I tried to use

 drizzle-kit push:pg

drizzle-kit push:pg

 drizzle-kit push:pg

drizzle-kit push:pg
but I get this error

CREATE TABLE IF NOT EXISTS "users" (
       ^^^^^

SyntaxError: Unexpected identifier 'TABLE'

CREATE TABLE IF NOT EXISTS "users" (
       ^^^^^

SyntaxError: Unexpected identifier 'TABLE'

CREATE TABLE IF NOT EXISTS "users" (
       ^^^^^

SyntaxError: Unexpected identifier 'TABLE'

CREATE TABLE IF NOT EXISTS "users" (
       ^^^^^

SyntaxError: Unexpected identifier 'TABLE'

MAST•9/19/23, 3:36 AM

I'm pretty sure drizzle-kit pushdrizzle-kit push doesn't use the generated migrations.

It is similar to the prisma pushpush command that syncs the database with your corrent schema without using migrations.

MMAST I'm pretty sure `drizzle-kit push` doesn't use the generated migrations. It is ...

MajorAmariOP•9/19/23, 3:38 AM

That's what I'm trying to do but I get this error

MMajorAmari That's what I'm trying to do but I get this error

MAST•9/19/23, 3:40 AM

Hmm, why is drizzle-kit push looking at the migration files.

This is weird, I really don't know what's going on here.

MAST•9/19/23, 3:41 AM

Have you tried running it with node to see if it's a bun problem?

MajorAmariOP•9/19/23, 3:41 AM

I tried npx

MAST•9/19/23, 3:42 AM

OK, then

Might be a drizzle-kit bug then.

MajorAmariOP•9/19/23, 3:42 AM

I felt so

Unexpected identifier 'TABLE'

Similar Threads

Similar Threads

Similar Threads