| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Clemens Eisserer <linuxhippy(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Are Indices automatically generated for primary keys? |
| Date: | 2010-08-18 13:54:56 |
| Message-ID: | 20100818135456.GA17355@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Wed, Aug 18, 2010 at 03:51:22PM +0200, Clemens Eisserer wrote:
> Hi,
>
> Are indices for columns marked with "PRIMARY KEY" automatically generated by
> postgresql, or do I have to do it manually?
> The question might seem dumb, I ask because I remember from working with
> MySQL it generates indices automatically in this case.
they are generated automatically.
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-08-18 13:59:34 | Re: Are Indices automatically generated for primary keys? |
| Previous Message | Clemens Eisserer | 2010-08-18 13:51:22 | Are Indices automatically generated for primary keys? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-08-18 13:59:34 | Re: Are Indices automatically generated for primary keys? |
| Previous Message | Clemens Eisserer | 2010-08-18 13:51:22 | Are Indices automatically generated for primary keys? |