Re: [GENERAL] starting a stored procedure+rule AFTER an insert

[Bima Djaloeis]

Thanks for the reply, is there any online reference / tutorial for this?

-BD

2007/10/8, Douglas McNaught <[EMAIL PROTECTED]>:
>
> "Bima Djaloeis" <[EMAIL PROTECTED]> writes:
>
> > I have implemented a stored procedure that writes out the newest DB
> > entry on insert, and combined it with a rule.
> >
> > 1) create function newcache() returns void AS 'newCache', 'newCache'
> language
> > c;
> > 2) create rule newcacherule AS on insert to caches do also select
> newcache();
> >
> > The problem is that newcacherule fires BEFORE the insert has taken
> > place, so effectively, I always just get the 2nd newest entry to
> > write into my text file while the newest entry is "stuck in the
> > queue" until a new insert come. How can I execute my rule AFTER the
> > insert has taken place?
>
> Rules effectively happen at query parse time.  You probably want an
> AFTER trigger instead.
>
> -Doug
>

[GENERAL] starting a stored procedure+rule AFTER an insert

[Bima Djaloeis]

Hi, Newbie here,

I have implemented a stored procedure that writes out the newest DB entry on
insert, and combined it with a rule.

1) create function newcache() returns void AS 'newCache', 'newCache'
language c;
2) create rule newcacherule AS on insert to caches do also select
newcache();

The problem is that newcacherule fires BEFORE the insert has taken place, so
effectively, I always just get the 2nd newest entry to write into my text
file while the newest entry is "stuck in the queue" until a new insert come.
How can I execute my rule AFTER the insert has taken place?

Thanks for reading!

[GENERAL] ON INSERT => execute AWK/SH/EXE?

[Bima Djaloeis]

Hi there,

I am new to PostgreSQL, is it possible to create something so that

1) If I insert / update / delete an item from my DB...
2) ... an awk / shell / external program is executed in my UNIX System?

If yes, how do I do this and if no, thanks for telling.

Thanks for reading, any help is appreciated.