Обсуждение: Re: Re[2]: [HACKERS] Database Restore with 6.1 fails (Name -> na
On Mon, 16 Jun 1997, Leo Shuster wrote:
>
> 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?
In what way?
>
> 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
>
>
>
>
>
Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org scrappy@freebsd.org
------------------------------
> > > 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? It automatically lowercases all identifiers. What do you want it to do? Auto-rename uppercase table names that conflict with already-existing lowercase names? - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
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
------------------------------