pg_index question - Mailing list pgsql-general

From Terry Lee Tucker
Subject pg_index question
Date
Msg-id 200503251610.59552.terry@esc1.com
Whole thread Raw
Responses Re: pg_index question  (Terry Lee Tucker <terry@esc1.com>)
Re: pg_index question  (Scott Marlowe <smarlowe@g2switchworks.com>)
List 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?

pgsql-general by date:

Previous
From: Ragnar Hafstað
Date:
Subject: Re: sort array optimisation in pl/perl
Next
From: Terry Lee Tucker
Date:
Subject: Re: pg_index question