Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5A8F91337B55 for ; Tue, 12 Oct 2010 15:41:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 85710-07 for ; Tue, 12 Oct 2010 18:41:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231]) by mail.postgresql.org (Postfix) with ESMTP id DF3861337B49 for ; Tue, 12 Oct 2010 15:41:41 -0300 (ADT) Received: from in01.mta.xmission.com ([166.70.13.51]) by out01.mta.xmission.com with esmtps (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1P5gvp-0006Qu-BD; Tue, 12 Oct 2010 09:38:25 -0600 Received: from [208.187.158.94] (helo=[172.16.1.223]) by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1P5gYn-0000ZQ-0W; Tue, 12 Oct 2010 09:14:37 -0600 Message-ID: <4CB47B5A.2070001@gmail.com> Date: Tue, 12 Oct 2010 09:14:34 -0600 From: Rob Sargent User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.11) Gecko/20100714 SUSE/3.0.6 Lightning/1.0b1 Thunderbird/3.0.6 MIME-Version: 1.0 To: Gary Chambers CC: pgsql-sql@postgresql.org References: <4CAF79EB.1080606@gmail.com> <4CAF8E64.8010000@gmail.com> <4CAFADAD.7060600@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ; ip=208.187.158.94; ; ; frm=robjsargent@gmail.com; ; ; spf=neutral X-SA-Exim-Connect-IP: 208.187.158.94 X-SA-Exim-Mail-From: robjsargent@gmail.com X-Spam-DCC: XMission; sa05 1397; Body=1 Fuz1=1 Fuz2=1 X-Spam-Combo: ;Gary Chambers X-Spam-Relay-Country: Subject: Re: Duplicates Processing X-SA-Exim-Version: 4.2.1 (built Fri, 06 Aug 2010 16:31:04 -0600) X-SA-Exim-Scanned: Yes (on in01.mta.xmission.com) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.6 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201010/37 X-Sequence-Number: 34688 Gross generalization perhaps, but keep in mind what the over app/system needs of the components. Bounce those off you standard ER modeling instincts and vice versa and you have a chance! On 10/12/2010 08:19 AM, Gary Chambers wrote: > Rob, > > Thanks for your reply! > >> And to your point of self-reference, it would be to a co-worker more >> than a manager. Managers are often not good replacements for workers. :) > > :) Absolutely! > > I was having a conversation over on #postgresql yesterday about this > and, due to my inexperience with managing electronic components (and > some of the database issues involved), I still have a few unanswered > questions. I would like to create a master table of parts derived > from the individual tables (e.g. resistors, capacitors, diodes, etc.). > I have the rare opportunity to build this from the ground, up and > would like to ensure that I get it right. Thanks for any advice that > you (or anyone) can offer. > > -- Gary Chambers