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



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIIzGeATb/zqfZUUQRAkKmAKCWyYY1ur+Oi0cp0O+9ZFP58FdhBgCfVh3u
YTkh3nzTUkfQ735LL/SwXXk=
=mT++
-----END PGP SIGNATURE-----