Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Error in creating the backend query
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Benjamin Krajmalnik <kraj(at)illumen(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: Error in creating the backend query
- Date: Wed, 29 Jul 2009 17:19:45 -0400
- Message-id: <20090729211945.GE18634@alvh.no-ip.org> <text/plain>
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.
- Follow-Ups:
- Re: Error in creating the backend query
- From: Tom Lane
- Re: Error in creating the backend query
- From: Benjamin Krajmalnik
- Re: Error in creating the backend query
- References:
- Error in creating the backend query
- From: Benjamin Krajmalnik
- Error in creating the backend query
- Prev by Date: Re: Off-topic - Hardware recommendation
- Next by Date: Re: Error in creating the backend query
- Previous by thread: Error in creating the backend query
- Next by thread: Re: Error in creating the backend query
- Indexes: