Postgres Pro
Downloads
Home   >   mailing lists

Problem when truncate table and get the OID from PQftable - Mailing list pgsql-bugs

From Rodrigo Moreno
Subject Problem when truncate table and get the OID from PQftable
Date
Msg-id AFELKMEENJDMOIOKOEIFCEGHCHAA.rodrigo.miguel@terra.com.br
Whole thread Raw
Responses Re: Problem when truncate table and get the OID from PQftable  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: ross@stamina.com.au (Ross Ferris)
Date:
Subject: Re: How configure Oracle 9i not case sensitive...
Next
From: "Mike Quinn"
Date:
Subject: make check regression "test stats" failed