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

2013-12-10 Thread Frank Miles
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 D

Re: [GENERAL] cannot delete some records [9.3]

2013-12-05 Thread Frank Miles
On Thu, 5 Dec 2013, Andy Colson wrote: On 12/5/2013 4:05 PM, Frank Miles wrote: The table schema is {\d credmisc}: And this is all owned by: {\dp credmisc} You have a table credmisc, in schema credmisc, owned by credmisc? It could be a path problem. Maybe trigger should be: Sorry for the

Re: [GENERAL] cannot delete some records [9.3]

2013-12-05 Thread Frank Miles
On Thu, 5 Dec 2013, Andy Colson wrote: On 12/5/2013 4:05 PM, Frank Miles wrote: [snip] Table "public.credmisc" Column | Type |Modifiers --+--+-

Re: [GENERAL] cannot delete some records [9.3]

2013-12-05 Thread Andy Colson
On 12/5/2013 4:05 PM, Frank Miles wrote: The table schema is {\d credmisc}: And this is all owned by: {\dp credmisc} You have a table credmisc, in schema credmisc, owned by credmisc? It could be a path problem. Maybe trigger should be: trig_credmisc_updt BEFORE UPDATE ON credmisc.credmisc

Re: [GENERAL] cannot delete some records [9.3]

2013-12-05 Thread Andy Colson
On 12/5/2013 4:05 PM, Frank Miles wrote: I'm in the process of moving from a server running postgresql-8.4 (Debian-oldstable) to a newer machine running postgresql-9.3. The dumpall-restore process seemed to go perfectly. In running my self-test script, I discovered that one of the tables couldn

[GENERAL] cannot delete some records [9.3]

2013-12-05 Thread Frank Miles
I'm in the process of moving from a server running postgresql-8.4 (Debian-oldstable) to a newer machine running postgresql-9.3. The dumpall-restore process seemed to go perfectly. In running my self-test script, I discovered that one of the tables couldn't be cleared of some unit-test entries