Thread: Found solution to reloading dumped 6.1 -> 6.4

The 6.1 db.out has a line in it that looks like this;

CREATE TABLE categories (category varchar(30)) archive = none;

If I remove the " archive = none"  bit, then all works ok.  Excellent.

bob

--
http://www.chalmers.com.au               Chinese Language Studies.
http://4qir.quantum-radio.net.au                     World Music Radio.
phone:61-7-49440357 - fax:61-7-49512832           icq#11252938.
Courses and Resources and Radio 4QIR.   Working for Whirled Peas.

> The 6.1 db.out has a line in it that looks like this;
>
> CREATE TABLE categories (category varchar(30)) archive = none;
>
> If I remove the " archive = none"  bit, then all works ok.  Excellent.

Yes.  Archive has been a noise word since Berkeley, and I removed the
code to handle it several releases ago.  However, I left the parse code
so it was still ignored.

In 6.4 development process, someone saw the archive, knew the code to
support it was goine, and removed the parse code, not considering the
old dumps would have it.

Glad you could remove it easily.

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