Hi Robert
I try to get rid of all of my constraints. I do not go into details but it has to do with parsing the SBB (Swiss federal railways) timetable. And I was as usual when I get back to pgAdmin from SybaseCentral a bit annoyed about the lack functionality (compared to SybaseCentral).
Same is true if you like to get rid of all indexes etc. Why? Because for me it's easy to generate out of the data model all constraints or indexes and apply them, quick and easy in SybaseCentral, time consuming in pgAdmin. I know you don't like to hear that, but there are so many more things with pgAdmin, we can discuss them may be next time at ServoyCamp
On the other hand, Postgres was at a time the only (Open Source) database handling GIS (PostGIS) which we needed. Today it's a different world.
Thumb up for pgAdmin it looks much better as SybaseCentral .-)
Regards, Robert
ROCLASI wrote:Hi Robert,
What are you trying to do exactly ? Why do you want/need to drop the constraints ?
If you need to defer your constraints until, lets say, the end of transaction you can use the
set constraints command.
Dropping a constraint can only be done by altering a table. So you
need to do this per table. I am not sure pgAdmin (or any other DBA tool for that matter) has a function to select multiple tables and do this.