i'm using nodejs node-postgres module , have simple queries can't understand how can catch errors on insert queries. that's sample code:
pg.connect(constring, function (err, client, done) { client.query("insert foo(bar) values ('lol')"); res.json({'err':0,'message':'successful insert'}); });
i add res.json({'err':1,'message':'errror'});
in case of error during query.
due example in github page: https://github.com/brianc/node-postgres
screenshot: http://joxi.ru/k823gg6uvx3d2o
try this:
pg.connect(constring, function (err, client, done) { if(err) { console.log('cannot connect!', err); return; } client.query("insert foo(bar) values ('lol')", [], function(err, result) { if(err) { console.log('error: ', err); res.json({'err':1,'message':'errror'}); return; } res.json({'err':0,'message':'successful insert'}); }); });
Comments
Post a Comment