How to determine whether I'm running on a standby?

to do that, which is silly. Knowing Postgres idioms, there will probably be a function for this but I was unable to figure out which one. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Can we go beyond the standard to make Postgres radically better?

am sure that your endeavor with Datalog will have similar success. Market decides what is the standard. May the Force be with you. In the mean time, I will still be using SQL. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Can we go beyond the standard to make Postgres radically better?

On 2/10/22 23:56, Guyren Howe wrote: On Feb 10, 2022, at 17:06 , Mladen Gogala wrote: But SQL is a terrible, no good, very bad language. I cannot accept such a religious persecution of SQL without a detailed explanation. I feel like anyone who is defending SQL here isn’t aware of how

Re: Can we go beyond the standard to make Postgres radically better?

't talked about people, I leave that to politicians. Second, I was defending SQL. You've got me confused with somebody else. Last but not least, I didn't bring anything to this list, I was just responding to the posts. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Microsoft Report Builder

-practices-and-lessons-learned-from-the-field/ That means that it will continue to be developed and that you will not waste all that effort. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Babelfish for PostgreSQL

A point of view, I didn't find any differences in the functionality of the PostgreSQL database itself. Amazon RDS incorporates that modification and allows creating Aurora PostgreSQL database with the Babelfish extension from the menu. Regards -- Mladen Gogala Database Consultant Tel: (347)

Re: Can we go beyond the standard to make Postgres radically better?

27;s not interactive, one has to do some pythong programming in order do to that. Unfortunately, it is not possible to just "describe the cursor", the description becomes available after the "execute" call. Hopefully, I understood you correctly. -- Mladen Gogala Datab

Re: Can we go beyond the standard to make Postgres radically better?

do that without rebuilding would be nice. Babelfish Postgres is version 13.5, currently the most prevalent version in the data centers. A library to implement foreign communication protocol primitives would be a very nice thing indeed. -- Mladen Gogala Database Consultant Tel: (347) 321-1217

2 phase commit with FDW

there a way around it? If not, we will need yet another code change and another data source. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: 2 phase commit with FDW

On 2/17/22 13:10, Mladen Gogala wrote: Hi! I am getting the following error when trying to PREPARE transaction which updates both local and foreign table: 2/17/22 12:48:00:657 EST] 0128 RegisteredRes E   WTRN0046E: An attempt by the transaction manager to call prepare on a

Re: 20220226-Clarification regarding delay time of PostgeSQL starting up

didn't show any interesting messages.) Yours, Laurenz Albe Thanks for letting me know, I didn't know that. Are there any such limitations with NFS and NAS devices like NetApp? Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: 20220226-Clarification regarding delay time of PostgeSQL starting up

a DBA for a very long time and I know. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

<    1   2