| Lists: | pgsql-general |
|---|
| From: | "Thomas LeBlanc" <thomasatiem(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Does an index get create for a Primary Key? |
| Date: | 2004-03-31 21:39:01 |
| Message-ID: | BAY17-F33gKqRaUE1rl000276e6@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Does an index get created for a Primary Key or is it just a constraint?
Thanks,
ThomasLL
_________________________________________________________________
Free up your inbox with MSN Hotmail Extra Storage. Multiple plans available.
http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/
| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Thomas LeBlanc <thomasatiem(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Does an index get create for a Primary Key? |
| Date: | 2004-03-31 22:52:13 |
| Message-ID: | 20040331225212.GO30378@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Wed, Mar 31, 2004 at 03:39:01PM -0600, Thomas LeBlanc wrote:
> Does an index get created for a Primary Key or is it just a constraint?
Yes, an unique btree index.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)