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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse sfpug by date

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