Umm, I tried it and it worked. Sure you got the right relid? On Fri, 2005-03-25 at 15:30, Terry Lee Tucker wrote: > To answer my own question, "No it won't work." I still get a unique > constraint > error. > > On Friday 25 March 2005 04:10 pm, Terry Lee Tucker saith: > > 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? > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
