Column primary key not working

What am I doing wrong when defining my primary key here? column:

const customPrimaryKey = customType<{
  data: number;
  notNull: true;
  default: true;
}>({
  dataType() {
    return `id bigint generated always as identity primary key`;
  },
});

const customPrimaryKey = customType<{
  data: number;
  notNull: true;
  default: true;
}>({
  dataType() {
    return `id bigint generated always as identity primary key`;
  },
});

Generated SQL:

CREATE TABLE IF NOT EXISTS "users" (
    "id" "bigint generated always as identity primary key",

CREATE TABLE IF NOT EXISTS "users" (
    "id" "bigint generated always as identity primary key",

Error:

error: type "bigint generated always as identity primary key" does not exist

error: type "bigint generated always as identity primary key" does not exist

1 Reply

XafetsOP•16mo ago

Bump

Gaming

Programming

Column primary key not working