Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Pankaj Jangid
Krishnakant Mane writes: >> You might think about adding the new UUID column and use the existing >> primary key to inform the updates in dependent tables. Then remove the >> old PK  column and constraint followed by promoting the UUID to >> primary key. This could be safely scripted and applied

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Krishnakant Mane
On 26/09/19 6:53 PM, Rob Sargent wrote: >   > > On Sep 26, 2019, at 12:27 AM, Krishnakant Mane > wrote: > >> >> On 26/09/19 12:03 AM, Adrian Klaver wrote: >>> On 9/25/19 8:04 AM, Rob Sargent wrote: On Sep 25, 2019, at 8:24 AM, Krishnakant Mane >>>

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Rob Sargent
-- Regards, Krishnakant Mane, Project Founder and Leader, GNUKhata //(Opensource Accounting, Billing and Inventory Management Software)// You might think about adding the new UUID column and use the existing primary key to inform the updates in dependent tables. Then remo

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Rob Sargent
> On Sep 26, 2019, at 7:44 AM, Krishnakant Mane wrote: > > >> On 26/09/19 6:53 PM, Rob Sargent wrote: >> >> >> On Sep 26, 2019, at 12:27 AM, Krishnakant Mane wrote: >> >>> On 26/09/19 12:03 AM, Adrian Klaver wrote: > On 9/25/19 8:04 AM, Rob Sargent wrote: > > > On

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Rob Sargent
> On Sep 26, 2019, at 12:27 AM, Krishnakant Mane wrote: > > >> On 26/09/19 12:03 AM, Adrian Klaver wrote: >>> On 9/25/19 8:04 AM, Rob Sargent wrote: >>> >>> >>> On Sep 25, 2019, at 8:24 AM, Krishnakant Mane >> > wrote: >>> > On 25/09/19 7:50 PM, Adrian

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Krishnakant Mane
On 26/09/19 12:03 AM, Adrian Klaver wrote: > On 9/25/19 8:04 AM, Rob Sargent wrote: >> >> >> On Sep 25, 2019, at 8:24 AM, Krishnakant Mane > > wrote: >> >>> >>> On 25/09/19 7:50 PM, Adrian Klaver wrote: On 9/25/19 12:15 AM, Krishnakant Mane wrote: > Hello all, >>

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Adrian Klaver
On 9/25/19 8:04 AM, Rob Sargent wrote: On Sep 25, 2019, at 8:24 AM, Krishnakant Mane > wrote: On 25/09/19 7:50 PM, Adrian Klaver wrote: On 9/25/19 12:15 AM, Krishnakant Mane wrote: Hello all, I have been using postgresql for an enterprise quality account's auto

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Michael Lewis
> > If the data is held in common tables(bills, vouchers, etc)then the only > thing I see happening is changing the PK values to an unused value. That > could turn into a nightmare though. Not only that you lose the connection > to the original data source. If the data can be broken out into separa

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Rob Sargent
> On Sep 25, 2019, at 8:24 AM, Krishnakant Mane wrote: > > >> On 25/09/19 7:50 PM, Adrian Klaver wrote: >>> On 9/25/19 12:15 AM, Krishnakant Mane wrote: >>> Hello all, >>> >>> I have been using postgresql for an enterprise quality account's automation >>> and inventory management sof

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Krishnakant Mane
On 25/09/19 7:50 PM, Adrian Klaver wrote: > On 9/25/19 12:15 AM, Krishnakant Mane wrote: >> Hello all, >> >> I have been using postgresql for an enterprise quality account's >> automation and inventory management software called GNUKhata >> >> >> Our team is planning to add b

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Adrian Klaver
On 9/25/19 12:15 AM, Krishnakant Mane wrote: Hello all, I have been using postgresql for an enterprise quality account's automation and inventory management software called GNUKhata Our team is planning to add backup and restore function in the software. But we don't w

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Krishnakant Mane
On 25/09/19 4:32 PM, Rob Sargent wrote: > > > On Sep 25, 2019, at 1:15 AM, Krishnakant Mane > wrote: > >> Hello all, >> >> I have been using postgresql for an enterprise quality account's >> automation and inventory management software called GNUKhata >>

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Rob Sargent
> On Sep 25, 2019, at 1:15 AM, Krishnakant Mane wrote: > > Hello all, > > I have been using postgresql for an enterprise quality account's automation > and inventory management software called GNUKhata > > Our team is planning to add backup and restore function in the s

managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Krishnakant Mane
Hello all, I have been using postgresql for an enterprise quality account's automation and inventory management software called GNUKhata Our team is planning to add backup and restore function in the software. But we don't want to dump the entire database and then restore t