Is it possible to make circular references?

[mattiaz9]

Example: a category with a parent reference

export const category = pgTable(
  "Category",
  {
    id: uuid("id").primaryKey(),
    name: varchar("name"),
    parentCategoryId: uuid("parentCategoryId").references(() => category.id),
  }
)
// error: 'category' implicitly has type 'any' because it does not have a type annotation 
// and is referenced directly or indirectly in its own initializer.

Is it possible to do this without having to create a complex type annotation?

[dankochetov]

Yes, you can use the 3rd argument in pgTable:

export const category = pgTable(
	'Category',
	{
		id: uuid('id').primaryKey(),
		name: varchar('name'),
		parentCategoryId: uuid('parentCategoryId'),
	},
	(category) => ({
		selfRef: foreignKey({
			columns: [category.parentCategoryId],
			foreignColumns: [category.id],
		}),
	}),
);

[mattiaz9]

thank you @dankochetov, but how can I specify { onDelete: "cascade" }?

[mattiaz9]

never mind I just saw there is a .onDelete("cascade") method!