Обсуждение: Problem with plpgsql TRIGGER

Hi there !

I have one strange problem with pgsql and pl/pgsql in deleteing data by
trigger.

The data is uploaded from mssql via DTS to the first table.

On that event the trigger is called and parting data into two cascade
referencing tables.

Everything is OK till I am going to update data.

the trigger should do sth like this:
DELETE * from table1 -- in that case all data from table2 are deleted too.
INSERT into table1
INSERT into table2

but... it wont go :/

If there is any record (id = NEW.id) postgres is calling about refereces
... well it should be deleted in the first step of trigger.

Does any one of you had sth. simmilar, please let me know.

Matwiej

On Fri, 17 Jan 2003, Maciej Fuchs wrote:

> Hi there !
>
> I have one strange problem with pgsql and pl/pgsql in deleteing data by
> trigger.
>
> The data is uploaded from mssql via DTS to the first table.
>
> On that event the trigger is called and parting data into two cascade
> referencing tables.
>
> Everything is OK till I am going to update data.
>
> the trigger should do sth like this:
> DELETE * from table1 -- in that case all data from table2 are deleted too.
> INSERT into table1
> INSERT into table2
>
> but... it wont go :/
>
> If there is any record (id = NEW.id) postgres is calling about refereces
> ... well it should be deleted in the first step of trigger.
>
> Does any one of you had sth. simmilar, please let me know.

What version are you using and what do the actual table definitions look
look like?