Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Jon PastoreDate: 2004-04-21 15:14:43
Subject: postgresql idle
Previous:From: Theo KramerDate: 2004-04-20 15:45:41
Subject: PQexecPrepared - PostgreSQL 7.4.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group