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
------------------------------------------------------------------