Pure Go Postgres driver for database/sql
Pure Go Postgres driver for database/sql
Questions tagged [pq]
81 questions
1
vote
0 answers
"pq: sorry, too many clients" - using Scan(), closing rows, but getting a connection leak somewhere
My code is set up such that every time I want to make a query I open the DB, run QueryRow(), Scan the results into variables, and then close the DB and rows using defer. However, I'm getting a connection leak though I believe I've closing all of…
Davenporten
- 323
- 2
- 13
1
vote
1 answer
RETURNING must contain at least one value
I'm learning to use PostgreSQL and GORM. Trouble came relatively quickly, and it feels as if I'm the only one having this problem ever.
Here, I'm creating a struct, instantiating it, and trying to write it to database. However, it returns an…
Johnny Cache
- 1,033
- 7
- 12
1
vote
1 answer
Create a general func from particular function (refactoring)
I'm using the createUsers func to populate my fake DB, just for tests.
I'm using the bulk imports feature of pq (https://godoc.org/github.com/lib/pq#hdr-Bulk_imports).
func createUsers() {
users := []models.User{}
for i := 0; i < 10; i++…
Fred Hors
- 3,258
- 3
- 25
- 71
1
vote
2 answers
How to set intervalstyle = iso_8601 and then run a select query in golang
I have a table with an interval column, something like this.
CREATE TABLE validity (
window INTERVAL NOT NULL
);
Assume the value stored is 'P3DT1H' which is in iso_8601 format.
When I try to read the value, it comes in regular postgres format.…
Arjun K R
- 427
- 1
- 6
- 25
1
vote
1 answer
golang/pq pq: operator does not exist: bigint = text
query := "WITH b(ColA, ColB) AS (VALUES ($1,$2)) UPDATE schema_name.table_name AS a SET ColC = b.ColB FROM b WHERE a.ColA = b.ColA AND a.ColB = b.ColB"
res, err := db.Exec(query, 1, 1)
The above code fails with the following error:
pq: operator…
Abhishek
- 432
- 5
- 19
1
vote
1 answer
golang database/sql using pq
I'm having this issue
db, err := sql.Open("postgres", "user=xxx dbname=xxx connect_timeout=5 sslmode=disable")
if err != nil {
log.Fatal(err)
}
I have no postgres installed on my localhost so sql.Open should return some error but actually…
Gavello
- 1,399
- 2
- 13
- 25
0
votes
0 answers
Why is my Math with pq-formula wrong or in-precise
I want to do math with the pq-formula but for some reason everything works except that the numbers are different then they should be.
The Formula that I want to represent is:
x1,2 = -p/2 ± √(p^2/4 -q)
If I do the Math with a calculator and not with…
Bennyx
- 11
- 3
0
votes
2 answers
"error: pq: role "root" does not exist" when running pq with Postgres for Docker
I am setting up a local Postgres database on Docker with the postgres:14-alpine image, and running database migrations on it with golang-migrate, when I got the following error message after running the migrate tool:
error: pq: role "root" does not…
ofekatr
- 1
- 2
0
votes
1 answer
Refine Custom Function in Power Query (get Running Total with Custom Function)
I created a Custom Function to get running total with 3 variables as below.
(SourceTable as table, ColumnName, optional NewAddedColumnName as text) =>
let
Add_Index = Table.AddIndexColumn(SourceTable, "Index", 1),
Get_RT =…
Sapiens J
- 5
- 3
0
votes
2 answers
Power query grouping
Can Power query do this?
So I have a group of parent IDs. If the parent Ids are the same but the values from the corresponding attributes are different, I want PQ to let me know they can be grouped together.
Here is the example.
So Parent IDs…
Shanna
- 19
- 1
0
votes
1 answer
How to do WHERE IN/ANY on multiple columns in Golang with pq library?
I have a list of item type and item numbers like follows:
items := models.ItemKeys{
ItemKeys: []models.ItemKey{
{
ItemType: "type1",
ItemNumber: "10347114",
},
{
…
Yusril Maulidan Raji
- 1,682
- 1
- 21
- 46
0
votes
0 answers
Replace values from another table without merging Power Query
I would like to replace values in a columns from corresponding values in another table avoiding merging and expanding columns.
Data which I want to send to another table:
Table where I want to replace data:
As you can see I have 2 tables but they…
Mateusz
- 1
0
votes
1 answer
Golang SQL Error: "pq: relation "userdata" does not exist"
I am making a simple CRUD app with Golang using a postgres database hosted on my computer. I am using the sql driver https://github.com/lib/pq.
I am able to successfully store users in the database from a POST request with the following code
func…
preordertraverser
- 19
- 2
0
votes
2 answers
gorm - defining a default value function
I'm trying to follow Gorm's documentation to create a generated field, defined by a function:
type Foo struct {
ID int64 `json:"id"`
AmountOfBars string `json:"amount_of_bars" gorm:"default:amount_of_bars()"`
}
type RelatedBar…
idik
- 872
- 2
- 10
- 19
0
votes
0 answers
Idiomatic way of eager loading - how to populate deep nested association with database/sql and pq
I was just wondering how to deal with eager loading queries to retrieve data with several associations, let me explain my models:
type User struct {
Id uint
Name string
Username string
Image string
}
type Post struct {
Id unit
Content…
Hossein
- 115
- 1
- 11