Mike,
You are right that postgres out of the box does not provide this solution but
you can still achieve this by:
1. Setup a hot standby server (through WAL logs)
2. When a table is dropped on master at time x, replay the standby server to
time y just before the table was dropped.
3. pg_dump the the table from standby server which was dropped from the master.
4. Restore it back to the master.
The above process is arguably time consuming. However the commercial toolse for
this are also available like potgres iDataAgent and xDB replication server.
Regards:
Ejaz Ahmed
