[HACKERS] Database Restore with 6.1 fails (Name -> name). - Mailing list pgsql-hackers

From Sean Reifschneider
Subject [HACKERS] Database Restore with 6.1 fails (Name -> name).
Date
Msg-id df00851c834ff6a13026836df15d6c32
Whole thread Raw
List pgsql-hackers
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...

Sean
- --
 Do bad programmers wake up on Christmas morning to find coal in
 their sockets?  -- Sean Reifschneider
Sean Reifschneider, Inimitably Superfluous <jafo@tummy.com>
URL: <http://www.tummy.com/xvscan> HP-UX/Linux/FreeBSD/BSDOS scanning software.

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

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Clarification of NULL values
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Database Restore with 6.1 fails (Name -> name).