Postgres Pro
Downloads
Home   >   mailing lists

Re: Thoughts on how to avoid a massive integer update. - Mailing list pgsql-general

From Rob Sargent
Subject Re: Thoughts on how to avoid a massive integer update.
Date
Msg-id E3B6D3D1-D60E-40D9-8855-B23F7EDBFA8E@gmail.com
Whole thread Raw
In response to Re: Thoughts on how to avoid a massive integer update.  ("Fehrle, Brian" <bfehrle@comscore.com>)
Responses Re: Thoughts on how to avoid a massive integer update.  ("Fehrle, Brian" <bfehrle@comscore.com>)
List pgsql-general
Tree view
   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?  



pgsql-general by date:

Previous
From: "Fehrle, Brian"
Date:
Subject: Re: Thoughts on how to avoid a massive integer update.
Next
From: Alan Hodgson
Date:
Subject: Re: Best way to use trigger to email a report ?