Re: Thoughts on how to avoid a massive integer update.

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: "Fehrle, Brian" <bfehrle(at)comscore(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Thoughts on how to avoid a massive integer update.
Date: 2020-05-08 17:04:57
Message-ID: E3B6D3D1-D60E-40D9-8855-B23F7EDBFA8E@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Could you show an example table relationship?
>
> It’s a simple one-to-many relationship:
> *Info_table*
> info_table_sid integer
>
>
> *data_table*
> data_table_sid integer,
> info_table_id integer references info_table(info_table_sid),
>
>
>

Right, and now you wish to change the values in the referenced table (info_table.info_table_sid) correct?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2020-05-08 17:10:02 Re: Best way to use trigger to email a report ?
Previous Message Fehrle, Brian 2020-05-08 16:57:49 Re: Thoughts on how to avoid a massive integer update.