From: | Frank Miles <fpm(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Andy Colson <andy(at)squeakycode(dot)net> |
Subject: | Re: cannot delete some records [9.3] - semi-resolved |
Date: | 2013-12-10 16:47:34 |
Message-ID: | alpine.LRH.2.01.1312100831580.14229@homer02.u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a workaround for the mysterious inability to delete records
from one particular table not notably different from many others.
This does not explain the problem, but at least enables me to move
on... Whether all of the following steps are necessary I can't say.
Instead of loading the 9.3 DB with a dump from 8.4, I did a two
step dump-reload through an intermediate system with 9.1, first
clearing the 9.3 DB of any residues from the previous load. This
included eliminating all references to users, which in turn
required using a REASSIGN for template1 to postgres.
Retained the "superuser" status for deleting the rows. This did not
work previously (I can recreate the problem by altering the role to
mere CREATEROLE CREATEDB) and with the user in question being the
owner of the table.
This makes me a bit nervous, as I don't understand why, but at least
it seems to work.
-Frank
From | Date | Subject | |
---|---|---|---|
Next Message | Wolfgang Keller | 2013-12-10 16:47:38 | postgresql.org inconsistent (Re: PG replication across DataCenters) |
Previous Message | Merlin Moncure | 2013-12-10 16:33:53 | Re: Q: regarding backends |