BUG #2369: pg_dump function dependencies

Поиск
Список
Период
Сортировка
От Jonathan Ellis
Тема BUG #2369: pg_dump function dependencies
Дата
Msg-id 200604012355.k31NtHbq015787@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2369: pg_dump function dependencies  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2369
Logged by:          Jonathan Ellis
Email address:      jbellis+ns@gmail.com
PostgreSQL version: 8.1.3
Operating system:   linux
Description:        pg_dump function dependencies
Details:

I have many many instances of these two problems in pg_dump's output:

1) function code don't seem to be taken into account for dependencies

for example, one function was dumped as follows (note the %TYPE use), but
the general_permissions table was dumped much later:

CREATE FUNCTION all_users_permission_id(character varying, integer,
character varying) RETURNS integer
    AS $_$
 DECLARE
  v_permission_type     alias for $1;
  v_on_what_id          alias for $2;
  v_on_which_table      alias for $3;
  v_permission_id       general_permissions.permission_id%TYPE;

non-%TYPE uses get ignored too; e.g. a function containing this line, before
the minions_power_v view was created:

    ttt := ttt +
       max(0, coalesce(
        (0.661 * (select sum(w.value) from weapons_v w where w.party_id = $1
and w.minion_id is not null)
        - (select sum(tp_total) from minions_power_v m where m.party_id =
$1))::int
       , 0));

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2366: Timestamptz data type is inaccurate
Следующее
От: "Amaresh Wakkar"
Дата:
Сообщение: BUG #2370: 25P02,current transaction is aborted, commands ignored until end of transaction block