Re: unique constraint
Re: unique constraint
- Subject: Re: unique constraint
- From: Theodore Petrosky <email@hidden>
- Date: Fri, 30 Mar 2012 18:25:25 -0700 (PDT)
I must have been in a weird state as the dialog for creating the Distinct setting was not showing up.
But we are working fine (and I also use postgresql so I project no problems)
Ted
--- On Fri, 3/30/12, Paul Hoadley <email@hidden> wrote:
> From: Paul Hoadley <email@hidden>
> Subject: Re: unique constraint
> To: "Theodore Petrosky" <email@hidden>
> Cc: email@hidden
> Date: Friday, March 30, 2012, 8:37 PM
> Hi Ted,
>
> On 31/03/2012, at 5:48 AM, Theodore Petrosky wrote:
>
> > Is there a way to put a unique constraint on an
> attribute in Entity Modeler and have it create the
> migrations. I don't see anything in any of the menus.
>
> 1. Right-click entity, select "New Entity Index".
>
> 2. Give the index a name, select "Distinct" for
> Constraint, select the attribute in the drop-down at the
> bottom and click "Add".
>
> 3. Generate migration.
>
> Whether this works might be database-plugin-dependent, but I
> can vouch for PostgreSQL. It should generate something
> like this:
>
> personTable.addIndex(new
> ERXMigrationIndex("person_username_key", true, new
> ColumnIndex("username")));
>
>
> --
> Paul.
>
> http://logicsquad.net/
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden