Teknokrat, > I need to to change the type of a table column. The problem is that > this > table has a ref integrity constarint set up with another table. Does > > anyone know how I can do this easily without breaking any > constraints.
Easily? No. In sum: dump your database to file. Backup. Edit the file. Re-create and re-load the database. -Josh Berkus ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])