Обсуждение: BUG #1404: pg_dump: dump order/dependence for a UDF
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.
On Sun, Jan 16, 2005 at 03:43:38PM +0000, T.Russell wrote: > As I understand work of pg_dump: in the dump are discarded the > objects, sort out of the date of creation, without taking dependences. That's right. 8.0's pg_dump does the right thing. -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "Amanece. (Ignacio Reyes) El Cerro San Cristóbal me mira, cínicamente, con ojos de virgen"