inserting string data into int column fails silently

[kkaefer]

z, x, y are int columns:

var pg = require('pg');

var credentials = 'pg://demo@localhost/logs';

var client = new pg.Client(credentials);
client.connect();

client.query("INSERT INTO requests (api, name, z, y, x, type) " +
    "VALUES ($1, $2, $3, $4, $5, $6)",
    [ '1.0.0', 'foo', '35', '5', '2', 'png' ],
    function(err) {
        console.log(err);
    });

[brianc]

does the data not get inserted? When I test this:

var pg = require(__dirname + '/../node-postgres/lib');
pg.connect("tcp://postgres:1234@localhost/postgres", Æ(err, client) {
  client.query("CREATE TEMP TABLE test(num integer)");
  client.query("INSERT INTO test(num) VALUES($1)", ['1'], Æ(err, result) {
    console.log("error: %j", err);
    console.log("result: %j", result);
  })
})

I get the output:

$ node spike/insert-tests.js
error: null
result: {"rows":[],"command":"INSERT","rowCount":1,"oid":0}

[kkaefer]

Sorry for that; I suspect it didn't get inserted because the surrounding transaction was cancelled.