"runtime error: invalid memory address or nil pointer dereference"创建表

Question

我正在用Go 1.11和postgres弄湿我的脚。

package db
import (
    "database/sql"
    _ "github.com/lib/pq" //database connector
    g "app/globalvariables"
)
func CreateTable(tid int) {
s := "CREATE TABLE someschema.sometable" + string(tid) + "(id serial PRIMARY KEY,...);"
    db, _ := sql.Open("postgres", "user="+g.DB_USER+" dbname="+g.DB_NAME+" sslmode=disable")
    defer db.Close()
    q, _ := db.Prepare(s)
    q.Exec()
}

测试函数时，我得到：

panic: runtime error: invalid memory address or nil pointer dereference [recovered]
    panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0x51d46a]

能是什么？

Answer 1

我只是将整数转换为带有"字符串"的字符串。我必须使用strconv。约塔。