Reindex unique constraint with INITIALLY DEFERRED options reset options

grayhemp / pgtoolkit

Tools for PostgreSQL maintenance

Other

184 stars 16 forks source link

Reindex unique constraint with INITIALLY DEFERRED options reset options #10

Open Napolskih opened 9 years ago

Napolskih commented 9 years ago

Hello

There is a table, on the table to create a unique constraint with the options "initially deferred". When processing the table with the option reindex, the constraint reset option "initially deferred".

Constraint was originally created on the basis of the existing unique index using "add constraint using index".

pgcompactor (PgToolkit) v1.0rc1 Pg 9.2

grayhemp commented 9 years ago

Right, this is a bug. Putting it down to my TODO list for the next version. Thanks for your feedback.

Napolskih commented 7 years ago

Maybe fix? :smile:

isqad commented 5 years ago

when?