Re: [GENERAL] Explicit Named Indexes for Constraints

2007-10-21 Thread Tom Lane
"Jeff Larsen" <[EMAIL PROTECTED]> writes: > 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, exce

[GENERAL] Explicit Named Indexes for Constraints

2007-10-21 Thread Jeff Larsen
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 i