Oidpg_type_array_oid;

Oidpg_type_multirange_oid;

Oidpg_type_multirange_array_oid;

TypeInfo *tinfo;

appendPQExpBufferStr(upgrade_buffer, "\n-- For binary upgrade, must preserve pg_type oid\n");

appendPQExpBuffer(upgrade_buffer,

"SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('%u'::pg_catalog.oid);\n\n",

pg_type_oid);

appendPQExpBuffer(upgrade_query,

"SELECT typarray "

"FROM pg_catalog.pg_type "

"WHERE oid = '%u'::pg_catalog.oid;",

pg_type_oid);

res = ExecuteSqlQueryForSingleRow(fout, upgrade_query->data);

pg_type_array_oid = atooid(PQgetvalue(res, 0, PQfnumber(res, "typarray")));

PQclear(res);

tinfo = findTypeByOid(pg_type_oid);

pg_type_array_oid = tinfo->typarray;

if (!OidIsValid(pg_type_array_oid) && force_array_type)

pg_type_array_oid = get_next_possible_free_pg_type_oid(fout, upgrade_query);

inti_typtype;

inti_typisdefined;

inti_isarray;

inti_typarray;

/*

* we include even the built-in types because those may be used as array

"typnamespace, typacl, "

"acldefault('T', typowner) AS acldefault, "

"typowner, "

"typelem, typrelid, "

"typelem, typrelid,typarray,"

"CASE WHEN typrelid = 0 THEN ' '::\"char\" "

"ELSE (SELECT relkind FROM pg_class WHERE oid = typrelid) END AS typrelkind, "

"typtype, typisdefined, "

i_typtype = PQfnumber(res, "typtype");

i_typisdefined = PQfnumber(res, "typisdefined");

i_isarray = PQfnumber(res, "isarray");

i_typarray = PQfnumber(res, "typarray");

for (i = 0; i < ntups; i++)

{

else

tyinfo[i].isArray = false;

tyinfo[i].typarray = atooid(PQgetvalue(res, i, i_typarray));

if (tyinfo[i].typtype == TYPTYPE_MULTIRANGE)

tyinfo[i].isMultirange = true;

else

constchar*rolname;

Oidtypelem;

Oidtyprelid;

Oidtyparray;

chartyprelkind;/* 'r', 'v', 'c', etc */

chartyptype;/* 'b', 'c', etc */

boolisArray;/* true if auto-generated array type */