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
|
Список | 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 по дате отправления: