摘要：
-- name: ListAccounts :many SELECT * FROM accounts WHERE owner = $1 ORDER BY id LIMIT $2 OFFSET $3; -- name: UpdateAccount :one UPDATE accounts SET ba
阅读全文
posted @ 2023-12-02 23:09
ZhangZhihuiAAA
阅读(21)
推荐(0)
摘要：
ERROR: deadlock detectedDETAIL: Process 209 waits for ShareLock on transaction 1034; blocked by process 201.Process 201 waits for ShareLock on transac
阅读全文
posted @ 2023-12-02 23:02
ZhangZhihuiAAA
阅读(347)
推荐(0)
摘要：
pg_locks view Looking at pg_locks shows you what locks are granted and what processes are waiting for locks to be acquired. A good query to start look
阅读全文
posted @ 2023-12-02 22:26
ZhangZhihuiAAA
阅读(31)
推荐(0)
摘要：
or Adding "-count=1" to "go.testFlags" can disable go test cache.
阅读全文
posted @ 2023-11-29 18:51
ZhangZhihuiAAA
阅读(63)
推荐(0)
摘要：
The default timezone of a newly created database is UTC. You can set the timezone to a new value sessionly or globally: zzh@ZZHPC:~$ docker exec -it p
阅读全文
posted @ 2023-11-29 15:38
ZhangZhihuiAAA
阅读(34)
推荐(0)
摘要：
Problem: sqlc can't recognize PostgreSQL data types numeric and decimal with the default database driver package database/sql, it makes them string. U
阅读全文
posted @ 2023-11-29 08:40
ZhangZhihuiAAA
阅读(93)
推荐(0)
摘要：
go install github.com/sqlc-dev/sqlc/cmd/sqlc@latest zzh@ZZHPC:~$ sqlc version v1.24.0 zzh@ZZHPC:/zdata/Github/zimplebank$ sqlc init sqlc.yaml is added
阅读全文
posted @ 2023-11-28 18:57
ZhangZhihuiAAA
阅读(18)
推荐(0)
posted @ 2023-11-28 18:31
ZhangZhihuiAAA
阅读(13)
推荐(0)
摘要：
zzh@ZZHPC:~$ sudo apt install postgresql-client zzh@ZZHPC:~$ psql --version psql (PostgreSQL) 14.9 (Ubuntu 14.9-0ubuntu0.22.04.1) zzh@ZZHPC:~$ psql po
阅读全文
posted @ 2023-11-27 20:33
ZhangZhihuiAAA
阅读(47)
推荐(0)
摘要：
Got below error: Makefile:2: *** missing separator. Stop. Check the Makefile using cat -e -t -v: zzh@ZZHPC:/zdata/Github/zimplebank$ cat -vE -t Makefi
阅读全文
posted @ 2023-11-27 19:25
ZhangZhihuiAAA
阅读(25)
推荐(0)
浙公网安备 33010602011771号
浙ICP备2021040463号-3
