go module_error ai_generated true

sql: unknown driver "postgres" (forgotten import?)

ID: go/sql-driver-unknown

Also available as: JSON · Markdown · 中文
80%Fix Rate
90%Confidence
0Evidence
2024-02-05First Seen

Version Compatibility

VersionStatusIntroducedDeprecatedNotes
1.18 active — — —
1.22 active — — —

Root Cause

The database driver package was not imported with a blank import, so database/sql has no registered driver.

generic

中文

未以空白导入方式导入数据库驱动包，database/sql 没有已注册的驱动。

Workarounds

  1. 95% success 
    import (
  "database/sql"
  _ "github.com/lib/pq"
)
db, _ := sql.Open("postgres", dsn)
  2. 90% success 
    Use pgx/v5/stdlib blank import when using pgx driver.

Dead Ends

Common approaches that don't work:

  1. 60% fail

    Named imports can trigger 'imported and not used' unless referenced.

  2. 90% fail

    Only changes the error message.