Syntax error near "," with postgres go lib pq

Question

I try to create a simple insert statement and get the error:

pq: syntax error at or near ","

txn, err := db.Begin()
stmt, err := db.Prepare(`INSERT INTO advertiser_per_day (id,advertiser_name,additional,customer_id,site_id,tracking,counter,day,month,year) VALUES (?,?,?,?,?,?,?,?,?,?)`)

If I put the statement into a query tool for postgres all works fine... Any ideas?

Roman Kiselenko · Accepted Answer · 2020-03-09 09:42:25Z

3

You should use ($n) instead of ? for the bound parameters.

answered Mar 9, 2020 at 9:42

Roman Kiselenko

44.5k9 gold badges100 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Roman Kiselenko Over a year ago

? is for mysql, $n works fine in my code. Are you sure parameters isn't empty ? Show the full code please.

Jurudocs Over a year ago

thanks for you help. Not even getting to the place he fills the parameters.. it fails before...

Jurudocs Over a year ago

i try to do this in the end: INSERT INTO advertiser_per_day (id, advertiser_name, additional, customer_id, site_id, tracking, counter, day, month, year) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (id) DO UPDATE SET counter=counter+1 but now getting error pq: column reference "counter" is ambiguous Do you have a last guess for me. Would be awesome

Roman Kiselenko Over a year ago

Looks like postgres dont recognize what column in wich table to use. you should denoted it like advertiser_per_day.counter or something like this.

Collectives™ on Stack Overflow

Syntax error near "," with postgres go lib pq

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related