Обсуждение: Problem when truncate table and get the OID from PQftable

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

"Rodrigo Moreno" <rodrigo.miguel@terra.com.br> 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 is the OID.

            regards, tom lane