Re: ERROR: could not find tuple for trigger 37463634

From: <mdione(dot)ext(at)orange(dot)com>
To: DIONE Marcos David Ext DMGP/PORTAIL <mdione(dot)ext(at)orange(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: could not find tuple for trigger 37463634
Date: 2012-03-07 13:10:50
Message-ID: 17319_1331125854_4F575E5E_17319_1659_1_9632480C9F82B44294C2302320958E9808415F9AC6@PUEXCB2F.nanterre.francetelecom.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

De : pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] De la part de mdione(dot)ext(at)orange(dot)com
> What I understand is that it seems that somehow I got some references to objects
> that do not exist anymore, so I think I should run the equivalent of fsck I this
> database. My speculations apart, how to proceed to unlock this situation?

Actually I'm quite tempted to do something like this:

http://archives.postgresql.org/pgsql-admin/2006-05/msg00084.php

Should that be enough or as the dangling question says, there should
be something else to do?

--
Marcos Dione
SysAdmin
Astek Sud-Est
pour FT/TGPF/OPF/PORTAIL/DOP/HEBEX @ Marco Polo
04 97 12 62 45 - mdione(dot)ext(at)orange(dot)com

_________________________________________________________________________________________________________________________

Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration,
France Telecom - Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci

This message and its attachments may contain confidential or privileged information that may be protected by law;
they should not be distributed, used or copied without authorization.
If you have received this email in error, please notify the sender and delete this message and its attachments.
As emails may be altered, France Telecom - Orange shall not be liable if this message was modified, changed or falsified.
Thank you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dennis jenkins 2012-03-07 14:03:38 Re: SQL Normalization Thought
Previous Message David Johnston 2012-03-07 12:34:08 SQL Normalization Thought