...

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