pgbackrest concerns and doubts.

2019-12-01 Thread Ajay Pratap
Hello, I am using Postgresql 10 and pgbackrest 2.18 version on centos 7.6 I have few doubts regard pgbackrest. a) what is the log rotation policy for pgbackrest logs. I see it logs on default path /var/log/pgbackrest/-.log what is the log rotation policy of each logs. use case: if i am writing a s

Re: Why are clobs always "0"

2019-12-01 Thread Thomas Kellerer
Arnie Morein schrieb am 01.12.2019 um 18:31: I have tested the most recent driver in three different SQL IDEs, and now with an application I'm writing that uses JDBC metadata, the comment on a field definition also isn't available as a string value. The only thing I ever see regarding data type

Sv: Why are clobs always "0"

2019-12-01 Thread Andreas Joseph Krogh
På søndag 01. desember 2019 kl. 18:31:35, skrev Arnie Morein < arnie.mor...@mac.com >: I have tested the most recent driver in three different SQL IDEs, and now with an application I'm writing that uses JDBC metadata, the comment on a field definition also isn't av

Re: Why are clobs always "0"

2019-12-01 Thread Adrian Klaver
On 12/1/19 9:31 AM, Arnie Morein wrote: I have tested the most recent driver in three different SQL IDEs, and now with an application I'm writing that uses JDBC metadata, the comment on a field definition also isn't available as a string value. The only thing I ever see regarding data type "te

Why are clobs always "0"

2019-12-01 Thread Arnie Morein
I have tested the most recent driver in three different SQL IDEs, and now with an application I'm writing that uses JDBC metadata, the comment on a field definition also isn't available as a string value. The only thing I ever see regarding data type "text" field values are either a 0 or a 1;

Re: MS Access Frontend

2019-12-01 Thread Ron
On 12/1/19 10:46 AM, Michael Nolan wrote: On Sun, Dec 1, 2019 at 8:09 AM Martin Gainty > wrote: that said I think MS missed the boat on 2-phase-commits Microsoft has never really embraced the concept of a multi-user database environment. You haven't use

Re: MS Access Frontend

2019-12-01 Thread Michael Nolan
On Sun, Dec 1, 2019 at 8:09 AM Martin Gainty wrote: > > that said I think MS missed the boat on 2-phase-commits > Microsoft has never really embraced the concept of a multi-user database environment. (It doesn't really understand the concept of a multi-user operating system, either.) -- Mike N

Re: MS Access Frontend

2019-12-01 Thread Martin Gainty
commenting to Jason that majority of my work in the 90s was read from one DB write to another DB via ODBC2JDBC driver https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers/using-openlinks-odbc-jdbc-bridge-to-access-jdbc-data-sources-via-tableau-windows-edition-89094aa33b7b that said I

Re: MS Access Frontend

2019-12-01 Thread Vincenzo Campanella
Il 30.11.2019 19:52, Adrian Klaver ha scritto: On 11/30/19 11:04 AM, Jason L. Amerson wrote: Thanks Martin. I have decided to go another route. I have nothing but problems whenever I use Microsoft products. I personally think that Microsoft was shit when it started, and it is still shit 35 year

RE: Re: Re: Postgres Full Text Search Jsonb Array column does not search for first row

2019-12-01 Thread Dmytro Zhluktenko
The issue was solved with the approach suggested here.https://stackoverflow.com/questions/59049873/postgres-full-text-search-jsonb-array-column-does-not-show-first-row BR, Dmytro. From: Laurenz AlbeSent: 28 листопада 2019 р. 16:39To: Dmytro Zhluktenko; pgsql-general@lists.postgresql.orgSubject: Re: