plpsql function problem - Mailing list pgsql-sql

From drdani@mazsola.iit.uni-miskolc.hu
Subject plpsql function problem
Date
Msg-id Pine.LNX.4.61.0501052037070.20666@mazsola.iit.uni-miskolc.hu
Whole thread Raw
Responses Re: plpsql function problem
List pgsql-sql
Hi,

I'm writing a plpgsql function. There is an insert in it (let's say to 
table1). This insert causes to call a trigger function which inserts 
some info to an other table (let's say table2):

function  .  insert into table1 ...  --> trigger function (runs after insert)                                 .
                       insert into table2 ...  .  select from table2 ... not found  .
 

This info looks to be unavailable inside the function. Can it be made 
availabel or must this whole thing reorgenized?

Daniel


pgsql-sql by date:

Previous
From: Kretschmer Andreas
Date:
Subject: Re: Calling a table residing in another database from Plpgsql
Next
From: Tom Lane
Date:
Subject: Re: plpsql function problem