BUG #1404: pg_dump: dump order/dependence for a UDF
От | T.Russell |
---|---|
Тема | BUG #1404: pg_dump: dump order/dependence for a UDF |
Дата | |
Msg-id | 200501161543.j0GFhc3s024616@developer.pgadmin.org обсуждение исходный текст |
Ответы |
Re: BUG #1404: pg_dump: dump order/dependence for a UDF
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1404 Logged by: T.Russell Email address: tirny@mail.ru PostgreSQL version: 7.4.6 Operating system: FreeBSD 5.3 Description: pg_dump: dump order/dependence for a UDF Details: for example, there is the table: CREATE TABLE test( testfield VARCHAR(5) ); in the process of life it was made (for example): CREATE OR REPLACE FUNCTION chtest() RETURNS bpchar AS ' DECLARE BEGIN RETURN \'qwerty\'; END; ' LANGUAGE 'plpgsql' VOLATILE; and further: ALTER TABLE test ALTER COLUMN testfield SET DEFAULT chtest(); $pg_dump -U user -f file.dump dbname $dropdb -U user dbname $createdb -U user -E ... -O ... -T ... dbname $psql -U user -d dbname < file.dump error: function chtest dos't exist! But in the dump it is present, only it is "below" the declaration of the creation of table. As I understand work of pg_dump: in the dump are discarded the objects, sort out of the date of creation, without taking dependences.
В списке pgsql-bugs по дате отправления: