Hi, just to report a strange behaviour in PostgreSQL v6.3.2, Linux
2.0.34.
I do this:
hjk=> alter table control_veh add column fecalta date;
ADD
then that:
hjk=> update control_veh set fecalta='01-01-1800' where plact='440JAS';
ERROR: Relation control_veh does not have attribute fecalta
later this:
hjk=> \d control_veh
Table = control_veh
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| paterno | char() | 25 |
...many fields...
| ultpago | char() | 2 |
| fecalta | date | 4 |
+----------------------------------+----------------------------------+-------+
this again:
hjk=> update control_veh set fecalta='01-01-1800' where plact='440JAS';
ERROR: Relation control_veh does not have attribute fecalta
desperate this:
hjk=> vacuum control_veh;
VACUUM
hjk=> alter table control_veh add column fecalta date;
ERROR: PerformAddAttribute: attribute "fecalta" already exists in class "control_veh"
hjk=>
then again:
hjk=> update control_veh set fecalta='01-01-1800' where plact='440JAS';
UPDATE 1
hjk=> select * from control_veh where plact='440JAS';
and voil�, it's complete. Isn't it strange?
--
La Mancha, http://breogan.iimas.unam.mx/~mancha
casa://AvRevolucion.1761.depto.5/~mancha
ring://550-2547.df.telmex.com.mx/~pedir.por.mancha
chamba://cubo-320.iimas.unam.cu/~mancha
rechamba://533-3035.df.telmex.com.mx/~pedir.por.Sr.Magari�os
