How to change table limit on shutdown in postgresql?

Question

I have this simple contrast on my sales table CONSTRAINT sales_stamping_id_key UNIQUE (company_id, stamping_id, invoice_number, invoiced) and I cannot find a way to change this disconnect constraint without removing the constraint. Is there any way to do this?

Answer 1

You can change the unique constraint as follows:

alter table foo add constraint bar_idx unique using index bar_idx deferrable;

http://www.postgresql.org/docs/current/static/sql-altertable.html