AdapterUser.id is a string, but pg-adapter uses an integer

[spencerwilson]

Adapter type

@auth/pg-adapter

Environment

  System:
    OS: macOS 14.2.1
    CPU: (10) arm64 Apple M1 Pro
    Memory: 1.29 GB / 32.00 GB
    Shell: 5.9 - /bin/zsh
  Binaries:
    Node: 20.12.2 - ~/.nodenv/versions/20.12.2/bin/node
    npm: 10.5.0 - ~/.nodenv/versions/20.12.2/bin/npm
  Browsers:
    Chrome: 124.0.6367.158
    Safari: 17.2.1
  npmPackages:
    @auth/core: ^0.28.2 => 0.28.2
    @auth/pg-adapter: ^0.7.2 => 0.7.2
    next: ^14.1.4 => 14.2.3
    next-auth: ^5.0.0-beta.16 => 5.0.0-beta.16
    react: ^18.2.0 => 18.2.0

Reproduction URL

n/a

Describe the issue

In the database a user's ID is stored as an integer: https://github.com/nextauthjs/next-auth/blob/%40auth/pg-adapter%400.7.2/packages/adapter-pg/schema.sql#L42

This seems at odds AdapterUser.id, which says that id is a string: https://authjs.dev/reference/core/adapters#adapteruser

This inconsistency makes it difficult to use user IDs in TypeScript. Other data models use id: number, matching what's in the users table; when comparisons to an AdapterUser.id (such as session.user?.id, during authorization policy checks) the compiler reports a type mismatch between the user ID stored in the database and that on the session.

How to reproduce

n/a

Expected behavior

The type of id is consistent everywhere, facilitating usage (especially comparison) from application code.

[github-actions]

We could not detect a valid reproduction link. Make sure to follow the bug report template carefully.

Why was this issue closed?

To be able to investigate, we need access to a reproduction to identify what triggered the issue. We need a link to a public GitHub repository. Example: (NextAuth.js example repository).

The bug template that you filled out has a section called "Reproduction URL", which is where you should provide the link to the reproduction.

• If you did not provide a link or the link you provided is not valid, we will close the issue.
• If you provide a link to a private repository, we will close the issue.
• If you provide a link to a repository but not in the correct section, we will close the issue.

What should I do?

Depending on the reason the issue was closed, you can do the following:

• If you did not provide a link, please open a new issue with a link to a reproduction.
• If you provided a link to a private repository, please open a new issue with a link to a public repository.
• If you provided a link to a repository but not in the correct section, please open a new issue with a link to a reproduction in the correct section.

In general, assume that we should not go through a lengthy onboarding process at your company code only to be able to verify an issue.

My repository is private and cannot make it public

In most cases, a private repo will not be a sufficient minimal reproduction, as this codebase might contain a lot of unrelated parts that would make our investigation take longer. Please do not make it public. Instead, create a new repository using the templates above, adding the relevant code to reproduce the issue. Common things to look out for:

• Remove any code that is not related to the issue. (pages, API Routes, components, etc.)
• Remove any dependencies that are not related to the issue.
• Remove any third-party service that would require us to sign up for an account to reproduce the issue.
• Remove any environment variables that are not related to the issue.
• Remove private packages that we do not have access to.
• If the issue is not related to a monorepo specifically, try to reproduce the issue without a complex monorepo setup

I did not open this issue, but it is relevant to me, what can I do to help?

Anyone experiencing the same issue is welcome to provide a minimal reproduction following the above steps by opening a new issue.

I think my reproduction is good enough, why aren't you looking into it quickly?

We look into every issue and monitor open issues for new comments.

However, sometimes we might miss a few due to the popularity/high traffic of the repository. We apologize, and kindly ask you to refrain from tagging core maintainers, as that will usually not result in increased priority.

Upvoting issues to show your interest will help us prioritize and address them as quickly as possible. That said, every issue is important to us, and if an issue gets closed by accident, we encourage you to open a new one linking to the old issue and we will look into it.

Useful Resources

• How to create a Minimal, Complete, and Verifiable example
• Bug report: Framework
• Bug report: Provider
• Bug report: Adapter