Re: [BUGS] Problem when truncate table and get the OID from PQftable

2004-04-27 Thread Tom Lane
"Rodrigo Moreno" <[EMAIL PROTECTED]> writes: > 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. Why are you matching it against relfilenode? It

[BUGS] Problem when truncate table and get the OID from PQftable

2004-04-26 Thread Rodrigo Moreno
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