plpsql function problem

From: drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu
To: pgsql-sql(at)postgresql(dot)org
Subject: plpsql function problem
Date: 2005-01-05 19:45:21
Message-ID: Pine.LNX.4.61.0501052037070.20666@mazsola.iit.uni-miskolc.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-01-05 20:53:16 Re: plpsql function problem
Previous Message Kretschmer Andreas 2005-01-05 16:28:37 Re: Calling a table residing in another database from Plpgsql