mercredi 27 mai 2015

Drop table ignoring dependencies in PostgreSQL?

Is there any way at all to drop a table in PostgreSQL ignoring dependencies (not using CASCADE)?

I'm attempting to drop and recreate a table in order to add an IDENTITY column (as there seems to be no other way to do this in AWS Redshift), but I've got views that are dependent on the table.

I obviously don't want to have to temporarily modify every dependent view just so that I can drop and recreate the same table with an added column.




Aucun commentaire:

Enregistrer un commentaire