From: | La Mancha de la Calabaza que Ladra <mancha(at)galois(dot)baras(dot)ml(dot)org> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | |
Date: | 1998-10-08 20:31:44 |
Message-ID: | 199810082031.PAA12366@galois.dgst.ddf.gob.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.Magarios
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1998-10-08 21:37:50 | RE: [GENERAL] SELECT Date |
Previous Message | Taral | 1998-10-08 19:48:08 | select * from table where oid = number; |