the sql in postgres : create schema temp; set search_path = temp; create table item ( id INT generated by default as identity primary key ); create table tag ( id INT generated by default as identity primary key, name VARCHAR(160), item_id INT references item (id) ); create view item_tags as select id, ( select … Read more
The reason for this is because PostgreSQL does not return you the last inserted id. This is because last inserted id is available only if you create a new row in a table that uses a sequence. If you actually insert a row in the table where a sequence is assigned, you have to use … Read more
Alright, I found the solution, thanks this answer. The problem goes by adding ?parseTime=true to the db mapper. Like this: db, err := sqlx.Connect(“mysql”, “myuser:mypass@tcp(127.0.0.1:3306)/mydb?parseTime=true”)