-----Original Message----- From: Adrian Klaver [mailto:[email protected]] Sent: Thursday, April 6, 2017 4:18 PM To: Ertan Küçükoğlu <[email protected]>; [email protected] Subject: Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi)
> On 04/06/2017 03:27 AM, Ertan Küçükoğlu wrote: > > Sorry for top posting. > > > > I have a serial in master table because I need to know data insertion order. > > DateTime on Raspberry Pi is not accurate due to power loss and lack of > > internet access to fetch correct time from. > > Understand, though it does beg the question, why have the uuid column? > > -- > Adrian Klaver > [email protected] Programmatically it is easier as I can start saving from very bottom detail table instead of having to save first the master table record. Users will directly work on detail tables. Master table will be saved & updated by software automatically as last piece of information. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
