Thanks Tom.
One never knows until he asks...
On Friday 25 March 2005 06:36 pm, Tom Lane saith:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > Umm, I tried it and it worked. Sure you got the right relid?
>
> I think the relation cache will probably not notice a manual update on
> pg_index. So w
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Umm, I tried it and it worked. Sure you got the right relid?
I think the relation cache will probably not notice a manual update on
pg_index. So whether it "works" or not would depend on a lot of
extraneous factors like whether the relation cache entry
Well, I think I had the right oid, but I agree with you. I think I have a
better solution than this. I think I real try it once more though. I must
have done something wrong.
Thanks for the reply :o)
On Friday 25 March 2005 04:53 pm, Scott Marlowe saith:
> Umm, I tried it and it worked. Sure y
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
On Fri, 2005-03-25 at 15:10, Terry Lee Tucker wrote:
> 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
>
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
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 temora
