6 replies

[postgres] composite key does not result in constraint creation

i have this schema, and even though I've got a pretty basic composite primary key, whenever i go into a visual view of my db, no constraint is actually created. with other tables with single column pk's, it creates the constraint like

${tableName}_pkey

${tableName}_pkey

, but in this case when i look on Neon there's no constraint here

export const preferenceTable = createTable(
  'preference',
  {
    userId: uuidv7('group_id').notNull(),
    defaultGroupId: uuidv7('default_group_id'),
  },
  ({ userId, defaultGroupId }) => [
    {
      pk: primaryKey({ columns: [userId, defaultGroupId] }),
    },
  ],
);

export const preferenceTable = createTable(
  'preference',
  {
    userId: uuidv7('group_id').notNull(),
    defaultGroupId: uuidv7('default_group_id'),
  },
  ({ userId, defaultGroupId }) => [
    {
      pk: primaryKey({ columns: [userId, defaultGroupId] }),
    },
  ],
);

Drizzle Team•16mo ago•

6 replies

jack

[postgres] composite key does not result in constraint creation

${tableName}_pkey

${tableName}_pkey

, but in this case when i look on Neon there's no constraint here

export const preferenceTable = createTable(
  'preference',
  {
    userId: uuidv7('group_id').notNull(),
    defaultGroupId: uuidv7('default_group_id'),
  },
  ({ userId, defaultGroupId }) => [
    {
      pk: primaryKey({ columns: [userId, defaultGroupId] }),
    },
  ],
);

export const preferenceTable = createTable(
  'preference',
  {
    userId: uuidv7('group_id').notNull(),
    defaultGroupId: uuidv7('default_group_id'),
  },
  ({ userId, defaultGroupId }) => [
    {
      pk: primaryKey({ columns: [userId, defaultGroupId] }),
    },
  ],
);

[postgres] composite key does not result in constraint creation

Similar Threads

[postgres] composite key does not result in constraint creation

Similar Threads

Similar Threads

Similar Threads