current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

console.log outputs it like this,

{ [error: syntax error at or near "step"]
  length: 86,
  name: 'error',
  severity: 'ERROR',
  code: '42601',
  detail: undefined,
  hint: undefined,
  position: '62',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  file: 'scan.l',
  line: '1001',
  routine: 'scanner_yyerror' }

but JSON.stringify doesn't sees the narrative part of an error,

{"length":86,"name":"error","severity":"ERROR","code":"42601","position":"62","file":"scan.l","line":"1001","routine":"scanner_yyerror"}

I can't figure out how to get this "error: column "undefined" does not exist" reading wikies (https://github.com/brianc/node-postgres/wiki/Error-handling, http://nodejs.ru/doc/v0.4.x/stdio.html#console.log)

The code is like this,

   client.query(selstring, function(err, result) {
   if(err){
     res.send(JSON.stringify(err));
     console.log(err);
   }else{

thanks

UPDATE: err.toString() shows error: syntax error at or near "step"

share|improve this question
    
Please post the contents of selstring. –  robertklep Feb 27 '13 at 13:19
    
i dont think it really matters, but here it is: select max(date)::character varying dt from calendar where11 step=0 . my task is to get the error description. the query is intentionally wrong –  fedd Feb 27 '13 at 13:24
1  
Oh right sorry, I misunderstood your question :( What does err.toString() return? –  robertklep Feb 27 '13 at 13:24
1  
Still not quite sure what you're trying to accomplish. If you want the narrative, you can get it with toString (EDIT: err.message is much cleaner) –  robertklep Feb 27 '13 at 14:21
1  
A class can overload the toJSON method to decide for itself what will be returned when you call JSON.stringify() on its instances. Here's an example: jsfiddle.net/QmWfq –  robertklep Feb 27 '13 at 14:33

3 Answers 3

up vote 0 down vote

The easy fix is to add port parameter into your connection, even if it is the default port. I had the exact same issue. I found out about the solution from this github issue.

var pg_conn_conf = {
  username: 'user',
  pass: 'pass',
  port: 5432,
  host: 'localhost',
  db: 'mydb'
};

There is also another stackoverflow answer that suggests extending the Error.prototype, luckily you don't have to deal with that in this case. But it is a good trick to know.

share|improve this answer
up vote -1 down vote

I've been struggling to understand the same thing for a long time now.

Looking at the output of JSON.stringify(err), it appears that the object has an array as an unnamed attribute. How is it even possible to create an object with an anonymous attribute? I once messed with this for quite a while but could find no way to even construct any object that could generate a similar structure from JSON.stringify.

I've found err.message actually works to access the string, but I really don't understand why, as 'message' doesn't appear as an attribute in the stringified version. If 'message' is an attribute of err, why doesn't it show up in the output from stringify? If it isnt, then where is it coming from?

share|improve this answer
    
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. –  jww Apr 19 '14 at 0:29
    
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. –  nKn Apr 19 '14 at 0:40
    
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post. –  Brandon Wamboldt Apr 19 '14 at 1:19
up vote 0 down vote

First step put console like

console.log(query.text);

Also refer the link may use

http://dailyjs.com/2011/09/26/heroku/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.