Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id B7B0F2E003E for ; Wed, 2 Apr 2008 20:24:02 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50483-10 for ; Wed, 2 Apr 2008 20:23:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by developer.postgresql.org (Postfix) with ESMTP id 81B902E003D for ; Wed, 2 Apr 2008 20:23:57 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m32NNwG04873 for pgsql-www@postgresql.org; Wed, 2 Apr 2008 19:23:58 -0400 (EDT) From: Bruce Momjian Message-Id: <200804022323.m32NNwG04873@momjian.us> Subject: Advertizing email footers To: PostgreSQL www Date: Wed, 2 Apr 2008 19:23:58 -0400 (EDT) X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/3 X-Sequence-Number: 14751 I just noticed this email from a Yahoo user has a Blockbuster advertisement. I just sent a test email from my Yahoo account to myself and it had an advertisement too. Is this a growing trend? I guess my signature has advertizing too, but at least I control it. --------------------------------------------------------------------------- ----- Forwarded message from chester c young ----- it appears I have a broken RI in my db. call_individual.clh_id references call_household.clh_id \d call_individual ... Foreign-key constraints: "call_individual_clh_id_fkey" FOREIGN KEY (clh_id) REFERENCES call_household(clh_id) ON DELETE CASCADE however: development=# select clh_id from call_individual cli where not exists( select 1 from call_household clh where clh.clh_id=cli.clh_id ); clh_id -------- 14691 should not matter, but call_individual has a pre-delete trigger that simply raises an exception to prevent deletions: raise exception 'calls may not be deleted'; ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ----- End of forwarded message from chester c young ----- -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +