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

Re: Type incompatibilities converting char to uuid

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
Cc: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: Type incompatibilities converting char to uuid
Date: 2008-12-18 01:35:44
Message-ID: 4949A8F0.9040502@agliodbs.com (view raw or flat)
Thread:
Lists: sfpug
Brian,

You can drop and recreate the FKs inside a transaction.  That would be 
my suggestion.

Drop FKs
Convert to UID on table A
Convert to UID on table B
Replace FKs.

--Josh

In response to

sfpug by date

Next:From: Dirk JagdmannDate: 2008-12-18 06:52:35
Subject: Re: Type incompatibilities converting char to uuid
Previous:From: Brian GhidinelliDate: 2008-12-16 23:59:32
Subject: Type incompatibilities converting char to uuid

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