| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella(at)gmail(dot)com>, yudhi s <learnerdatabase99(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Manual query vs trigger during data load |
| Date: | 2024-09-13 17:22:53 |
| Message-ID: | BD545781-5E87-4CCB-A378-64B4C9F9AD2F@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Sep 13, 2024, at 10:57 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 9/13/24 07:50, Adrian Klaver wrote:
>>> On 9/13/24 02:58, Juan Rodrigo Alejandro Burgos Mella wrote:
>>> Hello, I find it unlikely that the trigger will work properly, since the reserved fields of the OLD subset have no value in an INSERT
>> I'm not seeing that the OP is asking for OLD.* values, they are just looking to include the result of a lookup on another table in the INSERT.
>
> My mistake I see the OLD reference now.
>
>>>
Personally I would cache the lookup on the java side a send the correct value to a simple insert statement
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-09-13 17:46:10 | Re: Functionally dependent columns in SELECT DISTINCT |
| Previous Message | David Mullineux | 2024-09-13 16:58:43 | Re: Will hundred of thousands of this type of query cause Parsing issue |