Re: Plans for partitioning of inheriting tables

2024-10-25 Thread Adrian Klaver
On 10/24/24 12:47 PM, thi...@gelassene-pferde.biz wrote: Hi Up to version 17, partitioning of tables inheriting from other tables is not possible. psql:../code_files/data_storage/PostgreSQL/tables/TOPO_FILES.pg_sql:68: ERROR:  no se puede crear una tabla particionada como hija de herencia

Re: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

2024-10-25 Thread Daniel Gustafsson
> On 25 Oct 2024, at 05:45, 馬 騰飛 wrote: > > Dear PostgreSQL Community, > > After upgrading PostgreSQL to version 16.3, our server encountered the error > "Only AuthenticationClearTextPassword and AuthenticationMD5Password supported > for now. Received: 10" when connecting to the database. > >

Re: Need support

2024-10-25 Thread Adrian Klaver
On 10/24/24 20:13, 侯海军Cole wrote: Hello, postgresql. I've encountered some technical situations when using it, and I need to discuss it with other or postgresql officials. But I can't join Libera Chat, what's going on? The message under Libre.Chat and above the login tells you why. Short vers

Re: Unable to completely uninstall PostgreSQL 14.2 + pgAdmin 6.4

2024-10-25 Thread Adrian Klaver
On 10/25/24 04:38, Magnus Nilsson wrote: Hi It is time to update our aging installation of PostgreSQL 14.2 + pgAdmin 6.4 on our Windows 10 machines. We have a centrally administered environment and we use SCCM to manage installations. However, we are unable to install newer versions of Postgre

Re: Plans for partitioning of inheriting tables

2024-10-25 Thread Adrian Klaver
On 10/24/24 22:33, Thiemo Kellner wrote: Thanks for taking this up. 24.10.2024 22:44:11 Adrian Klaver : 1) Have you looked at?: https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE I do not feel it applies to my case. I tried to create a partitio

Re: Pgsql 16 to 14 using builtin logical

2024-10-25 Thread Asad Ali
Hi Durgamahesh, Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using built-in logical replication. PostgreSQL's built-in logical replication allows for replicating data between different versions of PostgreSQL, provided the source version is higher than or equal to the target ver

Unable to completely uninstall PostgreSQL 14.2 + pgAdmin 6.4

2024-10-25 Thread Magnus Nilsson
Hi It is time to update our aging installation of PostgreSQL 14.2 + pgAdmin 6.4 on our Windows 10 machines. We have a centrally administered environment and we use SCCM to manage installations. However, we are unable to install newer versions of PostgreSQL + pgAdmin from https://www.postgresql.org/

Pgsql 16 to 14 using builtin logical

2024-10-25 Thread Durgamahesh Manne
Hi Can we replicate 16 to 14 using builtin logical similarly pglogical? Regards Durga Mahesh

Need support

2024-10-25 Thread 侯海军Cole
Hello, postgresql. I've encountered some technical situations when using it, and I need to discuss it with other or postgresql officials. But I can't join Libera Chat, what's going on? 固强科技

Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

2024-10-25 Thread 馬 騰飛
Dear PostgreSQL Community, After upgrading PostgreSQL to version 16.3, our server encountered the error "Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10" when connecting to the database. We are currently using .NET Framework version 3.5. If we

Re: Need support

2024-10-25 Thread Daniel Gustafsson
> On 25 Oct 2024, at 05:13, 侯海军Cole wrote: > > Hello, postgresql. I've encountered some technical situations when using it, > and I need to discuss it with other or postgresql officials. But I can't join > Libera Chat, what's going on? The postgres project are not affiliated with Libera Chat i

Re: Plans for partitioning of inheriting tables

2024-10-25 Thread Thiemo Kellner
Am 25.10.2024 um 17:57 schrieb Adrian Klaver: I do not feel it applies to my case. I tried to create a partitioned table that inherits columns from a base table. The documentation you provided the URL seems to speak of realising partitioning by using inheritance. This needs a code example

Plans for partitioning of inheriting tables

2024-10-25 Thread Thiemo Kellner
Am 25.10.2024 um 17:57 schrieb Adrian Klaver: I do not feel it applies to my case. I tried to create a partitioned table that inherits columns from a base table. The documentation you provided the URL seems to speak of realising partitioning by using inheritance. This needs a code example