Array detection in pg_dump

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Array detection in pg_dump
Дата
Msg-id 200908062308.n76N8Rt27193@momjian.us
обсуждение исходный текст
Ответы Re: Array detection in pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Array detection in pg_dump  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Is there a reason we don't use pg_type.typcategory to detect arrays in
Postgres 8.4?  Right now I see this in pg_dump.c:
   if (g_fout->remoteVersion >= 80300)   {appendPQExpBuffer(query, "SELECT tableoid, oid, typname, "
"typnamespace,"          "(%s typowner) AS rolname, "          "typinput::oid AS typinput, "          "typoutput::oid
AStypoutput, typelem, typrelid, "          "CASE WHEN typrelid = 0 THEN ' '::\"char\" "          "ELSE (SELECT relkind
FROMpg_class WHERE oid = typrelid) END AS typrelkind, "          "typtype, typisdefined, "          "typname[0] = '_'
ANDtypelem != 0 AND "
 
-->  "(SELECT typarray FROM pg_type te WHERE oid = pg_type.typelem) = oid AS isarray "          "FROM pg_type",
username_subquery);   }
 

It seems the appropriate 8.4+ test would be:
t.typtype = 'b' AND t.typcategory = 'A'

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Table and Index compression
Следующее
От: Tom Lane
Дата:
Сообщение: Re: mixed, named notation support