Case in the field name disappears only for me?

olivierphi / Node-DBI

A SQL database abstraction layer strongly inspired by the PHP Zend Framework Zend_Db API, with support of multiple Node.js database engines

https://github.com/DrBenton/Node-DBI

93 stars 22 forks source link

Case in the field name disappears only for me? #15

Open alexsuslov opened 11 years ago

alexsuslov commented 11 years ago

Hi!

DBWrapper = require('node-dbi').DBWrapper;
var Config= { host: 'localhost', database: 'tmp'}

var dbWrapper = new DBWrapper('pg', Config);
dbWrapper.connect();

var item = {"sName": 'Milky'};

dbWrapper.update('"Users"."Company"', item, ['\"idCompany\" = 1'], function(err, resp) {
  if (err) {throw err}
  if (resp) {console.log(resp)}
});

error: column "sname" of relation "Company" does not exist

alexsuslov commented 11 years ago

It problem is only with update. Select and insert go normal. for update i use "\"Dragon_Users\".\"tCompany\"" look like voodoo

olivierphi commented 10 years ago

@alexsuslov I don't know postgres enough to be able to solve such a bug, sorry. But I would be glad to work with you and your knowledge of Pg to solve this issue together! :-)