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

2017-04-06 Thread Scott Marlowe
On Thu, Apr 6, 2017 at 4: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. Note that serial

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

2017-04-06 Thread Adrian Klaver
On 04/06/2017 06:40 AM, Ertan Küçükoğlu wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, April 6, 2017 4:18 PM To: Ertan Küçükoğlu ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry

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

2017-04-06 Thread Ertan Küçükoğlu
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, April 6, 2017 4:18 PM To: Ertan Küçükoğlu ; 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

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

2017-04-06 Thread Adrian Klaver
the question, why have the uuid column? -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, April 5, 2017 7:17 PM To: Ertan Küçükoğlu ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi) On

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

2017-04-06 Thread Ertan Küçükoğlu
] Sent: Wednesday, April 5, 2017 7:17 PM To: Ertan Küçükoğlu ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi) On 04/05/2017 08:04 AM, Ertan Küçükoğlu wrote: > Hello, > > I have a project which will be mainly built on Raspber

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

2017-04-05 Thread George Neuner
On Wed, 5 Apr 2017 18:04:39 +0300, Ertan Küçüko?lu wrote: >I have a project which will be mainly built on Raspberry Pi and some parts >on Windows. > >I must have a PostgreSQL 9.4.10 running on Raspberry Pi and another >PostgreSQL running on Windows. Though, there is still a possibility that >Wind

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

2017-04-05 Thread Adrian Klaver
On 04/05/2017 08:04 AM, Ertan Küçükoğlu wrote: Hello, I have a project which will be mainly built on Raspberry Pi and some parts on Windows. I must have a PostgreSQL 9.4.10 running on Raspberry Pi and another PostgreSQL running on Windows. Though, there is still a possibility that Windows datab

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

2017-04-05 Thread Ertan Küçükoğlu
Hello, I have a project which will be mainly built on Raspberry Pi and some parts on Windows. I must have a PostgreSQL 9.4.10 running on Raspberry Pi and another PostgreSQL running on Windows. Though, there is still a possibility that Windows database server will be something else that is not kno