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  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список 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 по дате отправления:

Предыдущее
От: gonzaga@pbh.gov.br
Дата:
Сообщение: Bug in check constraint?
Следующее
От: "Geert Jansen"
Дата:
Сообщение: Interval resolution