Server crash occur and corrupt the database when deleting data from a table when table have multiple triggers, functions defined.

[shahidullah79]

Create a database and populate it with the attached sql file which has different tables, functions, triggers etc defined. Now try to delete data from emp table. e.g. delete from emp where mgr=7698;

A server crash will occur. delete from emp where mgr=7698; INFO: Deleting employee 7499 INFO: ..Old salary: 1600.00 INFO: Deleting employee 7521 INFO: ..Old salary: 1250.00 INFO: Deleting employee 7654 INFO: ..Old salary: 1250.00 INFO: Deleting employee 7844 INFO: ..Old salary: 1500.00 server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. The connection to the server was lost. Attempting reset: Failed.

It will also corrupt the database and no other functionality will work on this database.

Here is the sql file. pg_tde-sample.log

[shahidullah79]

Server Log file postgresql-Tue.log