Postgres Pro
Downloads
Home   >   mailing lists

identify table oid for an AggState during plan tree initialization - Mailing list pgsql-hackers

From Masterprojekt Naumann1
Subject identify table oid for an AggState during plan tree initialization
Date
Msg-id CANjJybTGbDNhDEbjw09LuDgzFn=tzSv=6ovQrx-MJFWruF6-xQ@mail.gmail.com
Whole thread Raw
Responses Re: identify table oid for an AggState during plan tree initialization  (Masterprojekt Naumann1 <mpws2013n1@gmail.com>)
List pgsql-hackers
Tree view
Hi,

during the initialization of the nodes in the plan tree (in ExecInitNode in the file execProcnode.c) I want to find out for a node with the type T_Agg which table will be aggregated. I tried the following:

resultAsAggState = ExecInitAgg((Agg *) node, estate, eflags);

if (resultAsAggState)
{
//tableOid = rel->rd_id;
//tableOid = resultAsAggState->ss.ss_currentRelation->rd_id;
}
It would be great to get the Oid of the table, but I would also be satisfied if I could get at least the name of the table. Does anyone know if it is possible to gather these information?

Best regards
Cathleen

pgsql-hackers by date:

Previous
From: Mel Gorman
Date:
Subject: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance
Next
From: Asif Naeem
Date:
Subject: Re: [bug fix] PostgreSQL fails to start on Windows if it crashes after tablespace creation