? J3 Issue
avatar pviolette-fr
pviolette-fr
25 Apr 2018

Steps to reproduce the issue

Create a Table object on a table in a schema other than public

Expected result

The Table is correctly constructed

Actual result

Error : No columns found for table_name table

Causes

On construction, the table call its getFields() method, which will retrieve the columns information from the postgresql driver by the method getTableColumns($table, $typeOnly = true). The request in this method is hardcoded to only look at the public schema ( joomla-cms/libraries/joomla/database/driver/postgresql.php - line 388).

Looking more closely it seems like there is no support for postgresql schema. Is there any plan to support this functionality in the future ?

avatar pviolette-fr pviolette-fr - open - 25 Apr 2018
avatar joomla-cms-bot joomla-cms-bot - change - 25 Apr 2018
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 25 Apr 2018
avatar franz-wohlkoenig franz-wohlkoenig - change - 25 Apr 2018
Category Postgresql
avatar alikon
alikon - comment - 25 Apr 2018

well,
if we can find some more people that's caring about polyglot persistence,
why not
i'll write a pr for fix the

Create a Table object on a table in a schema other than public

issue

avatar franz-wohlkoenig franz-wohlkoenig - change - 25 Apr 2018
Status New Discussion
avatar brianteeman brianteeman - change - 28 May 2018
Labels Added: J3 Issue
avatar brianteeman brianteeman - labeled - 28 May 2018
avatar alikon
alikon - comment - 24 May 2019

please test #24999

avatar joomla-cms-bot joomla-cms-bot - change - 24 May 2019
Status Discussion Closed
Closed_Date 0000-00-00 00:00:00 2019-05-24 09:50:53
Closed_By joomla-cms-bot
avatar alikon alikon - change - 24 May 2019
Closed_By joomla-cms-bot alikon
Labels
avatar joomla-cms-bot joomla-cms-bot - close - 24 May 2019
avatar joomla-cms-bot
joomla-cms-bot - comment - 24 May 2019

Set to "closed" on behalf of @alikon by The JTracker Application at issues.joomla.org/joomla-cms/20234

avatar alikon
alikon - comment - 24 May 2019

closed as we have a pr to test


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/20234.

Add a Comment

Login with GitHub to post a comment