drop view seems to have made database unusable . . help!

Поиск
Список
Период
Сортировка
Искать
От
Martin Weinberg
Тема
drop view seems to have made database unusable . . help!
Дата
Msg-id
199910292250.SAA24626@osprey.astro.umass.edu
Список
Дерево обсуждения
drop view seems to have made database unusable . . help! Martin Weinberg <weinberg@osprey.astro.umass.edu>
Bug report on views [was: drop view seems to have made database unusable] Martin Weinberg <weinberg@osprey.astro.umass.edu>
Help!

I attempted to create a view like

	create view pscscan as select * from psc, scandat where . . .;

which failed with a message about duplicate entries.  I tried
another with

	create view pscscan2 as select j_m, j_pts_noise from psc, scandat where . . .;

which worked.

I then tried to drop them both and the backend crashed
I tried to vacuum and the vacuum crashed.  Now I can not
connect to the database at all (I deleted the lock file)
Now, postgres seems to create an empty file 
"pg_internal.init" and crash when I try to connect.

What happened?  Is there any way to save this? I have nearly 
100GB in this database . . . sigh.

--Martin


===========================================================================

Martin Weinberg                      Phone: (413) 545-3821
Dept. of Physics and Astronomy       FAX:   (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA  01003-4525


В списке pgsql-general по дате отправления
От: amy cheng
Дата:
Сообщение: Re: [NOVICE] next steps
От: Bill Meahan
Дата:
Сообщение: Re: [GENERAL] Studying
FAQ