Re: Type incompatibilities converting char to uuid

Dirk Jagdmann wrote:
>> I'm trying not to delete and recreate all of my foreign keys if I can
>> help it for simplicity sake... any suggestions otherwise?
>
> Not really, but what is the problem with droping the foreign key
> constraint before column conversion? Do you have GB of UUIDs stored and
> fear that the index recreation might take long?

Well my test case is simple but in reality I have 75 tables with a
considerable number of foreign keys. I can probably dump the schema and
grep out those definitions or use the system tables to find them all but
I was looking for the easy way out. :)

I may wait for 8.4 which will eliminate the need to make changes in my
application since my char(35) input will be natively understood. Then I
can run this transaction/drop/alter/recreate/commit.

Thanks for the input guys!

Brian