Re:

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-general(at)postgresql(dot)org, La Mancha de la Calabaza que Ladra <mancha(at)galois(dot)baras(dot)ml(dot)org>
Subject: Re:
Date: 1998-10-12 13:42:06
Message-ID: 14654.981012@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

LMdlCqL> Hi, just to report a strange behaviour in PostgreSQL v6.3.2, Linux
LMdlCqL> 2.0.34.

LMdlCqL> I do this:

hjk=>> alter table control_veh add column fecalta date;
LMdlCqL> ADD

LMdlCqL> then that:

hjk=>> update control_veh set fecalta='01-01-1800' where plact='440JAS';
LMdlCqL> ERROR: Relation control_veh does not have attribute fecalta

LMdlCqL> later this:

hjk=>> \d control_veh

LMdlCqL> Table = control_veh
LMdlCqL> +----------------------------------+----------------------------------+-------+
LMdlCqL> | Field | Type | Length|
LMdlCqL> +----------------------------------+----------------------------------+-------+
LMdlCqL> | paterno | char() | 25 |
LMdlCqL> ...many fields...
LMdlCqL> | ultpago | char() | 2 |
LMdlCqL> | fecalta | date | 4 |
LMdlCqL> +----------------------------------+----------------------------------+-------+

LMdlCqL> this again:

hjk=>> update control_veh set fecalta='01-01-1800' where plact='440JAS';
LMdlCqL> ERROR: Relation control_veh does not have attribute fecalta

LMdlCqL> desperate this:

hjk=>> vacuum control_veh;
LMdlCqL> VACUUM
hjk=>> alter table control_veh add column fecalta date;
LMdlCqL> ERROR: PerformAddAttribute: attribute "fecalta" already exists in class "control_veh"
hjk=>>

LMdlCqL> then again:

hjk=>> update control_veh set fecalta='01-01-1800' where plact='440JAS';
LMdlCqL> UPDATE 1
hjk=>> select * from control_veh where plact='440JAS';

LMdlCqL> and voilà, it's complete. Isn't it strange?

This is an pgsql's old bug already reported by me.
The problem is that you can't reproduce this behavior all the time.
I have this bug also, but it appears only sometimes. It isn't danger
only disquieting. ;-)

Buena suerte!
Jose'

In response to

  • at 1998-10-08 20:31:44 from La Mancha de la Calabaza que Ladra

Responses

  • Re: at 1998-10-14 20:31:12 from La Mancha de la Calabaza que Ladra

Browse pgsql-general by date

  From Date Subject
Next Message Andy Lewis 1998-10-12 15:08:56 RE: [GENERAL] SELECT Date
Previous Message Andre Luis 1998-10-11 21:54:20