Skip site navigation (1) Skip section navigation (2)

Re: Type incompatibilities converting char to uuid

From: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: Type incompatibilities converting char to uuid
Date: 2008-12-18 16:09:59
Message-ID: 494A75D7.4040003@pukkasoft.com (view raw or flat)
Thread:
Lists: sfpug
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

In response to

sfpug by date

Next:From: Josh BerkusDate: 2008-12-28 06:24:14
Subject: Meredith in the news
Previous:From: Dirk JagdmannDate: 2008-12-18 06:52:35
Subject: Re: Type incompatibilities converting char to uuid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group