[HACKERS] Database Restore with 6.1 fails (Name -> name).
| От | Sean Reifschneider |
|---|---|
| Тема | [HACKERS] Database Restore with 6.1 fails (Name -> name). |
| Дата | |
| Msg-id | df00851c834ff6a13026836df15d6c32 обсуждение исходный текст |
| Список | 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 по дате отправления: