i know what the trigger does, i writed it :) i dont have a problem , i already fixed the function to work nice and smooth i just sent it for fun, anyway no problem about the subject
[Please use a descriptive subject -- "thats funny :)" conveys no information about the problem, and it resembles subjects seen on some viruses.]
On Mon, May 09, 2005 at 02:06:46PM +0300, Vasilis Ventirozos wrote:
hi all i created a function that restarts the server, i will show you what i am doing
The trigger function you posted is called whenever you insert a record into the favorites table, then the function inserts a record into favorites, which calls the trigger, which inserts a record, which calls the trigger, etc. Infinite recursion.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org