frontend: pg-only index => pg|sqlite-only index
    
    We don't need to labor on this, as we anyway use PostgreSQL only +
    SQLite for unit-tests.
    
    Also avoid using the main==True construct which confuses PyLint.