I'm new here in this group... and I hope that I find the solution for my
I wrote a simple function which looks like this:
CREATE OR REPLACE FUNCTION watchdog() RETURNS TIME AS '
PERFORM * FROM watchdog_ctl;
IF NOT FOUND THEN
' LANGUAGE plpgsql;
That means that I want to leave the loop if there isn't an entry in the
table watchdog_ctl. This works fine if the table is empty at the startup of
the function (select watchdog();). But if I empty the table watchdog_ctl
while the function is running it seems to be an endless loop. Hay anyone of
you an idea why??
pgsql-admin by date
|Next:||From: Thanh Q Lam||Date: 2005-07-12 18:59:27|
|Subject: How to list user accounts?|
|Previous:||From: Colton Smith||Date: 2005-07-12 13:56:06|
|Subject: query concerning vacuum and tablespaces|