| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_dump problems in upgrading |
| Date: | 2002-09-21 19:35:54 |
| Message-ID: | 20083.1032636954@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Oliver Elphick <olly(at)lfix(dot)co(dot)uk> writes:
>>> 3. A view is being created before one of the tables it refers to.
> 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.
Ah ... so the view was broken already. I'm surprised you didn't get a
failure while attempting to dump the view definition.
The new dependency stuff should help prevent this type of problem in
future ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Buckman | 2002-09-22 02:04:21 | Re: Lyris looking to help fix PostgresSQL crashing problems |
| Previous Message | Oliver Elphick | 2002-09-21 19:28:11 | Re: pg_dump problems in upgrading |