Installation failing with postgres

[DrjavaB]

Terms

• Before you openning this issue, i have checked if the issue has already been reported.

Bagisto Version(s) affected

2.1.2

Issue Description

2023_05_26_213105_create_wishlist_items_table ................................. 16ms DONE
2023_05_26_213120_create_compare_items_table ................................... 9ms DONE
2023_06_27_163529_rename_product_review_images_to_product_review_attachments .. 17ms DONE
2023_07_06_140013_add_logo_path_column_to_locales .............................. 1ms FAIL

In Connection.php line 822:

  SQLSTATE[42703]: Undefined column: 7 ERROR:  column "locales/" does not exist             
  LINE 1: update "locales" set "logo_path" = CONCAT("locales/", code, ...                   
                                                    ^ (Connection: pgsql, SQL: update "loc  
  ales" set "logo_path" = CONCAT("locales/", code, ".png") where "logo_path" is null)   

In Connection.php line 605:

  SQLSTATE[42703]: Undefined column: 7 ERROR:  column "locales/" does not exist  
  LINE 1: update "locales" set "logo_path" = CONCAT("locales/", code, ...        
    
```                                                ^                            
                                                                                 



### Preconditions

fresh postgres installation and bagiso latest version.
installation process using cli (`php artisan migrate`) not gui

[rahulthomasdev]

Same issue here. The main problem is in the migration and seed files as it toilered to work with mysql it seems and not with psql, from few errors i confirmed that we need to modify each to work with psql. Now talking about this specific issue, change the line in bagista\bagisto\packages\Webkul\Core\src\Database\Migrations\2023_07_06_140013_add_logo_path_column_to_locales.php to DB::table('locales')->whereNull('logo_path')->update(['logo_path' => DB::raw('CONCAT(\'locales/\', code, \'.png\')')]);

[rahulthomasdev]

I'm encountering difficulties with other migrations too. It seems like the codebase is heavily dependent on SQL/MySQL.

[devansh-webkul]

We dont have postgress support as of now.

[devansh-webkul]

In initial phase our migration files are highly dependent on the mysql files and however postgress is also in our roadmap but this feature is quite time consuming because we need to plan it for existing as well as new users.