Re: [GENERAL] psql -e problem
От | Simon Drabble |
---|---|
Тема | Re: [GENERAL] psql -e problem |
Дата | |
Msg-id | Pine.LNX.3.95.990205142854.32723A-100000@localhost обсуждение исходный текст |
Ответ на | Re: [GENERAL] psql -e problem (Bruce Momjian <maillist@candle.pha.pa.us>) |
Список | pgsql-general |
On Fri, 5 Feb 1999, Bruce Momjian wrote: > Sounds like an OS bug. o...k... Linux is famous for this sort of behaviour, I shoulda guessed. Anyone else with perhaps a more helpful idea? Simon. > > > Just upgraded to 6.4.2 from 6.3.2 and I've got a bit of a problem. > > > > Compiled, installed, regressed(?) all went fine. Come to load up the old > > datbases, and it appears that \. is not being recognised as end-of-input > > in the database dump file (I did a pg_dumpall -z, if that helps). > > > > For example, I have some data as follows, which should be read in up to > > the \. line, but the \. lines appears to not be recognised/ handled, > > causing the following lines to be treated as data, which leads to the > > commands not being executed... > > > > > > COPY stats FROM stdin; > > 11.5 2.5 07-11-1998 > > 12 3 07-16-1998 > > 12 3 07-19-1998 > > 14 4 07-30-1998 > > 14 4 08-06-1998 > > 15 4.5 08-15-1998 > > 15 4.5 08-24-1998 > > 16.5 5 08-30-1998 > > 18.5 5 09-13-1998 > > 20 5.5 09-20-1998 > > 23 6 10-05-1998 > > \. > > \connect template1 simon > > create database members; > > > > This \connect line is being treated as data, as is the create.. line, > > which means the members database is not created. > > > > Apart from separating out all the data (COPY blocks) from the command > > lines, and running two or more separate routines to update the data, is > > there anything I can do? > > > > > > Si. > > > > > > -- > > "Is it farther to New York or by plane?" > > > > Simon Drabble madlather@syspac.com > > > > > > > > > -- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > -- "Is it farther to New York or by plane?" Simon Drabble madlather@syspac.com
В списке pgsql-general по дате отправления: