Repository navigation
NOTIFY query - syntax error at or near "$1" #1258
Description
What is the syntax error in this query?
Have tried a variety of quoting options - (have escaped the comma, thinking this was the problem?)
One of you will look at this and say 'ah ha!'
pool.connect(function(err, client, done) {
if(err) {
// return console.error('error fetching client from pool', err);
return console.error(err);
}
// PostgreSQL NOTIFY
client.query("NOTIFY bottle\, $1", ["hope you get this message"], function(err, result) {
done(err);
if(err) {
return console.error('error running query', err);
}
console.log('Successful NOTIFY');
});
});
Activity
charmander commentedon Apr 7, 2017
NOTIFYstatements can’t be parameterized. From https://www.postgresql.org/docs/current/static/sql-notify.html:So:
See also #539.