Problem when truncate table and get the OID from PQftable

From: "Rodrigo Moreno" <rodrigo(dot)miguel(at)terra(dot)com(dot)br>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem when truncate table and get the OID from PQftable
Date: 2004-04-20 20:29:22
Message-ID: AFELKMEENJDMOIOKOEIFCEGHCHAA.rodrigo.miguel@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi

After truncate the table, the oid retuned by PQftable/libpq returns the old
value, and i'm not able to find it in pg_class, because the value of
pg_class.relfilenode was changed after the truncate.

The problem is only solved if i drop the table and re-creating again.

Regards
Rodrigo Moreno

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jon Pastore 2004-04-21 15:14:43 postgresql idle
Previous Message Theo Kramer 2004-04-20 15:45:41 PQexecPrepared - PostgreSQL 7.4.1