On Sat, 2002-09-21 at 19:49, Tom Lane wrote: > > 3. A view is being created before one of the tables it refers to. > > On thinking about it, I'm having a hard time seeing how that case could > arise, unless the source database was old enough to have wrapped around > its OID counter. I'd be interested to see the details of your case. > While the only long-term solution is proper dependency tracking in > pg_dump, there might be some shorter-term hack that we should apply...
While I don't think that the oids have wrapped round, the oid of the table in question is larger than the oid of the view. It is quite likely that the table was dropped and recreated after the view was created. In fact, the view no longer works: ERROR: Relation "sales_forecast" with OID 26246751 no longer exists so that must be what happened. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Charge them that are rich in this world, that they not be highminded nor trust in uncertain riches, but in the living God, who giveth us richly all things to enjoy; That they do good, that they be rich in good works, ready to distribute, willing to communicate; Laying up in store for themselves a good foundation against the time to come, that they may lay hold on eternal life." I Timothy 6:17-19 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
