Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0E7D39FC175
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 24 Oct 2007 08:55:03 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 53733-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 24 Oct 2007 08:54:59 -0300 (ADT)
X-Greylist: delayed 08:44:50.433725 by SQLgrey-1.7.5
Received: from fallbackmx03.syd.optusnet.com.au
	(fallbackmx03.syd.optusnet.com.au [211.29.133.136])
	by postgresql.org (Postfix) with ESMTP id AD7DE9FBEDC
	for <pgsql-sql@postgresql.org>; Wed, 24 Oct 2007 08:54:57 -0300 (ADT)
Received: from mail34.syd.optusnet.com.au (mail34.syd.optusnet.com.au
	[211.29.133.218])
	by fallbackmx03.syd.optusnet.com.au (8.12.11.20060308/8.12.11) with
	ESMTP id l9O3AUvA032307
	for <pgsql-sql@postgresql.org>; Wed, 24 Oct 2007 13:10:30 +1000
Received: from [127.0.0.1] (online4-new.lnk.telstra.net [139.130.169.227])
	(authenticated sender plengada@optusnet.com.au)
	by mail34.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id
	l9O3A271000366
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Wed, 24 Oct 2007 13:10:05 +1000
Message-ID: <471EB767.5040009@autoledgers.com.au>
Date: Wed, 24 Oct 2007 11:09:27 +0800
From: Paul Lambert <paul.lambert@autoledgers.com.au>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Quick question re foreign keys.
References: <471EA7D5.9040403@autoledgers.com.au>
	<21715.1193193880@sss.pgh.pa.us>
	<471EB55F.5050600@autoledgers.com.au>
In-Reply-To: <471EB55F.5050600@autoledgers.com.au>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/106
X-Sequence-Number: 29478

Paul Lambert wrote:
> 
> It's marked not null as a result of being part of the primary key for 
> that table which I can't really get around.
> 
> I can get away with not having the foreign key though, so I'll have to 
> go down that path.
> 
> Cheers,
> P.
> 

Ignore this whole thread actually.

I need to rethink some of my design.

-- 
Paul Lambert
Database Administrator
AutoLedgers