CODEWITHSUNDEEP
javascriptpostgresqlnode-postgres
garson
garson

Reputation: 1617

postgreSQL error: "constraint does not exist" (but it does exist...)

I have a database that I'm trying to update, and I can't figure out why I'm getting this weird error about a column not existing. When I access the database using 'heroku pg:psql' I can totally see the column though. I have found a couple other questions with similar issues, but haven't been able to resolve it.

Here is my code to execute the INSERT...ON CONFLICT WITH CONSTRAINT...any ideas?

const text = 'INSERT INTO "test2" '
+'(route_id, secupdated, retrievedate, traintimeday) '
+'VALUES($1, $2, $3, $4) '
+'ON CONFLICT ON CONSTRAINT traintimeday '
+'DO UPDATE SET (secupdated, secarrival) = (excluded.secupdated, excluded.secarrival) '
+'RETURNING *' ; 
const values = [train_id 
, Math.round(dateNow.getTime()/1000)
, Math.round(dateNow.getDate())
, Math.round(dateNow.getDate()) + stu.stop_id
]; 
pool.query(text, values, (err, res) => {
if (err) {
throw err;
}
console.log('user:', res.rows[0])
})

The error message says that 'constraint traintimeday does not exist'

Upvotes: 3

Views: 7463

Answers (1)

Vinicius Braz Pinto
Vinicius Braz Pinto

Reputation: 8289

If traintimeday is not a constraint, instead of:

+'ON CONFLICT ON CONSTRAINT traintimeday '

use:

+'ON CONFLICT (traintimeday) '

Upvotes: 5

Related Questions