0
BimaAdi
3y

have you ever experienced this in postgresql? Remove unique constraint in table, end up remove all data on table. My friend experience this issue this morning. Is it possible? or due my friend clumsiness?

Comments
  • 0
    Which version ?
    But ye, pretty sure it's his fault, I don't have this issue
  • 0
    @Lyniven Postgresql 13
  • 0
    Droping a constraint shouldn't affect data...
    He must've dropped something else, or possibly erase rows that had a Cascade Delete rule...
  • 0
    Not really

    Unless he used a UI it's impossible

    DDL is ALTER TABLE <...> DROP CONSTRAINT <...>

    This is far away from TRUNCATE <...>
Add Comment