Re: [HACKERS] Coding question

Hi, I think replacing the RELOID with TYPEOID should get you the required Datum ... later you may have to use Form_pg_type pform = (Form_pg_type) GETSTRUCT(tuple); to get a reference to the type tuple. I have worked this way but iam not sure whether this is correct or not !! If iam wrong some

[HACKERS] Executor Timings understanding !!

Hello , Can some one educate me about how to understand the timings produced by 'postgres -te' option eventhough some of the timings i could understand, I would like to know how the different stats provided there are affecting the total execution ultimately !!! Thanks in adv -Ramu

[HACKERS] How to get the Oid of the Primary key relation ??

Can some one help me in the question !!! Given the Oid of a relation .. how to get the Oid of the Primary key index on that relation ? Thanks in adv, -Ramu _ Post Classifieds on MSN classifieds. http://go.msnserver.com/IN/44045.asp

[HACKERS] Stop restarting of inner plan??

Hello, Can someone tell me how can i let the inner plan in a nestloop join NOT to restart for each tuple of the outer Plan .. so essentially, my inner plan has to be executed only once and not 'n' times .. where 'n' is the number of outer tuples ... I tried by commenting ExecReScan(innerPlan,

Re: [HACKERS] How to get RelationName ??

:58 am, Ramanujam H S Iyengar wrote: Hello, How can i get the name of a relation from its Oid ?? I have seen some functions in utils/cache/relcache.h like RelationIdGetRelation - which gives Relation Node from Oid RelationSysNameGetRelation - which gives Relation node for only the System names. Can

Re: [HACKERS] How to get RelationName ??

Ramanujam H S Iyengar hals_ramu ( at ) hotmail ( dot ) com writes: iam in need of a function through which i can get a Relation Node given its name .. precisely the same one equivalent to RelationSysNameGetRelation .. which works for all types of relations (system and user tables) The reason

[HACKERS] How to get Relation name from Oid ??

Hello , Can somebody please tell me how to get the name of the relation (Attribute also) from the Oid and the otherway back (Oid from name) ?? thanks -Ramu _ Masterpieces made affordable! Buy art prints.

[HACKERS] Stop rescan of inner relation in NestLoop ?

Can some one tell me what are the changes that i have to do , if i want the inner scan node of a nested loop join to start the scaning from thepoint where it had left previously . As of now the scan for the inner relation re-starts for a change in the correlation value from the outer relation.

[HACKERS] What will (Plan*) ()-chgParam contain ???

Hello, Can some one tell me what and when (Plan*)()-chgParam will contain ?? One of the comments mentions that it contains the list of changed ones from outer.. can some be more eloborate .. ( if possible with a eg ) Thanks, Ramu

[HACKERS] ExecReScan function

Hello, I am trying to test some of my techniques, and for that i need the nested loop join plan node (NestLoop) not to restart the scan of the inner relation for a change of outer relation correlation value, instead start from the current position where the search ended for the previous scan.

[HACKERS] Design Documentation Help !!

Hello , Can i get any design documentation apart from the readme files and the comments those are available with the source code . In particular any document explaining the data structures related to optimizer and executor parts of the system Thansk in adv, -regards Ramu

[HACKERS] How to get oprname ??

Hello , I was trying to write a patch code in converting the querytree being generated after the pg_analyze_and_rewrite(). For that I want to know the operator name ( like =, , etc ) .. but the Oper node stores the opno How to get the operator from the opno ??? Thanks for the Help in