Re: Problem with plpgsql TRIGGER

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?