Pallav Kalva <[EMAIL PROTECTED]> writes:
>> begin;
>> alter table common.string drop constraint pk_string_stringid;
>> explain analyze ... same query ...
>> rollback;
>        what do u mean by rollback exactly ? i can drop the pk constraint 
> and run explain analyze and see how it behaves.

The point of the rollback is that you don't really make the pk
constraint go away.  It is gone from the perspective of the EXPLAIN,
but after you rollback it's back again.  Easier than rebuilding it...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to