pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Joshua D. Drake <jd@commandprompt.com>
To: Campbell, Lance <lance@uiuc.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Creating a foreign key
Date: Thu, 8 May 2008 10:00:14 -0700
Message-ID: <20080508100014.1ceaa1f9@jd-laptop> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760CDDD46@SAB-FENWICK.sab.uiuc.edu>
References: <B10E6810AC2A2F4EA7550D072CDE8760CDDD46@SAB-FENWICK.sab.uiuc.edu>

On Thu, 8 May 2008 11:52:50 -0500
"Campbell, Lance" <lance@uiuc.edu> wrote:

> PostgreSQL: 8.2
> 
>  
> 
> When you create a foreign key to a table is there an index that is
> created on the foreign key automatically?

No.

Joshua D. Drake


-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (5+ messages)  latest in thread

Message-ID: <20080508100014.1ceaa1f9@jd-laptop>
Permalink:  ../20080508100014.1ceaa1f9@jd-laptop/
Also on:    postgresql.org/message-id/20080508100014.1ceaa1f9@jd-laptop

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, lance@uiuc.edu
  Subject: Re: Creating a foreign key
  In-Reply-To: <20080508100014.1ceaa1f9@jd-laptop>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox