Re: cannot delete some records [9.3] - semi-resolved

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

Browse pgsql-general by date

  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