Explicit Named Indexes for Constraints

From: "Jeff Larsen" <jlar310(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Explicit Named Indexes for Constraints
Date: 2007-10-21 18:24:44
Message-ID: d1f9b6f00710211124h729b1aachba527026a2eff848@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm new to PosgtreSQL, a veteran with Informix. We are considering a migration.

In Informix, it is recommended to create explicit named indexes on
columns for primary and foreign keys prior to creating the
constraints. Otherwise, the server create the indexes for you with
meaningless names. This is not generally a problem, except when you
dump the schema, you get all the constraint indexes in the DDL,
exported as if they were explicitly created, but with the server
generated names. It's a mess to sort through.

What's the recommended procedure in PG? At first glance it appears
that PG hides the implicit indexes from you at all times, including
pg_dump. So it appears that explicit index creation can be skipped
without leaving you with a mess later. Is this just a non-issue in PG?

Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rainer Bauer 2007-10-21 19:43:27 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Scott Marlowe 2007-10-21 17:05:55 Re: keeping an index in memory