Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi)

Поиск
Список
Период
Сортировка
От Ertan Küçükoğlu
Тема Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi)
Дата
Msg-id 026c01d2aedb$5af5ba50$10e12ef0$@1nar.com.tr
обсуждение исходный текст
Ответ на Re: [GENERAL] Advise on primary key for detail tables (OS: RaspberryPi)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [GENERAL] Advise on primary key for detail tables (OS: RaspberryPi)
Список pgsql-general
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Thursday, April 6, 2017 4:18 PM
To: Ertan Küçükoğlu <ertan.kucukoglu@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.klaver@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.



В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Advise on primary key for detail tables (OS: RaspberryPi)
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [GENERAL] A change in the Debian install