X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 74787DB05B for ; Tue, 22 Nov 2005 12:10:43 -0400 (AST) 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 66692-10-3 for ; Tue, 22 Nov 2005 16:10:41 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.193]) by svr1.postgresql.org (Postfix) with ESMTP id BE43DDAFFA for ; Tue, 22 Nov 2005 12:10:40 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so951733nzo for ; Tue, 22 Nov 2005 08:10:38 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Z8IzPPI7Yx+CzNFBt5msqx4ffNRsrNYb/UL73eyv4r3Z03hv/Fi57mJfOjZxehdC/UyWDNCX6qsPm6KpcNePhMky7Xeorv/av21tEW5vYB/Vax4bzT9RzPzI0t8jOt+H9CIzYwsi4JDdBIo3pTQn6oVXRAIe/jsj9aS8wuAV+sI= Received: by 10.65.250.10 with SMTP id c10mr4741663qbs; Tue, 22 Nov 2005 08:10:38 -0800 (PST) Received: by 10.65.224.16 with HTTP; Tue, 22 Nov 2005 08:10:38 -0800 (PST) Message-ID: Date: Tue, 22 Nov 2005 16:10:38 +0000 From: Neil Saunders To: "Leif B. Kristensen" Subject: Re: Triggers Cc: pgsql-sql@postgresql.org In-Reply-To: <200511221644.35656.leif@solumslekt.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-7 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <200511221644.35656.leif@solumslekt.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/202 X-Sequence-Number: 23453 VHJ5OgoKY3JlYXRlIG9yIHJlcGxhY2UgZnVuY3Rpb24gdXBkYXRlX2xhc3RfZWRpdCgpIHJldHVy bnMgdHJpZ2dlciBhcwokJApiZWdpbgpuZXcubGFzdF9lZGl0PW5vdygpOwpyZXR1cm4gbmV3Owpl bmQ7CiQkIGxhbmd1YWdlIHBscGdzcWw7CgpPbiAxMS8yMi8wNSwgTGVpZiBCLiBLcmlzdGVuc2Vu IDxsZWlmQHNvbHVtc2xla3Qub3JnPiB3cm90ZToKPiBPbiBUdWVzZGF5IDIyIE5vdmVtYmVyIDIw MDUgMTc6MjUsIEFjaGlsbGV1cyBNYW50emlvcyB3cm90ZToKPiA+TyBMZWlmIEIuIEtyaXN0ZW5z ZW4g3ePx4fjlIPP06fIgTm92IDIyLCAyMDA1IDoKPiA+PiBJJ20gdHJ5aW5nIHRvIHVuZGVyc3Rh bmQgdHJpZ2dlcnMuIEkgaGF2ZSByZWFkIHRoZSBkb2N1bWVudGF0aW9uIGluCj4gPj4gdGhlIG1h bnVhbCBhcyB3ZWxsIGFzIHRoZSBmZXcgcGFnZXMgaW4gdGhlIERvdWdsYXMgYm9vayBhYm91dCB0 aGUKPiA+PiBzdWJqZWN0LCBidXQgSSBkb24ndCBzZWUgaG93IHRvIGltcGxlbWVudCBhIHRyaWdn ZXIgdGhhdCBzaW1wbHkKPiA+PiB1cGRhdGVzIGEgJ2xhc3RfZWRpdCcgZGF0ZSBmaWVsZCBpbiBt eSAncGVyc29ucycgdGFibGUgd2hlbmV2ZXIgSSBkbwo+ID4+IGFuIGluc2VydCBvciB1cGRhdGUg aW50byBteSAncGFydGljaXBhbnRzJyB0YWJsZTsgdGhhdCBpcyBhIHRyaWdnZXIKPiA+PiB0aGF0 IGJhc2ljYWxseSBkb2VzIGFuICJVUERBVEUgcGVyc29ucyBTRVQgJ2xhc3RfZWRpdCcgPSBOT1co KSBXSEVSRQo+ID4+IHBlcnNvbnMucGVyc29uX2lkID0gcGFydGljaXBhbnRzLnBlcnNvbl9mayIu IElzIHRoYXQgZXZlbiBwb3NzaWJsZT8KPiA+Cj4gPnNtdGggbGlrZToKPiA+Zm9vZGI9IyBDUkVB VEUgb3IgUkVQTEFDRSBGVU5DVElPTiB1cGRfZGFkKCkgUkVUVVJOUyAidHJpZ2dlciIgQVMgJwo+ ID5mb29kYicjIEJFR0lOCj4gPmZvb2RiJyMgVVBEQVRFIGRhZCBzZXQgbGFzdGVkaXQ9bm93KCkg d2hlcmUgaWQ9bmV3LmRhZGlkOwo+ID5mb29kYicjIFJFVFVSTiBuZXc7Cj4gPmZvb2RiJyMgRU5E Owo+ID5mb29kYicjICcKPiA+Zm9vZGItIyBMQU5HVUFHRSBwbHBnc3FsOwo+ID5DUkVBVEUgRlVO Q1RJT04KPiA+Zm9vZGI9IyBDUkVBVEUgVFJJR0dFUiB1cGRfZGFkX3RnIEFGVEVSIElOU0VSVCBP UiBVUERBVEUgT04ga2lkIEZPUgo+ID4gRUFDSCBST1cgRVhFQ1VURSBQUk9DRURVUkUgdXBkX2Rh ZCgpOwo+Cj4gbGVpZj0+IGNyZWF0ZSBvciByZXBsYWNlIGZ1bmN0aW9uIHVwZGF0ZV9sYXN0X2Vk aXQoKSByZXR1cm5zIHRyaWdnZXIgYXMKPiAkJAo+IGxlaWYkPiBiZWdpbgo+IGxlaWYkPiB1cGRh dGUgcGVyc29ucyBzZXQgbGFzdF9lZGl0PW5vdygpIHdoZXJlIHBlcnNvbl9pZD1uZXcucGVyc29u X2ZrOwo+IGxlaWYkPiByZXR1cm4gbmV3Owo+IGxlaWYkPiBlbmQ7Cj4gbGVpZiQ+ICQkIGxhbmd1 YWdlIHBscGdzcWw7Cj4gQ1JFQVRFIEZVTkNUSU9OCj4gbGVpZj0+IGNyZWF0ZSB0cmlnZ2VyIHVw ZGF0ZV9sYXN0X2VkaXQgYWZ0ZXIgaW5zZXJ0IG9yIHVwZGF0ZSBvbgo+IHBhcnRpY2lwYW50cwo+ IGxlaWYtPiBmb3IgZWFjaCByb3cgZXhlY3V0ZSBwcm9jZWR1cmUgdXBkYXRlX2xhc3RfZWRpdCgp Owo+IENSRUFURSBUUklHR0VSCj4gbGVpZj0+IGluc2VydCBpbnRvIHBhcnRpY2lwYW50cyAocGFy dGljaXBhbnRfaWQscGVyc29uX2ZrKSB2YWx1ZXMgKDEsMSk7Cj4gRVJST1I6ICByZWNvcmQgIm5l dyIgaGFzIG5vIGZpZWxkICJsYXN0X2VkaXQiCj4gQ09OVEVYVDogIFBML3BnU1FMIGZ1bmN0aW9u ICJwcm9jZXNzX2xhc3RfZWRpdGVkIiBsaW5lIDIgYXQgYXNzaWdubWVudAo+IGxlaWY9Pgo+Cj4g V2hhdCBhbSBJIG1pc3Npbmc/Cj4gLS0KPiBMZWlmIEJpYmVyZyBLcmlzdGVuc2VuIHwgUmVnaXN0 ZXJlZCBMaW51eCBVc2VyICMzMzgwMDkKPiBodHRwOi8vc29sdW1zbGVrdC5vcmcvIHwgQ3J1aXNp bmcgd2l0aCBHZW50b28vS0RFCj4KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0oZW5kIG9m IGJyb2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPiBUSVAgMjogRG9uJ3QgJ2tp bGwgLTknIHRoZSBwb3N0bWFzdGVyCj4K