On Wed, 2002-08-14 at 13:09, Raymond Chui wrote:
> Let say I have a table has column1 and column2 and I made a trigger for
> after INSERT OR UPDATE for each row to execute procedure my_function.
>
> What I want is the trigger execute my_function only when column1 is
> insert or
> update, but not
On 21 Aug 2002, Robert Treat wrote:
> On Tue, 2002-08-20 at 22:15, Mark Stosberg wrote:
> >
> > Hello Darrin,
> >
>
> >
> > I've been happy with this solution. I think the Perl turned out to be
> > fairly easy to understand and maintain, the SQL that needs to be used
> > ends up being fairly str
On Tue, 2002-08-20 at 22:15, Mark Stosberg wrote:
>
> Hello Darrin,
>
>
> I've been happy with this solution. I think the Perl turned out to be
> fairly easy to understand and maintain, the SQL that needs to be used
> ends up being fairly straightforward, and the performance is good
> because
On Wed, 21 Aug 2002, Andreas Johansson wrote:
> Hi all,
>
> I have a slight problem using triggers and functions in PostGreSQL. I'm
> currently running PostGreSQL 7.2.1 on a RedHat 7.2. I've compiled the
> sources (no rpm installation).
>
> I have several different tables and in each table ther
--- Andreas Johansson <[EMAIL PROTECTED]> >
> ERROR: CreateTrigger: function fix_status() does
> not exist
Andreas :
>
> Why doesn't the trigger acknowledge that I want to
> call fix_status with a
> parameter for which table name I should use?
>
> I'm completely stuck and I someone out there
Hi all,
I have a slight problem using triggers and functions in PostGreSQL. I'm
currently running PostGreSQL 7.2.1 on a RedHat 7.2. I've compiled the
sources (no rpm installation).
I have several different tables and in each table there's a status flag
that's telling if a row is deleted or not (
