-----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Thursday, April 6, 2017 4:18 PM To: Ertan Küçükoğlu <ertan.kucukoglu@xxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 > adrian.klaver@xxxxxxxxxxx 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
