[portaflex]

When I use this code:

PHP Code:

$this->db = \Config\Database::connect($this->base_datos);
$this->query = $this->db->table($this->db_tabla);
$this->db_columnas = $this->db->getFieldNames($this->db_tabla); 


I get the error:

ErrorException: pg_escape_literal() expects parameter 1 to be resource, boolean given

If don't call getFieldNames the error desapears.

Thanks

[InsiteFX]

PHP Code:

$this->db_columnas = $this->query->getFieldNames(); 


[portaflex]

Thank you for the reply, InsiteFX. But CI4 doesn't like that. It throws this error:

Call to undefined method CodeIgniter\Database\Postgre\Builder::getFieldNames()

I think it has to be with loosing connection with the DB.

Thank you.

[kilishan]

Thank you for the reply, InsiteFX. But CI4 doesn't like that. It throws this error:

Call to undefined method CodeIgniter\Database\Postgre\Builder::getFieldNames()

I think it has to be with loosing connection with the DB.

Thank you.

That will be fixed shortly. There is a bug report that came in over the weekend about this that I haven't had a chance to correct yet.

Pull requests are welcome.

[portaflex]

That will be fixed shortly. There is a bug report that came in over the weekend about this that I haven't had a chance to correct yet.

Pull requests are welcome.

You've got it, Kilishan. But I'm not sure it solves the issue. I get very strange behaviour with those three lines:

PHP Code:

$this->db = \Config\Database::connect($this->base_datos);
$this->query = $this->db->table($this->db_tabla);
$this->db_columnas = $this->db->getFieldNames($this->db_tabla); 


I have them in a class returning a complete html table. The Error of loosing $this->ConnID comes from escape() method in system/Database/Postgre/Connection.php ONLY when I invoke through an AJAX call from the paginator in the table. If I just refresh the page, those three lines work well.

Ain't it weird? I can't figure out the solution, it is beyond my knowledge.

Thanks.