... - Mailing list pgsql-general

From La Mancha de la Calabaza que Ladra
Subject ...
Date
Msg-id 199810082031.PAA12366@galois.dgst.ddf.gob.mx
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: "Taral"
Date:
Subject: select * from table where oid = number;
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] SELECT Date