Re: [GENERAL] Help on Index only scan

2017-08-13 Thread Ertan Küçükoğlu
> On 14 Aug 2017, at 01:15, Melvin Davidson wrote: > > >> On Sun, Aug 13, 2017 at 5:59 PM, Ertan Küçükoğlu >> wrote: >> Hello, >> >> My table details: >> robox=# \dS+ updates >>

[GENERAL] Help on Index only scan

2017-08-13 Thread Ertan Küçükoğlu
Recheck Cond: (filename = 'Robox.exe'::text) Heap Blocks: exact=1 -> Bitmap Index Scan on update_filename (cost=0.00..4.30 rows=3 width=0) (actual time=0.035..0.035 rows=3 loops=1) Index Cond: (filename = 'Robox.exe'::text) Planni

[GENERAL] ZeosLib database components - uuid inserts using libpq

2017-08-08 Thread Ertan Küçükoğlu
site. I decided to ask here for help. Thanks & regards, Ertan Küçükoğlu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Database structure advise

2017-04-23 Thread Ertan Küçükoğlu
). I appreciate any suggestion on above possible options. New suggestions, experience sharing are always welcome. Thanks & regards, Ertan Küçükoğlu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/p

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 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

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

2017-04-05 Thread Ertan Küçükoğlu
nk fields only? In another words, is it advisable *not* to have a primary key on PostgreSQL table? If answer changes according to OS underlying, I appreciate replies indicates so. Thanks & regards, Ertan Küçükoğlu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie - solved

2017-02-23 Thread Ertan Küçükoğlu
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, February 23, 2017 5:25 PM To: Ertan Küçükoğlu ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie On 02/23/2017 06:08 AM, Ertan Küçükoğlu wrote

Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie

2017-02-23 Thread Ertan Küçükoğlu
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver Sent: Thursday, February 23, 2017 3:55 PM To: Ertan Küçükoğlu ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie On 02

[GENERAL] Latest PostgreSQL on Raspbian Jessie

2017-02-23 Thread Ertan Küçükoğlu
select number 2 solution above, is that latest version library will talk to old version without any problems? 4- I am always open to other suggestions. Thanks. Regards, Ertan Küçükoğlu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Listing missing records

2017-02-19 Thread Ertan Küçükoğlu
Hi Charles, Your example worked just fine. Thank you. -Original Message- From: Charles Clavadetscher [mailto:clavadetsc...@swisspug.org] Sent: Sunday, February 19, 2017 2:04 PM To: 'Ertan Küçükoğlu' ; pgsql-general@postgresql.org Subject: RE: [GENERAL] Listing missing r

[GENERAL] Listing missing records

2017-02-19 Thread Ertan Küçükoğlu
-177f-4a8a-9108-a1b7697e660f',148,'JI20049362','50009','2017-02-06 23:58:00','2017-02-13 13:13:58' When looked in detail you can see that there is no record for date '2017-02-05' above. As a query result I am looking for something like below: JH20065321, 50010, 2017-02-05, Sunday JI2001, 50010, 2017-02-05, Sunday JH20064415, 50010, 2017-02-05, Sunday JI20049362, 50009, 2017-02-05, Sunday JI20049362, 50009, 2017-02-05, Sunday Thanks & regards, Ertan Küçükoğlu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general