"Luiz Henrique" <[EMAIL PROTECTED]> writes:
> On 8/21/06, Jim Nasby <[EMAIL PROTECTED]> wrote:
>> What version are you using? In recent versions, indexes are supposed
>> to be safe from corruption, even through crashes.
> It's Postgresql 7.2.1, installed with stable version of Debian Woody, at the
It's Postgresql 7.2.1, installed with stable version of Debian Woody, at the time.On 8/21/06, Jim Nasby <[EMAIL PROTECTED]
> wrote:On Aug 15, 2006, at 8:50 AM, Luiz Henrique wrote:> my problem was problably corrupted index files. I recreated the
> index and it's ok now. The hardware was being unplu
On Aug 15, 2006, at 8:50 AM, Luiz Henrique wrote:
my problem was problably corrupted index files. I recreated the
index and it's ok now. The hardware was being unpluged from power
source without shuthing down, I guess that's the cause.
What version are you using? In recent versions, indexes
Hi, my problem was problably corrupted index files. I recreated the index and it's ok now. The hardware was being unpluged from power source without shuthing down, I guess that's the cause.I used the fallowing commands to recreate index:
/etc/init.d/postgresql stop
su postgres
/usr/lib/postgresql/b
On Fri, 4 Aug 2006, Luiz Henrique wrote:
> Hi, could you tell me how postgresql look for a referenced key? It looks in
> table index? Maybe only the index is corrupted?
It basically runs a query like:
SELECT * FROM parenttable WHERE keycol1 = ? [AND keycol2 = ? ...] FOR
SHARE
It should act lik
Hi, could you tell me how postgresql look for a referenced key? It looks in table index? Maybe only the index is corrupted?Thanks!On 8/2/06, Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Wed, 2 Aug 2006, Luiz Henrique wrote:> Hi,>> I'm running Postgresql 7.3 in Debian Woody OS.>> After some time wor
On Wed, 2 Aug 2006, Luiz Henrique wrote:
> Hi,
>
> I'm running Postgresql 7.3 in Debian Woody OS.
>
> After some time working properly, insert's statements related this error:
>
>
> referential integrity violation - key referenced from xxx not found in yyy
>
>
> This error would be norma
Hi,I'm running Postgresql 7.3 in Debian Woody OS.After some time working properly, insert's statements related this error:referential integrity violation - key referenced from xxx not found in yyy
This error would be normal, if the key really doesn't exist, but the key exist.The insert's wo
