Re: Error in creating the backend query

["Benjamin Krajmalnik" <kraj(at)illumen(dot)com>]

I tried it with both on and off, and it did not make a difference.

> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
> Sent: Wednesday, July 29, 2009 3:20 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Error in creating the backend query
> 
> Benjamin Krajmalnik wrote:
> 
> > update tblksalerts set cleartime = '2009-07-29 10:49:50'::TIMESTAMP,
> > laststatusid = 7::INTEGER, lastreplytext = '0'::VARCHAR,
lasttesttime
> =
> > '2009-07-29 10:49:50'::TIMESTAMP, lasteventsource is NULL::VARCHAR,
> > lasteventid is NULL::INTEGER, replyval = 0::REAL, trend =
''::varchar
> (
> > 1 ), alertoccurrence = 0::integer where ksalertssysid = 1737078
> 
> > Please note the "lasteventsource is null" instead of
"lasteventsource
> =
> > null" which is being generated when the value of x_eventsource is
> null.
> 
> Do you have transform_null_equals set?
> 
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.