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'
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 |