Re: 8.0 rc2 Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.0 rc2 Problem
Date: 2004-12-28 15:13:14
Message-ID: 120.1104246794@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk> writes:
> Further examination.... I orignally used by 7.4 backup (taken
> every 12 hours and well tested that they work under 7.4 anyway) rather
> than redumping using pg_dump 8.0. I have now dumped using pg_dump version
> 8.0 same problem. I dumped just the schema. upon load into 8.0 a couple of
> lines saying

> ERROR: relation "test_id_seq" does not exist
> STATEMENT: REVOKE ALL ON TABLE shopping_id_seq TO PUBLIC;
> ERROR: relation "test_id_seq" does not exist
> STATEMENT: GRANT ALL ON TABLE test_id_seq TO PUBLIC;

Could you send me that dump off-list?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marek Lewczuk 2004-12-28 15:51:36 Re: Get current trasanction id
Previous Message Nefnifi, Kasem 2004-12-28 15:11:25 Re: running a query file of 42MB