Re: There should be a way to use the force flag when restoring databases

2023-08-06 Thread Ahmed Ibrahim
Hi all, I have addressed the pg version compatibility with the FORCE option in drop. Here is the last version of the patch On Tue, Aug 1, 2023 at 6:19 PM Ahmed Ibrahim wrote: > Hi Gurjeet, > > I have addressed all your comments except for the tests. > > I have tried adding t

Re: There should be a way to use the force flag when restoring databases

2023-08-01 Thread Ahmed Ibrahim
herwise it shows errors. In the meantime I will continue trying to do the test cases. If anyone can help on that, I will appreciate it. Thanks On Thu, Jul 27, 2023 at 1:36 AM Gurjeet Singh wrote: > On Sun, Jul 23, 2023 at 6:09 AM Ahmed Ibrahim > wrote: > > > > Hi everyone, &g

Re: There should be a way to use the force flag when restoring databases

2023-07-23 Thread Ahmed Ibrahim
Hi everyone, I have been working on this. This is a proposed patch for it so we have a force option for DROPping the database. I'd appreciate it if anyone can review. On Thu, Jul 20, 2023 at 9:36 PM Gurjeet Singh wrote: > On Thu, Jul 20, 2023 at 2:10 AM Daniel Gustafsson wrote: > > > > > On

Issue in _bt_getrootheight

2023-07-11 Thread Ahmed Ibrahim
Hi everyone, We have been working on the pg_adviser extension whose goal is to suggest indexes by creating virtual/hypothetical indexes and see how it affects the query cost. The hypothetical index shouldn't take any space on the disk (allocates 0 pages)

Re: Inquiry/Help with pg_adviser (problem in index_create function for creating indexes)

2023-06-25 Thread Ahmed Ibrahim
more than 2 days. Some screenshots can be found in the pdf mentioned in the first mail. Thanks all On Sun, Jun 25, 2023 at 2:50 AM Ahmed Ibrahim wrote: > Hi everyone! > > I am new to PostgreSQL community and working currently on project > pg_adviser [https://github.com/DrPostgres/pg_advi

Inquiry/Help with pg_adviser (problem in index_create function for creating indexes)

2023-06-24 Thread Ahmed Ibrahim
Hi everyone! I am new to PostgreSQL community and working currently on project pg_adviser [https://github.com/DrPostgres/pg_adviser/] The extension last worked with version 8.3, and currently I am working to make it support version 16 and then the other active versions. I will give a brief about