On Tue, Dec 28, 2010 at 9:43 AM, Kevin Grittner <kevin.gritt...@wicourts.gov > wrote:
> Gurjeet Singh <singh.gurj...@gmail.com> wrote: > > > how many rows does "bbb" have? And what are the data types of > > column aaa.idand bbb.topic_id? > > For that matter, is there a unique index (directly or as the result > of a constraint) on the aaa.id column (by itself)? > > Isn't it a requirement that the FKey referenced columns be UNIQUE or PRIMARY KEY'd already? Regards, -- gurjeet.singh @ EnterpriseDB - The Enterprise Postgres Company http://www.EnterpriseDB.com singh.gurj...@{ gmail | yahoo }.com Twitter/Skype: singh_gurjeet Mail sent from my BlackLaptop device
