On 18.02.2010, at 17:32, Tom Lane wrote:
> zkn writes:
>> I have a weird problem with batch insert. It works fine on my development
>> machine but when I upload to the server it fails. Here is the log:
>
>> DEBUG [http-8443-2] - {conn-100123} Preparing Statement: insert into
>> target_filters
zkn writes:
> I have a weird problem with batch insert. It works fine on my development
> machine but when I upload to the server it fails. Here is the log:
> DEBUG [http-8443-2] - {conn-100123} Preparing Statement: insert into
> target_filters_sections (filter_id, section_id) values (?, ?) , (
Hi,
First I'm sorry if this message shouldn't be posted in this mailing list but I
wasn't sure if it should be here or in jdbc mailing list.
I have a weird problem with batch insert. It works fine on my development
machine but when I upload to the server it fails. Here is the log:
DEBUG [http-
On Thu, Feb 18, 2010 at 2:53 PM, Richard Huxton wrote:
> On 17/02/10 15:18, Amitabh Kant wrote:
>
>>
>> CREATE OR REPLACE FUNCTION update_data() RETURNS TRIGGER AS $update_data$
>> BEGIN
>> IF NEW.t1f4> t2.t2f4
>> UPDATE t2 set t2f2=NEW.t1f2, t2f3=NEW.t1f3, t2f4=NEW.t1f4 where
>> t2f
On 17/02/10 15:18, Amitabh Kant wrote:
CREATE OR REPLACE FUNCTION update_data() RETURNS TRIGGER AS $update_data$
BEGIN
IF NEW.t1f4> t2.t2f4
UPDATE t2 set t2f2=NEW.t1f2, t2f3=NEW.t1f3, t2f4=NEW.t1f4 where
t2f1=NEW.d1;
RETURN NEW;
END IF;
END;
$update_data$ LANGUAGE pl
