On Tue, Dec 28, 2010 at 9:43 AM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:
Isn't it a requirement that the FKey referenced columns be UNIQUE or PRIMARY KEY'd already?
Regards,
-- Gurjeet Singh <singh.gurjeet@xxxxxxxxx> wrote:For that matter, is there a unique index (directly or as the result
> how many rows does "bbb" have? And what are the data types of
> column aaa.idand bbb.topic_id?
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.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet
Mail sent from my BlackLaptop device