admin管理员组

文章数量:1387338

I want fix pg.connect is not a function on node.js.

I install postgreSQL.

my source 

TypeError: pg.connect is not a function
at Socket.<anonymous> (/home/iosys/bin/cctv-sigserver-8241.js:329:20)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at Socket.emit (/home/iosys/bin/node_modules/socket.io/lib/socket.js:129:10)
at Socket.onclose (/home/iosys/bin/node_modules/socket.io/lib/socket.js:418:8)
at Client.onclose (/home/iosys/bin/node_modules/socket.io/lib/client.js:230:12)
at Client.onerror (/home/iosys/bin/node_modules/socket.io/lib/client.js:211:8)
at Client.ondata (/home/iosys/bin/node_modules/socket.io/lib/client.js:177:10)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)



var pg = require('pg');
var pgConString = "postgres://icm:[email protected]/icm";
var client = new pg.Client(pgConString);
// PG update
        pg.connect(pgConString, (err, client, done) => {
            // Handle connection errors
            if(err) {
                  done();
                  console.log(err);
                  //return res.status(500).json({success: false, data: err});
            }
            // SQL Query > Update Data
            var sql_update = "UPDATE becctv SET becamonoff = '1' WHERE mid = '"
                + mid + "' AND bescode = '" + scode + "' AND becamid = '"
                + camid + "'";
            console.log('sql_update 000 = [ ' + sql_update + ' ]');

            const query = client.query(sql_update);

            // After all data is returned, close connection and return results
            query.on('end', function() {
              done();
              //return res.json(results);
            });
        });

why occur this error?

pg install error?

thanks.

I want fix pg.connect is not a function on node.js.

I install postgreSQL.

my source 

TypeError: pg.connect is not a function
at Socket.<anonymous> (/home/iosys/bin/cctv-sigserver-8241.js:329:20)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at Socket.emit (/home/iosys/bin/node_modules/socket.io/lib/socket.js:129:10)
at Socket.onclose (/home/iosys/bin/node_modules/socket.io/lib/socket.js:418:8)
at Client.onclose (/home/iosys/bin/node_modules/socket.io/lib/client.js:230:12)
at Client.onerror (/home/iosys/bin/node_modules/socket.io/lib/client.js:211:8)
at Client.ondata (/home/iosys/bin/node_modules/socket.io/lib/client.js:177:10)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)



var pg = require('pg');
var pgConString = "postgres://icm:[email protected]/icm";
var client = new pg.Client(pgConString);
// PG update
        pg.connect(pgConString, (err, client, done) => {
            // Handle connection errors
            if(err) {
                  done();
                  console.log(err);
                  //return res.status(500).json({success: false, data: err});
            }
            // SQL Query > Update Data
            var sql_update = "UPDATE becctv SET becamonoff = '1' WHERE mid = '"
                + mid + "' AND bescode = '" + scode + "' AND becamid = '"
                + camid + "'";
            console.log('sql_update 000 = [ ' + sql_update + ' ]');

            const query = client.query(sql_update);

            // After all data is returned, close connection and return results
            query.on('end', function() {
              done();
              //return res.json(results);
            });
        });

why occur this error?

pg install error?

thanks.

  • javascript
  • node.js
  • postgresql
Share Improve this question edited Aug 17, 2017 at 3:30 vitaly-t 26k17 gold badges127 silver badges150 bronze badges asked Aug 17, 2017 at 2:31 hyunwookshyunwooks 1413 silver badges14 bronze badges
Add a ment  | 

1 Answer 1

Reset to default 6

pg.connect became deprecated in v6.3.0, and removed in v7.0.0. You can still do client.connect, but the remended approach is pool.connect - see the official documentation.

本文标签： javascriptHow to fix pgconnect is not a function on nodejsStack Overflow

版权声明：本文标题：javascript - How to fix pg.connect is not a function on node.js? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744485693a2608434.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。