Re: [ADMIN] DROP INDEX causes errors

2008-12-18 Thread Michael Monnerie
On Donnerstag 18 Dezember 2008 Alvaro Herrera wrote: > Does it persist if you close the connection and open a new one? You're great, that worked indeed. I was a bit nervous now ;-) Thanks! mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31

Re: [ADMIN] DROP INDEX causes errors

2008-12-18 Thread Alvaro Herrera
Michael Monnerie wrote: > On Mittwoch 17 Dezember 2008 Michael Monnerie wrote: > > for each and every delete of a row in that table. After a > > REINDEX TABLE dbmail_messageblks; > > everything seems to work. > > I was wrong, still get this error: > Dec 18 10:55:33 db2.zmi.at postgres[2816]: [112-

Re: [ADMIN] DROP INDEX causes errors

2008-12-18 Thread Michael Monnerie
On Mittwoch 17 Dezember 2008 Michael Monnerie wrote: > for each and every delete of a row in that table. After a > REINDEX TABLE dbmail_messageblks; > everything seems to work. I was wrong, still get this error: Dec 18 10:55:33 db2.zmi.at postgres[2816]: [112-1] DELETE:ERROR: could not open rela

[ADMIN] DROP INDEX causes errors

2008-12-17 Thread Michael Monnerie
# select version(); version --- PostgreSQL 8.1.11 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20061115 (prerelease