X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DD5A453D84 for ; Mon, 9 May 2005 09:51:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10802-08 for ; Mon, 9 May 2005 12:51:03 +0000 (GMT) Received: from mail.cosmoline.gr (mail.cosmoline.gr [217.69.10.77]) by svr1.postgresql.org (Postfix) with ESMTP id 2E5CA53DAB for ; Mon, 9 May 2005 09:51:02 -0300 (ADT) Received: from mailhub.cosmoline.gr (mailhub-c.cosmoline.gr [217.69.0.250]) by mail.cosmoline.gr (8.12.3/8.12.3/COSMOLINE) with ESMTP id j49CpSfE031289 for ; Mon, 9 May 2005 15:51:28 +0300 Received: from cosmoline.com ([192.168.198.171]) (authenticated bits=0) by mailhub.cosmoline.gr (8.12.3/8.12.3/COSMOLINE) with ESMTP id j49Cn6jo004082 for ; Mon, 9 May 2005 15:49:06 +0300 Message-ID: <427F5CB5.2010507@cosmoline.com> Date: Mon, 09 May 2005 15:51:01 +0300 From: Vasilis Ventirozos User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: thats funny :) References: <427F4446.8030808@cosmoline.com> <20050509124229.GA42559@winnie.fuhr.org> In-Reply-To: <20050509124229.GA42559@winnie.fuhr.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/88 X-Sequence-Number: 17517 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. > > >