Comments (1)
Copying my Stackoferflow question, where I wrote with a simple code to demo the problem:
I'm using go-gorm with a postgres 11 DB and facing an issue where I need to remove the RETURNING clause entirely when creating records (that statement seems to be included by default). I just want to insert records and get nothing back, except for errors.
I have some complex relations on the database that won't support RETURNING statements, so when I try to insert like this: (made code simpler for brevity)
type Cargo struct {
Id int64 `gorm:"primaryKey"`
Name string
}
dsnString := fmt.Sprintf("host=%s ...")
db, _ := gorm.Open(postgres.New(postgres.Config{DSN: dsnString}), &gorm.Config{})
cargo := Cargo{Name: "test"}
db.Create(cargo)
I get the error "ERROR: cannot perform INSERT RETURNING on relation X".
I tried creating the db connection with the parameter WithoutReturning: true:
db, _ := gorm.Open(postgres.New(postgres.Config{DSN: dsnString, WithoutReturning: true}), &gorm.Config{})
But then when I try db.Create(cargo)
I get a different error: "LastInsertId is not supported by this driver". It seems to be still trying to get the last inserted id anyway.
In go-pg I could use db.Model(x).Returning("null").Insert(cargo)
but I couldn't find a way to do it with go-gorm. Any help is greatly appreciated.
from postgres.
Related Issues (20)
- v1.5.4 breaks generated jsonb default value for postgres
- Index functions (GetIndexes, DropIndex, RenameIndex) doesn't use current table schema
- bug: postgres driver tries to insert slices and arrays as records, and fails (reproduction included) HOT 2
- AlterColumn fieldColumnType空指针
- postgres cannot skip foreign key creation in AutoMigrate with composite key for optional association? HOT 1
- DropIndex and RenameIndex don't prefix index name with TablePrefix
- ERROR: syntax error at or near "s" (SQLSTATE 42601) HOT 2
- Security issue: password leaking to logs HOT 1
- m.GuessConstraintInterfaceAndTable undefined HOT 2
- Failure to connect returns wrong error message in 1.5.5 HOT 5
- Updating to `jackc/pgx/[email protected]` causes issues HOT 3
- Deleted version v1.5.5 causes problems should be retracted HOT 3
- dryrun模式下除了新建table外的migrate都失败
- Failed to convert column from text[] to JSON or JSONB
- Custom naming strategies no longer work with changes from PR-232/ISSUE-191 HOT 1
- CVE GO-2024-2606 - Need to bump `pgx` version
- From v1.5.6, func GetIndexes() Cannot query primary key index
- Dependency(github.com/jackc/pgx/v5) is vulnerable HOT 1
- When switching from v1.4.5 to v1.4.6 or above: "cannot find encode plan" on timestampz
- Cannot create self referencing dependency on none primary key
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 postgres.