I tried it with both on and off, and it did not make a difference. > -----Original Message----- > From: Alvaro Herrera [mailto:alvherre@xxxxxxxxxxxxxxxxx] > Sent: Wednesday, July 29, 2009 3:20 PM > To: Benjamin Krajmalnik > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
