Re: Problem with UNIQUE constraint on two columns

On Sun, May 24, 2015 6:17 pm, Fred Toussi wrote:
> You have a primary key on the user_id column of the user_public_keys
> table. Therefore you cannot insert more than one row containing 'u0'.
>
> I think your intention is to have multiple user_public_key rows per
> user. In this case, remove the PRIMARY KEY constraint from this table.

... Oops.

Thank you, I've no idea how I managed to miss that.




------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y