Re: How to tell which statement is being executed - Mailing list pgsql-general

From Tom Lane
Subject Re: How to tell which statement is being executed
Date
Msg-id 3307593.1699027709@sss.pgh.pa.us
Whole thread Raw
In response to How to tell which statement is being executed  (Garfield Lewis <garfield.lewis@lzlabs.com>)
Responses Re: [EXT] Re: How to tell which statement is being executed  (Garfield Lewis <garfield.lewis@lzlabs.com>)
List pgsql-general
Garfield Lewis <garfield.lewis@lzlabs.com> writes:
> If I create a C function, is there a way from within that function for me to:
>   1.  know whether it is being triggered by an INSERT or UPDATE statement

It might not be any of those.  But if what you want is the most closely
nested SQL action, inspecting the ActivePortal might help (see
function_parse_error_transpose, which I think is the only in-core user).

>   2.  column attribute (specifically the TYPMOD) for the affected column

No.  How would you even define "affected column"?

            regards, tom lane



pgsql-general by date:

Previous
From: Garfield Lewis
Date:
Subject: How to tell which statement is being executed
Next
From: shashidhar Reddy
Date:
Subject: Finding execution plan