Re: How to deactivate FK's to reorder fields in table?

On 13/10/2009 20:17, Andre Lopes wrote:

> I need to reorder fields in one table. But the database don't let me do this
> action because the FK's pointing to the table. How can I deactivate the
> FK's?

You can't reorder columns in PostgreSQL, so I'm guessing that you're
trying to drop and re-creating the table, and begin prevented from doing
so by FK dependencies from other tables - would that be correct?

If so, you can just drop the FKs and recreate them afterwards.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------