Cc: Alvaro Herrera; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Error in creating the backend query
>
> I wish that were the case.
> I am running 8.3.7 built from the FreeBSD ports.
> All insertions and updates to that table (or any others) are done
> exclusively through tha
"Benjamin Krajmalnik" writes:
> So the plpgsql stored procedure is definitely the source.
If you want to convince me of that you need to provide a *self
contained* demonstration. An out-of-context procedure definition
isn't helpful because I can't test it.
regards, tom l
PM
> To: Benjamin Krajmalnik
> Cc: Alvaro Herrera; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Error in creating the backend query
>
> "Benjamin Krajmalnik" writes:
> > Below is the full stored procedure.
>
> All I can do is repeat that plpgsql does
"Benjamin Krajmalnik" writes:
> Below is the full stored procedure.
All I can do is repeat that plpgsql does not behave that way. It never
has AFAIR, and it most definitely doesn't in any version new enough to
recognize the COST option to CREATE FUNCTION (ie, 8.3 and up). In fact,
I don't belie
e, timestamp
without time zone, integer, character varying, character varying,
integer) OWNER TO postgres;
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Wednesday, July 29, 2009 3:31 PM
> To: Alvaro Herrera
> Cc: Benjamin Krajmalnik; pg
Benjamin Krajmalnik wrote:
> I tried it with both on and off, and it did not make a difference.
Please show a complete example.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-
Alvaro Herrera writes:
> Benjamin Krajmalnik wrote:
>> 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?
Even if he did, that wouldn't affect the source form
I tried it with both on and off, and it did not make a difference.
> -Original Message-
> From: Alvaro Herrera [mailto:alvhe...@commandprompt.com]
> Sent: Wednesday, July 29, 2009 3:20 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN]
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, tren
PostgreSQL 8.3.7 running on FreeBSD.
The following query:
update tblksalerts
set cleartime = x_cleartime,
laststatusid = x_statusid,
lastreplytext = x_replytxt,
lasttesttime = x_testtime
10 matches
Mail list logo
