Re: [GENERAL] Getting value of bind variables

2011-08-23 Thread Martijn van Oosterhout
On Tue, Aug 23, 2011 at 09:07:20AM +0530, Jayadevan M wrote: > I guess so. But when I tried the same query on psql by replacing ($4) with > a value like '20110404', the query works OK. The value of $4 is being > passed from a java application. So does this mean I have to change the > data type i

Re: [GENERAL] Getting value of bind variables

2011-08-22 Thread Jayadevan M
Hi, Thank you for the reply. > > I am trying to debug a query that gives an error. The error in the > > application server log is > > " ERROR: operator does not exist: timestamp without time zone = character > > varying > > > It looks like the error is for the condition ( CUSINDINF.MEMDOB ) =

Re: [GENERAL] Getting value of bind variables

2011-08-19 Thread Andy Colson
On 8/19/2011 9:01 AM, Adrian Klaver wrote: On Friday, August 19, 2011 6:55:39 am Andy Colson wrote: As of now, I am trying with logging level set to debug5 in postgresql.conf for all logging options. But what is the 'correct' approach? Regards, Jayadevan Not sure what the exact setting is, tr

Re: [GENERAL] Getting value of bind variables

2011-08-19 Thread Tom Lane
Jayadevan M writes: > I am trying to debug a query that gives an error. The error in the > application server log is > " ERROR: operator does not exist: timestamp without time zone = character > varying > It looks like the error is for the condition ( CUSINDINF.MEMDOB ) = ($4) , > memdob bein

Re: [GENERAL] Getting value of bind variables

2011-08-19 Thread Adrian Klaver
On Friday, August 19, 2011 6:55:39 am Andy Colson wrote: > > As of now, I am trying with logging level set to debug5 in > > postgresql.conf for all logging options. But what is the 'correct' > > approach? > > > > Regards, > > Jayadevan > > Not sure what the exact setting is, try: > > log_stateme

Re: [GENERAL] Getting value of bind variables

2011-08-19 Thread Andy Colson
On 8/19/2011 6:19 AM, Jayadevan M wrote: Hell l, I am trying to debug a query that gives an error. The error in the application server log is " ERROR: operator does not exist: timestamp without time zone = character varying Hint: No operator matches the given name and argument type(s). You might

[GENERAL] Getting value of bind variables

2011-08-19 Thread Jayadevan M
Hell l, I am trying to debug a query that gives an error. The error in the application server log is " ERROR: operator does not exist: timestamp without time zone = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Po