phpbb\search\fulltext_postgres::create_index PHP Method

    public function create_index($acp_module, $u_action)
    {
        // Make sure we can actually use PostgreSQL with fulltext indexes
        if ($error = $this->init()) {
            return $error;
        }
        if (empty($this->stats)) {
            $this->get_stats();
        }
        if (!isset($this->stats['post_subject'])) {
            $this->db->sql_query("CREATE INDEX " . POSTS_TABLE . "_" . $this->config['fulltext_postgres_ts_name'] . "_post_subject ON " . POSTS_TABLE . " USING gin (to_tsvector ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', post_subject))");
        }
        if (!isset($this->stats['post_content'])) {
            $this->db->sql_query("CREATE INDEX " . POSTS_TABLE . "_" . $this->config['fulltext_postgres_ts_name'] . "_post_content ON " . POSTS_TABLE . " USING gin (to_tsvector ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', post_text || ' ' || post_subject))");
        }
        $this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);
        return false;
    }