On 1/30/18 04:12, Abinaya Kajendiran wrote: > We are building in-memory index extension for postgres. For drop > index query, does postgres notify me through index access methods?
No, the access methods just write into blocks for the file they are told about. The deleting of that file is not handled by the access methods. > Currently, we are using event triggers to capture drop index. If there > is a better way, please do suggest. An event trigger will probably do for now. But you are venturing into uncharted territory, so you will have to find your own best solution. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
