Re: Unique values on multiple tables

From: Emre Hasegeli <emre(at)hasegeli(dot)com>
To: Sterpu Victor <victor(at)caido(dot)ro>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unique values on multiple tables
Date: 2016-03-28 10:44:51
Message-ID: CAE2gYzwREik_SQMKtALg+tAT=BXQNvvPfiPt4RQMwGNc8OmT1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Could I use lock tables to fix this? Is postgres automaticaly locking a
> table while running a trigger on that table?

You can use LOCK TABLE. See the documentation:

http://www.postgresql.org/docs/current/static/explicit-locking.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roman Scherer 2016-03-28 11:36:19 How to quote the COALESCE function?
Previous Message Sterpu Victor 2016-03-28 10:16:26 Re: Unique values on multiple tables