On 16/05/2007 05:09, camb wrote:
> I'm sorta new to PG and am just wondering, when I create a foreign key
> is it automatically set as an indexed column or do I need to also set
> that manually?
AFAIK you need to create the index separately. I use PgAdmin most of the
time, which does that by default, so I'm a bit hazy on doing it by hand.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------