Calling a plpgsql function using a trigger in pgadmin III - Mailing list pgsql-novice

From Jonathan Montgomery
Subject Calling a plpgsql function using a trigger in pgadmin III
Date
Msg-id 20030919141542.M39789@thebreeze.ca
Whole thread Raw
List pgsql-novice

Hi folks:

I'm very new to postgresql/pgadmin and having some trouble.  Let me try to
explain what I'm doing:

I have a function under 'Functions' which takes one text argument.  I want to
add a trigger in one of my tables to call it.

Under that table I right-click Triggers and click Create, and I suppose this
is the point where I'm lost.

In the properties window that comes up there's a dropdown box for a trigger
function, and it's empty.  So I create a new function under the 'Trigger
functions' branch, and the dropdown box is still empty.

I'm sure this is a real newbie question.  Can anyone give me some guidance?

Thanks.


pgsql-novice by date:

Previous
From: santoso berkah
Date:
Subject: Re: How to set up postgres user
Next
From: "Balazs Wellisch"
Date:
Subject: Postgresql startup script on RH9