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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
