Marc, maybe the dump/dump_all scripts need to be re-done to accommodate
those people that were using case-sensitive field names in pre-6.1
Postgres versions?
Leo
_______________________________________________________________________________
Subject: Re: [HACKERS] Database Restore with 6.1 fails (Name -> name)
From: The Hermit Hacker <scrappy%hub.org@interlockp.lubrizol.com> at LZ-
INTERNET
Date: 6/15/97 12:35 PM
On Sun, 15 Jun 1997, Sean Reifschneider wrote:
> Greetings. I just built 6.1 on a Linux 2.0.29 (RedHat) machine, following
> the instructions to the letter. Everything looked fine until I went
> to access one of my databases. Some of them seem to be fine, but others
> have had the field names converted to all lower-case. When I dropped the
> table and re-created it, it still ended up with the field turned into
> lower case.
>
> I dumped the database with the dumpall command and restored as suggested
> in the installation instructions. Here's a sample session:
>
> xvscanpub=> CREATE TABLE ProjUser (Key int4, Name text) archive = none;
> CREATE
> xvscanpub=> COPY ProjUser WITH OIDS FROM stdin;
> Enter info followed by a newline
> End with a backslash and a period on a line by itself.
> >> 513147 1 jafo
> >> 513148 2 efm
> >> \.
> resetting connection
> xvscanpub=> select * from ProjUser;
> key|name
> ---+----
> (0 rows)
>
> I backed off to 6.0, but wanted to send in a report. Other than that,
> it looked fine...
Case sensitivity in tables/field names were removed in v6.1...
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
------------------------------
