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 по дате отправления