On 9/8/16 4:55 AM, Emre Hasegeli wrote:
> The main problem that has been discussed before was the indexes. One
> way is to tackle with it is to reindex all the tables after the
> operation. Currently we are doing it when the datatype of indexed
> columns change. So it should be possible, but very expensive.
Why not just disallow dropping a value that's still in use? That's
certainly what I would prefer to happen by default...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461