Unix Technical Forum

a bug?

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Databases

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-09-2008, 11:50 PM
gkal.USUNTO@kalasoft.com.pl
 
Posts: n/a
Default a bug?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:22 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com