Re: [HACKERS] Database Restore with 6.1 fails (Name -> name).

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

------------------------------