Re: 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 <pjw(at)rhyme(dot)com(dot)au> wrote regarding Re:
[BUGS] Table constraint ordering disrupted by pg_dump :

> At 23:55 2/04/01 -0400, Tom Lane wrote:
> >Philip Warner <pjw(at)rhyme(dot)com(dot)au> 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 |/