Re: [BUGS] Table constraint ordering disrupted by pg_dump

[Patricia Holben]

Title: Re: [BUGS] Table constraint ordering disrupted by pg_dump

I have loaded this new version and re-tested but don't see it fixed. 
If the standard regression tests are run and after completion a pg_dump
is performed:  pg_dump -o regression > dumpfile, if you look in the
dumpfile, you will see that the create for table insert_tbl shows the
Check being applied before the constraint insert_con.

I do have a separate routine which I am running - it isn't complete
which is why I haven't shared it yet - which proves that when the dump
is reloaded the constraints are not applied in the original order.

Tricia Holben
757-233-5568

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/3/01, 3:57:02 AM, Philip Warner <[EMAIL PROTECTED]> wrote regarding
Re: [BUGS] Table constraint ordering disrupted by pg_dump :


> At 23:55 2/04/01 -0400, Tom Lane wrote:
> >Philip Warner <[EMAIL PROTECTED]> writes:
> >> While it't not a bug, it would be nice if pg_dump reproduced
definitions as
> >> faithfully as possible. To that end, would it be worth selecting
the
> >> constraints in OID order (using oid from pg_relcheck)?
> >
> >If it's just another clause in a query, you might as well.  I
wouldn't
> >take any risks for it though...

> Just an ORDER BY. This has been done in CVS, but since I could not
> reproduce the original problem, I can't check it, so let me know how
it works.




> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.B.N. 75 008 659 498)          |          /(@)   ______---_
> Tel: (+61) 0500 83 82 81         |                 _________  \
> Fax: (+61) 0500 83 82 82         |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/