Re: [GENERAL] declare constraint as valid

2013-10-12 Thread Michael Paquier
On Thu, Oct 10, 2013 at 3:44 AM, Torsten Förtsch wrote: > Hi, > > assuming a constraint is added to a table as NOT VALID. Now I know it IS > valid. Can I simply declare it as valid by > > update pg_constraint >set convalidated='t' > where conrelid=(select c.oid >from pg_cl

[GENERAL] declare constraint as valid

2013-10-09 Thread Torsten Förtsch
Hi, assuming a constraint is added to a table as NOT VALID. Now I know it IS valid. Can I simply declare it as valid by update pg_constraint set convalidated='t' where conrelid=(select c.oid from pg_class c join pg_namespace n on (n.oid=c.relnamespace)