Comments (6)
The issue should be fixed in latest commit.
Thank you for your report.
from gorm.
I am seeing this pq message (though as a warning rather than a panic)
$ go run main.go
(pq: syntax error at or near "user")
[2014-05-15 11:28:05]
(pq: syntax error at or near "user")
[2014-05-15 11:28:05]
main.User{Id:0, Birthday:time.Time{sec:63535775285, nsec:0x2ff616cf, loc:(*time.Location)(0x4d0740)}, Age:18, Name:"jinzhu", CreatedAt:time.Time{sec:63535775285, nsec:0x2ff99406, loc:(*time.Location)(0x4d0740)}, UpdatedAt:time.Time{sec:63535775285, nsec:0x2ff99406, loc:(*time.Location)(0x4d0740)}, DeletedAt:time.Time{sec:0, nsec:0x0, loc:(*time.Location)(nil)}, Emails:[]main.Email(nil), BillingAddress:main.Address{Id:0, Address1:"", Address2:"", Post:sql.NullString{String:"", Valid:false}}, BillingAddressId:sql.NullInt64{Int64:0, Valid:false}, ShippingAddress:main.Address{Id:0, Address1:"", Address2:"", Post:sql.NullString{String:"", Valid:false}}, ShippingAddressId:0, IgnoreMe:0}
(based on the example code from the README)
from gorm.
ah, I see the original person was raising their own panic.
from gorm.
With debugging turned on:
➜ gorm go run main.go
(/private/tmp/golang-orm-tests/gorm/main.go:67)
[2014-05-15 11:31:43] pq: syntax error at or near "user"
(/private/tmp/golang-orm-tests/gorm/main.go:67)
[2014-05-15 11:31:43] [1.04ms] CREATE TABLE user ("id" bigserial PRIMARY KEY,"birthday" timestamp with time zone,"age" bigint,"name" varchar(255) ,"created_at" timestamp with time zone,"updated_at" timestamp with time zone,"deleted_at" timestamp with time zone,"billing_address_id" bigint,"shipping_address_id" bigint)
(/private/tmp/golang-orm-tests/gorm/main.go:70)
[2014-05-15 11:31:43] pq: syntax error at or near "user"
(/private/tmp/golang-orm-tests/gorm/main.go:70)
[2014-05-15 11:31:43] [0.74ms] INSERT INTO user ("birthday","age","name","created_at","updated_at","deleted_at","billing_address_id","shipping_address_id") VALUES ('2014-05-15 11:31:43.861738227 -0700 PDT','18','jinzhu','2014-05-15 11:31:43.861904463 -0700 PDT','2014-05-15 11:31:43.861904463 -0700 PDT','0001-01-01 00:00:00 +0000 UTC','{0 false}','0') RETURNING "id"
...
Using pg 9.3.4
from gorm.
Hi @drnic,
Seems user is a reserved keyword in PostgreSQL. just fixed it by quote the table name.
Sorry for the problem.
from gorm.
Ahh gotcha! Thanks. Santization is always useful :)
On Mon, May 19, 2014 at 2:12 PM, Jinzhu [email protected] wrote:
Hi @drnic,
Seems user is a reserved keyword in PostgreSQL. just fixed it by quote the table name.Sorry for the problem.
Reply to this email directly or view it on GitHub:
jinzhu#21 (comment)
from gorm.
Related Issues (20)
- How to use interfaces type with Gorm?
- The case when syntax of mssql is not supported HOT 2
- GetIndexes not implemented HOT 5
- btree_gist constraint example
- Wrong table creation order causes migration failure (but not in SQLite)
- More efficient preloading
- Add derived column along with default fields
- 查找不到数据的时候,err与gorm.ErrRecordNotFound比较的结果是false HOT 5
- Update multiple rows with different values in one query in postgres
- Save struct with same relation in associated table HOT 1
- Scan row into multiple structs
- feature: add Chinese README.md
- N+1 Queries with Joins("Company").Preload("Company.Addresses") on Addresses
- What happens when IN clause is too big?
- Document how to use Gorm with Cloud SQL Go Connector HOT 2
- Model() ignores primary key in passed argument
- main.go:5:2: gorm.io/[email protected]: Get "https://proxy.golang.org/gorm.io/gorm/@v/v1.25.9.zip": dial tcp 172.217.163.49:443: i/o timeout HOT 1
- 使用gorm生成的sql能查询到数据,但是返回的结构体里面没有数据 HOT 1
- gorm join时候没有对关联表的软删除进行过滤 HOT 1
- 使用join关联查询数据时候发现关联表没有自动过滤掉软删除的数据
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gorm.