尝试插入时不存在PostgreSQL列
DROP TABLE IF EXISTS workspace;
CREATE TABLE "workspace" (
"wk_space" VARCHAR(100) NOT NULL,
"token" TEXT,
PRIMARY KEY("wk_space", "token")
);
INSERT INTO "workspace" ("wk_space", "token") VALUES ("team1", "upreawnysoafa22sva") ON CONFLICT (wk_space, token) DO NOTHING;
SELECT * FROM workspace;
这将出现一个错误,说列“ Team1”不存在
。如果我将值替换为
(“ Team1”,“ Upreawnysoafa22sva”)
> (11,22)
等数字,则可以正常工作。我不知道怎么了。
DROP TABLE IF EXISTS workspace;
CREATE TABLE "workspace" (
"wk_space" VARCHAR(100) NOT NULL,
"token" TEXT,
PRIMARY KEY("wk_space", "token")
);
INSERT INTO "workspace" ("wk_space", "token") VALUES ("team1", "upreawnysoafa22sva") ON CONFLICT (wk_space, token) DO NOTHING;
SELECT * FROM workspace;
This will give an error saying column "team1" does not exist
. If I replace the values ("team1", "upreawnysoafa22sva")
to numbers like (11, 22)
, it works fine. I don't know what's going wrong.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论