Re: pgsql: Use TRUNCATE to preserve relfilenode for pg_largeobject + index.

On Fri, Jul 29, 2022 at 7:00 AM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
> @ -3167,15 +3168,36 @@ dumpDatabase(Archive *fout)
>
> ....
> appendPQExpBuffer(loOutQry, "UPDATE pg_catalog.pg_class\n"
> - "SET relfrozenxid = '%u', relminmxid = '%u', relfilenode = '%u'\n"
> + "SET relfrozenxid = '%u', relminmxid = '%u'\n"
> "WHERE oid = %u;\n",
> atooid(PQgetvalue(lo_res, i, i_relfrozenxid)),
> atooid(PQgetvalue(lo_res, i, i_relminmxid)),
> - atooid(PQgetvalue(lo_res, i, i_relfilenode)),
> - atooid(PQgetvalue(lo_res, i, i_oid)));
> + atooid(PQgetvalue(lo_res, i, i_relfilenode)));
>
> Is this correct? I mean why are we updating only those tuples where
> oid= i_relfilenode? I think it should use
> atooid(PQgetvalue(lo_res, i, i_oid) in where clause not
> atooid(PQgetvalue(lo_res, i, i_relfilenode)? Or am I missing
> something?

No, that's definitely not correct. Thanks for catching it.

--
Robert Haas
EDB: http://www.enterprisedb.com