Re: pg_dump ordering problem (rc4) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_dump ordering problem (rc4)
Date
Msg-id 200104140115.VAA21460@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_dump ordering problem (rc4)  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: pg_dump ordering problem (rc4)  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
> At 17:34 13/04/01 -0400, Tom Lane wrote:
> >
> >A possible kluge answer is to make pg_dump's OID-ordering of views
> >depend on the OID of the view rule rather than the view relation.
> >I am not sure if that would break any cases that work now, however.
> >
> 
> This seems good to me; it should be based on the 'oid of the view', and
> AFAICT, the rule OID should be it. Should I do this?

The view oid is certainly better than the base relation oid.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: ORDER BY ????
Next
From: Bruce Momjian
Date:
Subject: Re: Anyone have any good addresses ... ?