pg_dump doesn't handle CREATE FUNCTIONs well
Rainer Mager (rmager@vgkk.com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
pg_dump doesn't handle CREATE FUNCTIONs well
Long Description
We have a table (table_A) that has a constraint on it that uses a custom function (func_B), which references a different table (table_C). When we do a pg_dump all of the table and function definitions are created correctly but in the wrong order.
The dump has the items in this order: table_C, table_A, func_B
The problem is that the creation of table_A requires the existence of func_B. Therefore the dump should have dumped things in this order: table_C, func_B, table_A.
This is reasonably easy to fix by hand because we only have one such situation and the trail is easy to trace. A more complicated situation could be a pain to fix by hand.
Sample Code
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
pg_dump doesn't handle CREATE FUNCTIONs well
Any particular version to mention with that?
AFAIK this is fixed in the current release (7.1.2)
regards, tom lane
I saw the problem in 2 different (but mirrored and therefore identical)
7.1.2 databases. The data was created in the db before 7.1.2 but it has
since been upgraded and the dump was via 7.1.2. Was the bug in the dump code
or did it have to do with db creation?
Thanks,
--Rainer
Show quoted text
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, July 25, 2001 3:27 PM
To: rmager@vgkk.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] pg_dump doesn't handle CREATE FUNCTIONs wellpgsql-bugs@postgresql.org writes:
pg_dump doesn't handle CREATE FUNCTIONs well
Any particular version to mention with that?
AFAIK this is fixed in the current release (7.1.2)
regards, tom lane