Well, I found the reason for these table becoming 'read only':

These tables where part of a merge table, which included some read only
tables (read only set in file system).

Now even after the merge table was dropped, all member tables stayed
'read only' regardless of their individual file system permissions.

very odd.. a bug?

to recover, you will have to:

- drop the merge table.
- create new tables
- insert the data from the old tables into the new tables
- drop the old tables
- rename the new tables to match the names of the old tables.
- change file system permissions on ALL the tables of the merge tables
- recreate the merge tables...



Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to