[HACKERS] Getting the OID inside the executor

2011-09-01 Thread Fazool
Hello everyone, I am implementing some functionality into Postgresql, where I want to track which row was accessed by a user query. I am implementing the functionality inside Postgres, so that there are no changes required on client side (e.g. re-writing queries). Rows are identified by OIDs, and

Re: [HACKERS] Getting the OID inside the executor

2011-09-01 Thread Tom Lane
Fazool fazoolm...@gmail.com writes: I am implementing some functionality into Postgresql, where I want to track which row was accessed by a user query. I am implementing the functionality inside Postgres, so that there are no changes required on client side (e.g. re-writing queries). Rows are

Re: [HACKERS] Getting the OID inside the executor

2011-09-01 Thread Fazool
Thanks for the reply Tom. As far as I know, the TID of a row can change over time (e.g. when the row is updated). Isn't it so? If so, it wont solve my problem. It says here (http://www.postgresql.org/docs/9.0/static/ddl-system-columns.html) that The OID, or even better a user-defined serial