Re: Was my question inappropriate for postgres?

2022-07-24 Thread Adrian Klaver
On 7/24/22 18:14, Mladen Gogala wrote: Answers in-line: https://dbwhisperer.wordpress.com/2020/11/21/pyodbc-fast_executemany-and-oracle-rdbms/ MS SQL ODBC 1.7 and Oracle Instant Client 19.9 ODBC drivers and newer do support "fast_executemany". PostgreSQL ODBC 13 does not. Here is the table:

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Mladen Gogala
Answers in-line: On 7/24/22 20:43, Adrian Klaver wrote: Other parts of Office also use database connectivity such   as Access or Word. Also, I find variety in the odbc driver. I don't. ODBC drivers implement the same protocol when communicating with the database and they all work the same.

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Adrian Klaver
On 7/24/22 17:32, Gavin Flower wrote: On 25/07/22 12:19, Adrian Klaver wrote: On 7/24/22 17:15, Gavin Flower wrote: On 25/07/22 11:56, Taka Taka wrote: Hello. I suspect that most people do not know what 'M365' is, would be good to explain.  Am curious as to what 'M365' is! New branding an

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Adrian Klaver
On 7/24/22 17:27, Mladen Gogala wrote: On 7/24/22 19:56, Taka Taka wrote: Hello. I posted question bellow. And? No takers? I wonder why. Maybe the question is unclear? This is really surprising :) The question was straight forward and clear. Hello. I would like to know if psqlodbc_13_

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Gavin Flower
On 25/07/22 12:31, Mladen Gogala wrote: On 7/24/22 20:15, Gavin Flower wrote: I suspect that most people do not know what 'M365' is, would be good to explain.  Am curious as to what 'M365' is! M365 is the latest member in the ArmaLite M-16 family of products. It can be connected to database

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Gavin Flower
On 25/07/22 12:19, Adrian Klaver wrote: On 7/24/22 17:15, Gavin Flower wrote: On 25/07/22 11:56, Taka Taka wrote: Hello. I suspect that most people do not know what 'M365' is, would be good to explain.  Am curious as to what 'M365' is! New branding and pricing(subscription) of MS Office.

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Mladen Gogala
On 7/24/22 20:15, Gavin Flower wrote: I suspect that most people do not know what 'M365' is, would be good to explain.  Am curious as to what 'M365' is! M365 is the latest member in the ArmaLite M-16 family of products. It can be connected to database to track down the DBA who don't check the

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Mladen Gogala
On 7/24/22 19:56, Taka Taka wrote: Hello. I posted question bellow. And? No takers? I wonder why. Maybe the question is unclear? This is really surprising :) Hello. I would like to know if psqlodbc_13_02 is compatible with M365. Also, could you please tell me which of the psqlodbc_13_02

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Adrian Klaver
On 7/24/22 17:15, Gavin Flower wrote: On 25/07/22 11:56, Taka Taka wrote: Hello. I suspect that most people do not know what 'M365' is, would be good to explain.  Am curious as to what 'M365' is! New branding and pricing(subscription) of MS Office. Microsoft 365 https://www.microsoft.com/e

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Gavin Flower
On 25/07/22 11:56, Taka Taka wrote: Hello. I posted question bellow. Hello. I would like to know if psqlodbc_13_02 is compatible with M365. Also, could you please tell me which of the psqlodbc_13_02 would be suitable to Windows 10 64-bit? Was my question inappropriate? I wanted to know if the p

Re: Was my question inappropriate for postgres?

2022-07-24 Thread Adrian Klaver
On 7/24/22 16:56, Taka Taka wrote: Hello. I posted question bellow. Hello. I would like to know if psqlodbc_13_02 is compatible with M365. Also, could you please tell me which of the psqlodbc_13_02 would be suitable to Windows 10 64-bit? Was my question inappropriate? It was appropriate. It

Was my question inappropriate for postgres?

2022-07-24 Thread Taka Taka
Hello. I posted question bellow. Hello. I would like to know if psqlodbc_13_02 is compatible with M365. Also, could you please tell me which of the psqlodbc_13_02 would be suitable to Windows 10 64-bit? Was my question inappropriate? I wanted to know if the pdbc driver above would be compatible

Re: Queries in another user's tables

2022-07-24 Thread Adrian Klaver
On 7/24/22 00:37, xav...@datolibre.com wrote: Hello friends, I have a database base01 that belongs to user01 and on the other hand a datebase base02 that belongs to user02. I need user01 to make a query "SELECT * FROM base02.yourtable;" How can you get this? In what client are you doing thi

Re: Strange behavior between timestamp and date comparison

2022-07-24 Thread Adrian Klaver
On 7/23/22 03:04, Ludwig Isaac Lim wrote: Hello: Below is a sample case that exhibits a behavior that I can't explain: -- create the table create table ts (t timestamp without time zone); -- populate insert into ts(t) values ('2022-07-16 00:22:06.974000'); insert into ts(t) values ('2022-07-16

Re: Strange behavior between timestamp and date comparison

2022-07-24 Thread Rory Campbell-Lange
On 23/07/22, Ludwig Isaac Lim (ludz_...@yahoo.com) wrote: > Below is a sample case that exhibits a behavior that I can't explain: > > -- create the table > create table ts (t timestamp without time zone); > > -- populate > insert into ts(t) values ('2022-07-16 00:22:06.974000'); > insert into ts(

Strange behavior between timestamp and date comparison

2022-07-24 Thread Ludwig Isaac Lim
Hello: Below is a sample case that exhibits a behavior that I can't explain: -- create the table create table ts (t timestamp without time zone); -- populate insert into ts(t) values ('2022-07-16 00:22:06.974000'); insert into ts(t) values ('2022-07-16 00:22:06.974000'); insert into ts(t) values

Unable to archive logs in standby server

2022-07-24 Thread Meera Nair
Hi team, With non-exclusive backup method, trying backup from standby node. But pg_stop_backup function returns "WAL archiving is not enabled..." and the logs are not archived to WAL directory configured. Please check if I am missing anything in configuring this properly, Server was restarted af

Re: Queries in another user's tables

2022-07-24 Thread Pavel Stehule
Hi ne 24. 7. 2022 v 9:38 odesílatel napsal: > Hello friends, I have a database base01 that belongs to user01 and on the > other hand a datebase base02 that belongs to user02. I need user01 to make > a query "SELECT * FROM base02.yourtable;" > > How can you get this? > see https://www.postgresq

Re: Logging the query executed on the server

2022-07-24 Thread Steve Baldwin
On Sun, Jul 24, 2022 at 4:29 PM Igor Korot wrote: > > 2 things: > 1. How do I turn this off? ;-) > When you change the setting via 'set', that change is only for the current session. You can revert it with 'set {some param} to default;' or just terminate the session. If you want to make the chan