This is a discussion on a bug? within the pgsql Databases forums, part of the PostgreSQL category; --> Hello. I have an multivolume db under 8.3A in IBM AIX 4.3 (ca 1.5 GB) I have moved it ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello. I have an multivolume db under 8.3A in IBM AIX 4.3 (ca 1.5 GB) I have moved it to AIX 5.2L I used an 9.1d to convert it do v9. Without opening db under 9.1d I have used OE10b to convert db to V10. When i try to delete a table with existing records (using dictionary or DROP TABLE .... in .df file) nothing happens. No error message. Just "load completed" and "deleted" table still exists. After I had deleted all records (DELETE FROM ....) then I could DROP the table. When i created a new table and add some records then I could drop table with its contents without any problem. But tables existed in V8 are undeletable when they are not empty. I used dbrpr to rebuild all chains. I used idxb all. I'm sure that dump and reload will fix it, but the application uses many RECID and I'd rather not to do this. Any ideas?? With regards G.Kalinski |