Re: [GENERAL] TimeScaleDB -- Open Source Time Series Database Released (www.i-programmer.info);

2017-04-10 Thread Steve Petrie, P.Eng.
Please see below. - Original Message - From: "Nicolas Paris" To: "Steve Petrie, P.Eng." Cc: Sent: Sunday, April 09, 2017 7:58 AM Subject: Re: [GENERAL] TimeScaleDB -- Open Source Time Series Database Released (www.i-programmer.info); Le 09 avril 2017 à

[GENERAL] TimeScaleDB -- Open Source Time Series Database Released (www.i-programmer.info);

2017-04-08 Thread Steve Petrie, P.Eng.
-knowledgeable list participants have thoughts on this TimeScaleDB project ?? Would there be merit in considering porting some TimeScaleDB functionality into standard Postgres, as a response to NoSQL "competition" ?? Best Regards, Steve * * * Steve Petrie, P.Eng. http://aspetrie.

Re: [GENERAL] overwrite column data select - Postgres 9.2

2016-09-21 Thread Steve Petrie, P.Eng.
Hi Patrick. - Original Message - From: "Patrick B" To: "pgsql-general" Sent: Wednesday, September 21, 2016 1:02 AM Subject: [GENERAL] overwrite column data select - Postgres 9.2 I've got a table with email column: email CHARACTER VARYING(50) DEFAULT ''::CHARACTER VARYING NOT NULL

Re: [GENERAL] WIP: CoC V6

2016-01-14 Thread Steve Petrie, P.Eng.
Please see my two suggestions below. Steve - Original Message - From: "Joshua D. Drake" To: "Neil" ; "Psql_General (E-mail)" Sent: Thursday, January 14, 2016 4:48 PM Subject: Re: [GENERAL] WIP: CoC V6 Hello, I posted this earlier but ended up breaking my own silly rev scheme. S

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

2016-01-08 Thread Steve Petrie, P.Eng.
ginal Message - From: "Andy Colson" To: "Steve Petrie, P.Eng." ; Sent: Thursday, January 07, 2016 10:17 PM Subject: Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method? On 01/07/2016 06:30 PM, Steve Petrie, P.Eng. wrote: Thanks

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

2016-01-05 Thread Steve Petrie, P.Eng.
Thanks to John for your remarks. My reply is posted below. Steve - Original Message - From: "John R Pierce" To: Sent: Sunday, January 03, 2016 4:40 PM Subject: Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method? On 1/3/2016 1:32 PM, Melvi

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

2016-01-05 Thread Steve Petrie, P.Eng.
Thanks to Adrian for your remarks. My replies are posted below. Steve - Original Message - From: "Adrian Klaver" To: "Melvin Davidson" ; "Pavel Stehule" Cc: "Steve Petrie, P.Eng." ; Sent: Sunday, January 03, 2016 4:38 PM Subject: Re:

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

2016-01-05 Thread Steve Petrie, P.Eng.
ithin postgres docs. So a TEMPORARY table will not suffice, but using a tablespace in SSHD for the session operations tables, might yield performance gains like TEMPORARY.. On Sun, Jan 3, 2016 at 3:43 PM, Pavel Stehule wrote: Hi 2016-01-03 20:46 GMT+01:00 Steve Petrie, P.Eng. : *Gre

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

2016-01-05 Thread Steve Petrie, P.Eng.
Thanks to Pavel for your remarks. My reply is posted below. Steve - Original Message - From: "Pavel Stehule" To: "Steve Petrie, P.Eng." Cc: Sent: Sunday, January 03, 2016 3:43 PM Subject: Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Sy

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

2015-11-30 Thread Steve Petrie, P.Eng.
eorge Neuner" wrote in message news:ukdm5b1ni7lv393coa71vf8d0i1mi0p...@4ax.com... On Sun, 29 Nov 2015 05:02:58 -0500, "Steve Petrie, P.Eng." wrote: I should have clarified, that I use the the term "fuzzy" to refer to the probability mechanism, that hooks a small burst of ses

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

2015-11-29 Thread Steve Petrie, P.Eng.
Thanks to George for the Thuderbird email client recommendation. My remarks are below. "George Neuner" wrote in message news:kaed5btl92qr4v8ndevlgtv0f28qaae...@4ax.com... On Wed, 25 Nov 2015 23:39:39 -0500, "Steve Petrie, P.Eng." wrote: My stupid email client softwar

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

2015-11-29 Thread Steve Petrie, P.Eng.
Thanks to George for the helpful comments. My remarks are below. "George Neuner" wrote in message news:gvad5bllba9slstdhkn6ql2jbplgd78...@4ax.com... On Wed, 25 Nov 2015 23:39:39 -0500, "Steve Petrie, P.Eng." wrote: My plan was always, to avoid eventual exhaustion of

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

2015-11-29 Thread Steve Petrie, P.Eng.
Thanks to Jeff for the helpful response. My remarks are below. - Original Message - From: "Jeff Janes" To: "Steve Petrie, P.Eng." Cc: "Tim Uckun" ; "Merlin Moncure" ; "John R Pierce" ; "PostgreSQL General" Sent: Thursd

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

2015-11-25 Thread Steve Petrie, P.Eng.
(Kindly forgive my top-post. My stupid email client software (Microsoft Outlook Express on Win XP) refuses to respect its own "Reply" option settings for inline reply text. I've been looking for a replacement email client but so far without success.) * * * * * * > You don't ever want to delete

Re: [GENERAL] *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?

2015-10-12 Thread Steve Petrie, P.Eng.
sense to me -- I will change the code accordingly. * * * * * * BTW -- this PostgreSQL newbie (bye bye mysql) is getting a nice warm fuzzy feeling, about PostgreSQL and its amazingly helpful community :) Best, Steve * * * Steve Petrie, P.Eng. ITS-ETO Consortium Oakville, Ontario, Canada (905

Re: [GENERAL] *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?

2015-10-12 Thread Steve Petrie, P.Eng.
e BEGIN; command has completed and my PHP program has not yet initiated any new command on the postgres connection. Regards, Steve * * * Steve Petrie, P.Eng. ITS-ETO Consortium Oakville, Ontario, Canada (905) 847-3253 apet...@aspetrie.net - Original Message - From: "rob stone&q

[GENERAL] *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?

2015-10-10 Thread Steve Petrie, P.Eng.
(Thanks to Adrian Klaver & Rob Stone, for their responses to my earlier posting, subject "[GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?". I worked around the unavailability of sqlstate '0' after a successful SQL command, by creating proxy PHP variables $sql_st

Re: [GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread Steve Petrie, P.Eng.
e, in the result returned by the "BEGIN;" query? * * * * * * Now however, based on your posting (that "libpq version 8.4.1 doesn't jell with version 9.3 of PostgreSql") I will upgrade the libpq version to be compatible with version 9.3 of PostgreSql, and then re-tr

[GENERAL] *** CORRECTION -- PLEASE IGNORE *** BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread Steve Petrie, P.Eng.
Greetings To : There was an error in my previous posting -- apologies -- please ignore the posting. Steve

[GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread Steve Petrie, P.Eng.
Greetings To : I am migrating a PHP web application to use PostgreSQL instead of MySQL. And I have never used PostgreSQL before. I have two questions about function pg_result_error_field(...); An extensive search of the web, did not yield a solution to my problem. * * * * * * My PHP program i