[BUG]: introspect:pg column not using generated enum name

[cosileone]

What version of drizzle-orm are you using?

0.29.1

What version of drizzle-kit are you using?

0.20.6

Describe the Bug

running drizzle-kit introspect:pg on my pg database generates schema file but with incorrect column type.

export const timeLeft = pgEnum("TimeLeft", ['VERY_LONG', 'SHORT', 'MEDIUM', 'LONG'])

export const auction = pgTable("Auction", {
	id: serial("id").primaryKey().notNull(),
	bid: integer("bid").notNull(),
	buyout: integer("buyout").notNull(),
	quantity: integer("quantity").notNull(),

	timeLeft: time("timeLeft").notNull(), // <------- NOTICE usage of nonexistent "time" definition, I think it should be "timeLeft"?

	itemId: integer("itemId").notNull().references(() => item.id, { onDelete: "cascade", onUpdate: "cascade" } ),
	createdAt: timestamp("createdAt", { precision: 3, mode: 'string' }).defaultNow().notNull(),
	updatedAt: timestamp("updatedAt", { precision: 3, mode: 'string' }).notNull(),
},
(table) => {
	return {  /* ... */ }
});

Expected behavior

export const timeLeft = pgEnum("TimeLeft", ['VERY_LONG', 'SHORT', 'MEDIUM', 'LONG'])

export const auction = pgTable("Auction", {
	id: serial("id").primaryKey().notNull(),
	bid: integer("bid").notNull(),
	buyout: integer("buyout").notNull(),
	quantity: integer("quantity").notNull(),

	timeLeft: timeLeft("timeLeft").notNull(), // <------- correct type now

	itemId: integer("itemId").notNull().references(() => item.id, { onDelete: "cascade", onUpdate: "cascade" } ),
	createdAt: timestamp("createdAt", { precision: 3, mode: 'string' }).defaultNow().notNull(),
	updatedAt: timestamp("updatedAt", { precision: 3, mode: 'string' }).notNull(),
},
(table) => {
	return {  /* ... */ }
});

Environment & setup

macos, node 18.18.2, typescript 5.3.2, AWS RDS PostgresQL micro.t3 instance

[Angelelz]

What is timeLeft type?
The introspect command just used the pg time data type. I don't think there is a timeLeft data time in postgres

[cosileone]

What is timeLeft type? The introspect command just used the pg time data type. I don't think there is a timeLeft data time in postgres

Ah you will notice timeLeft is an enum defined on the very first line of the code snippet above! Generated from an enum defined on my database called TimeLeft. It's values are ['VERY_LONG', 'SHORT', 'MEDIUM', 'LONG']

The problem is that introspect is generating the enum, but not connecting it to the column that is using it

[nikhiljay]

Any update on this? Running into the same issue where a couple enums are being introspected as time instead

[AndriiSherman]

This should be fixed in drizzle-kit@0.24.1
If you still encounter this issue, please reopen the ticket