Re: Timestamp with vs without time zone.

2021-09-21 Thread FWS Neil
y one or the late one. Apple’s APIs give you a choice. The point being that people do expect to see times in local time, but the only real timestamp is UTC and I can’t ever imagine a need to store time zone information related to a timestamp. If you need to store the location that data originated from, then store the location or the Time Zone, but it should not be connected to the timestamp. Location data is completely different than time data. Neil www.fairwindsoft.com

Re: The tragedy of SQL

2021-09-15 Thread FWS Neil
> On Sep 15, 2021, at 2:44 PM, Merlin Moncure wrote: > > On Tue, Sep 14, 2021 at 3:16 PM FWS Neil <mailto:n...@fairwindsoft.com>> wrote: >> >>> On Sep 14, 2021, at 11:10 AM, Michael Nolan wrote: >>> >>> I started programming in 1967, and o

Re: The tragedy of SQL

2021-09-14 Thread FWS Neil
longer be a need for it. This will make the SQL language simpler and easier to use, understand, and reason about. Of course, that might not happen until my grandchildren are retired and in a nursing home. But who knows, stranger things have happened. Neil www.fairwindsoft.com

DBAs using PostgreSQL sought for paid research study

2021-06-30 Thread Neil Turner
research Please note your details will not be used for any other purpose. There are a limited number of research calls so we can't guarantee that everyone will be invited to take part in one. Thanks, Neil Neil Turner Lead product designer, Redgate [signature_789456171]<https://www.redgate

Re: GSSAPI Authentication for pgadmin4 macOS client

2020-10-27 Thread Neil
> On Oct 27, 2020, at 12:23 PM, Tom Lane wrote: > > Sean McDaniel writes: >> I'm using pgadmin4 on a macOS system and I'm having trouble connecting to a >> server of interest. The "Connect to Server" dialog box has a warning: >> "GSSAPI authentication not supported". I cannot proceed beyond tha

Re: CVE-2018-1058

2019-10-16 Thread Neil
> On Oct 16, 2019, at 2:55 PM, Ron wrote: > > On 10/16/19 2:40 PM, Adrian Klaver wrote: >> On 10/14/19 3:27 PM, Lizeth Solis Aramayo wrote: >>> Good afternoon, >>> >>> I am working with postgresql 9.6.15 and I need to restore in a 9.6.5 >>> version, I got an error, and I found this page to

Re: How do I create a Backup Operator account ?

2019-07-29 Thread Neil
for a particular login, only Backup & Restore items. But I'm not > sure how to associate a bank login account with a specific menu setting of a > client tool. > > Could someone give me any ideas or directions? Neil https://www.fairwindsoft.com

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-27 Thread Neil
ge the system. This last part is very important when a failure occurs. You don’t want to have to learn while you are in a failure or recovery situation. The more complex your system is to support high availability the more knowledge you need. If you are unsure of these issues, which are pretty basic system admin and hardware design issues, then you should get someone with experience to help you. Neil https://www.fairwindsoft.com <https://www.fairwindsoft.com/>