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

Responses

  • Re: at 1998-10-12 13:42:06 from Sferacarta Software

Browse pgsql-general by date

  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;