Re: [EXT] Re: How to tell which statement is being executed

2023-11-03 Thread Garfield Lewis
ion then Postgres will need to generate a truncation warning so it must know the TYPMOD of the column to do so. Regards Garfield From: Tom Lane Date: Friday, November 3, 2023 at 12:08 PM To: Garfield Lewis Cc: pgsql-generallists.postgresql.org Subject: [EXT] Re: How to tell which state

Re: How to tell which statement is being executed

2023-11-03 Thread Tom Lane
Garfield Lewis 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

How to tell which statement is being executed

2023-11-03 Thread Garfield Lewis
Hi All, 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 * I’ve done some digging and it seems you can get this information if you provide a Planner hook, however, I need to know this m