How to use composite unique trigger in postgres

Question

how to use composite Unique using trigger I have one column user_id and service_id i want to restrict duplicate records in user_id according to service_id means ie for service_id=1 all records should be unique in user_id all by trigger

Gary - Stand with Ukraine · Accepted Answer · 2016-05-12 08:13:04Z

1

You don't need a trigger for this. A Unique constraint on multiple columns would do it.

ALTER TABLE tab ADD UNIQUE (service_id, user_id);

Docs at: http://www.postgresql.org/docs/current/static/ddl-constraints.html

answered May 12, 2016 at 8:13

Gary - Stand with Ukraine

7,6291 gold badge33 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Manish chand Over a year ago

I know this but i have to us it in trigger

Manish chand Over a year ago

I want unique for only for one service constraint on multiple columns will restrict all services

Collectives™ on Stack Overflow

How to use composite unique trigger in postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related