| From: | "T(dot)Russell" <tirny(at)mail(dot)ru> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1404: pg_dump: dump order/dependence for a UDF |
| Date: | 2005-01-16 15:43:38 |
| Message-ID: | 200501161543.j0GFhc3s024616@developer.pgadmin.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1404
Logged by: T.Russell
Email address: tirny(at)mail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Jones | 2005-01-16 16:15:55 | Re: BUG #1397: busy-loop hang on web server |
| Previous Message | Geert Jansen | 2005-01-16 10:26:45 | Interval resolution |