require('pg').native doesn't work with query row event #743

adayton1 · 2015-03-06T22:43:41Z

If I uncomment the query.on('row'...) section below, node complains that the function addRow does not exist. When I just use require('pg') it works properly.

var pg = require('pg').native;

pg.connect(connectionString, function(err, client, done) {

    if (err) {
        console.error(err);
    }

    var query = client.query(queryString, params);

    query.on('error', function(err) {
        console.error(err);
    });

    /*query.on('row', function(row, result) {
        result.addRow(row);
    });*/

    query.on('end', function(result) {
        done();
    });
});

deyhle · 2015-05-07T15:56:00Z

+1

Tested with node 0.12.2.

Apparently the result parameter is no Result object. My debugger shows that it is module.exports instead.

JSON.stringify(result) returns:

{"command":"SELECT","rowCount":1,"rows":[{"description":"0.2.1"}],"fields":[{"name":"description","dataTypeID":25}]}

vaseker · 2015-06-23T08:29:28Z

+1
node 0.12.4
[email protected]
[email protected]

traviscrawford · 2016-01-29T20:19:10Z

Hi all, I just came across this today when switching to pg-native. Per this note in the project readme I believe this method should be available, even if its a no-op when using libpq:

node-postgres abstracts over the pg-native module to provide exactly the same interface as the pure JavaScript version. No other code changes are required. If you find yourself having to change code other than the require statement when switching from require('pg') to require('pg').native please report an issue.

"pg": "4.4.4",
"pg-native": "1.10.0",

coagmano · 2016-02-02T01:43:43Z

+1
node 4.2.4

"pg": "4.4.4",
"pg-native": "1.10.0"

coagmano · 2016-02-12T03:09:19Z

Made a PR ^^ to fix this

coagmano mentioned this issue Feb 2, 2016

require('pg').native doesn't work with query row event brianc/node-pg-native#37

Closed

coagmano mentioned this issue Feb 12, 2016

Bring native API in line with pure js version. Fixes #743 #937

Merged

brianc closed this in f26cb73 Feb 15, 2016

deyhle mentioned this issue Feb 15, 2016

Error object differs between pg and pg-native #938

Closed

Aug	SEP	Oct
	06
2019	2020	2021

brianc / node-postgres

require('pg').native doesn't work with query row event #743

require('pg').native doesn't work with query row event #743

adayton1 commented Mar 6, 2015

deyhle commented May 7, 2015

vaseker commented Jun 23, 2015

traviscrawford commented Jan 29, 2016

coagmano commented Feb 2, 2016

coagmano commented Feb 12, 2016

brianc / node-postgres

Sponsor brianc/node-postgres

Join GitHub today

require('pg').native doesn't work with query row event #743

require('pg').native doesn't work with query row event #743

Comments

adayton1 commented Mar 6, 2015

deyhle commented May 7, 2015

vaseker commented Jun 23, 2015

traviscrawford commented Jan 29, 2016

coagmano commented Feb 2, 2016

coagmano commented Feb 12, 2016