-----Original Message----- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, April 6, 2017 4:18 PM To: Ertan Küçükoğlu <ertan.kucuko...@1nar.com.tr>; pgsql-general@postgresql.org 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 > adrian.kla...@aklaver.com 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general