Explicit Named Indexes for Constraints
От
Jeff Larsen
Тема
Explicit Named Indexes for Constraints
Дата
Msg-id
d1f9b6f00710211124h729b1aachba527026a2eff848@mail.gmail.com
Список
Дерево обсуждения
Explicit Named Indexes for Constraints "Jeff Larsen" <jlar310@gmail.com>
Re: Explicit Named Indexes for Constraints Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-general по дате отправления