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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 17 Dec 2008 17:35:44 -0800
  • Message-id: <4949A8F0.9040502@agliodbs.com> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group