pg_index question

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_index question
Date: 2005-03-25 21:10:59
Message-ID: 200503251610.59552.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

If I were to set the value of pg_class.indisunique on a unique index to False
inside a transaction so I could juggle sequence numbers around on a table
with a unique two element index, and then set it back again to its proper
value, all in the same transaction, would that allow me to temorarily
override the unique index behavior? Is it safe to temporarily change the
value of that column?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2005-03-25 21:30:31 Re: pg_index question
Previous Message Ragnar Hafstað 2005-03-25 20:07:57 Re: sort array optimisation in pl/perl