Re: [HACKERS] Foreign key constraint on sub-column of composite-type column

2012-10-20 Thread Simon Riggs
On 20 October 2012 06:57, David Lee wrote: > I was trying to create foreign key constraints on a sub-column of a > composite-type column, but couldn't find a way to do it. After asking around > on IRC, it seems like this isn't supported in PostgreSQL. > > I wanted to do something like: > >

[HACKERS] Foreign key constraint on sub-column of composite-type column

2012-10-19 Thread David Lee
Hi, I was trying to create foreign key constraints on a sub-column of a composite-type column, but couldn't find a way to do it. After asking around on IRC, it seems like this isn't supported in PostgreSQL. I wanted to do something like: create type profile as (account_id integer);