Re: Oracle to PostgreSQL Migration

On Fri, 2023-03-24 at 08:00 +, Inzamam Shafiq wrote: > Thanks, oracle_fdw can be used, but it doesn't provide real time sync, we > have to > schedule jobs to insert data in actual schema from foreign tables, so some > delay might be there. In addition to the commercial tools that Christophe

Re: PostgreSQL vs MariaDB

On 3/28/23 06:44, Thomas Guyot wrote: On 2023-03-24 07:07, Inzamam Shafiq wrote: Hi Team, Hope you are doing well. Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)?

Re: PostgreSQL vs MariaDB

On 2023-03-24 07:07, Inzamam Shafiq wrote: Hi Team, Hope you are doing well. Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)? Hi Inzamam, I will have my take as well

C function returning a tuple containing an array of tuples

Hello, I have a function written in C language returning a tuple. One of the fields of that tuple is an array of tuples. I obtain the TupleDesc of the outer tuple using get_call_result_type(fcinfo, ... and is working fine. I can't figure how to obtain the TupleDesc of the tuple of the array (the

Re: Binding Postgres to port 0 for testing

Thanks Michael and Erik for the help, I really appreciate it! Thanks for explaining the context why PostgreSQL doesn't allow binding against port 0. I somehow didn't consider looking at the postgres tests, though it makes sense that they need to solve this problem. If I read the perl code correct

Re: Binding Postgres to port 0 for testing

Thanks for the suggestions. I didn't know about pg_virtualenv, that's interesting. Though it seems to achieve something similar as to containerize the test (potentially in a more platform independent way). Though it seems pg_virtualenv is mostly doing what my test driver is currently doing. Trying