I tried it with both on and off, and it did not make a difference.
> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre@commandprompt.com]
> Sent: Wednesday, July 29, 2009 3:20 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.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.