row not deleted but updated (trigger?)

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема row not deleted but updated (trigger?)
Дата
Msg-id 20090227125606.73d48d8e@dawn.webthatworks.it
обсуждение исходный текст
Ответы Re: row not deleted but updated (trigger?)  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Re: row not deleted but updated (trigger?)  ("Igor Neyman" <ineyman@perceptron.com>)
Список pgsql-sql
I've:

create or replace function FT1IDX_catalog_brands_update() returns
trigger as $$
begin
if(TG_OP='DELETE') then update catalog_items set   FT1IDX=GetFTIDX('pg_catalog.english', Code, CodeAlt, ISBN, Name,
Authors,'')     where BrandID=old.BrandID;
 
else if(coalesce(new.Name,'')<>coalesce(old.Name,'')) then   update catalog_items set
FT1IDX=GetFTIDX('pg_catalog.english',Code, CodeAlt, ISBN,       Name, Authors, new.Name)        where
BrandID=new.BrandID;end if;
 
end if;
return new;
end $$ language plpgsql volatile;

create trigger FT1IDX_catalog_brands_update_trigger before update or
delete on catalog_brands for each row execute procedure
FT1IDX_catalog_brands_update();

I do something
update catalog_brands set name='zzz' where brandid=1234;
1 row get updated.

When I do
delete from catalog_brands where brandid=1234;
no row get deleted and no error get reported.

what did I miss?

thanks

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it



В списке pgsql-sql по дате отправления:

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: Best practices for geo-spatial city name searches?
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: row not deleted but updated (trigger?)